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
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.