SAP Knowledge Base Article - Preview

1376590 - Measures for AST and LEQ accounts are not updated after modifying the Time dimension hierarchy - BPC 7.5 NW

Symptom

After modifying the Time dimension hierarchy, in Periodic measure MDX (take following MDX as an exemple, [%TIME%].[LEVEL02]), LEVEL number is not updated. This will affect the data retrieval for AST and LEQ accounts, because the base members cannot be retrieved correctly based on the [%TIME%].[LEVEL] information. 

Sample MDX for Periodic measure:

MEMBER [MEASURES].[PERIODIC] AS 'IIF([%P_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",-[MEASURES].[/CPMB/SDATA],IIF([%P_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",[MEASURES].[/CPMB/SDATA],IIF([%P_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[LEVEL02])),IIF([%P_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[LEVEL02])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3


Read more...

Environment

  • SAP Business Planning and Consolidation 7.0, version for SAP NetWeaver
  • SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 7.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver

Keywords

AST, LEQ, Measure, MDX, LEVEL, Hierarchy, Time, Dimension, EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver , KBA , EPM-BPC-NW , NetWeaver Version , How To

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.