Symptom
In BPC 7.5 and previous versions, conditional IF statements referencing report data are evaluated before the report is refreshed.
This allows for the creation of conditional formulas that can change the dimension members based on a condition before the report is refreshed:
i.e.: =IF(EVGET($G$2,$F23)=+E33,"InputEntities","NA_IN") will return the dimension member "InputEntities" if True or "NA_IN" if false.
This member can then be used to refresh the report data.
In BPC 10 with the EPM Add-in the EVGET is evaluated after the report is refreshed. This results in the IF condition always returning false during report refresh and the conditional statement will not work as expected.
Read more...
Environment
- SAP Business Planning and Consolidation 10 version for the Microsoft platform
- SAP Business Planning and Consolidation 10 version for NetWeaver
Product
Keywords
KBA , EPM-BPC-MS , Microsoft Version , 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.