SAP Knowledge Base Article - Preview

2041008 - Excel formula cell is not shifting after a new member is added to the BPC report

Symptom

  • When manually adding a new member on a report (action that also adds a new column to the report) the Excel formulas are not shifted to the next cell as one expects. The cell references become invalid.
  • The same behavior can be reproduced on different EPM Add-in SPs and Patches.
  • Example:
    • Excel formula added to cell E6 to calculate 2006.TOTAL

excel_formula.PNG

    • New member inserted

insert_members.png

    • The formula was not shifted to cell F6 as expected. Note that in this case the formula is still referencing 2006.TOTAL (now on columns F) because sheet option "Keep Formulas Static that Reference Report Cells" is unchecked. 

formula_not_shifted.PNG


Read more...

Environment

SAP BusinessObjects EPM solutions, add-in for Microsoft Office 10.0

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Keywords

EPM Add-in, Formula, Dimension Member, add, BPC, Excel , KBA , best practices , EPM-XLS-REP , EPM XLS Reporting , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.