Skip to Content
0
Former Member
Feb 15, 2011 at 05:29 PM

Periodic Measure does not calculate correctly (YTD application)

31 Views

Hello,

We are on BPC version 7.5 and we are using a YTD application for consolidation. The system does not calculate January Periodic values correctly. (It basically substracts Jan YTD. value from Dec.YTD value of the previous year which obviously is incorrect) I have checked the OSS notes and there is a note: 1447507 pertaining to this issue but the note just states that the Measuresformula table is not set up correctly and it has to be redesigned.

I therefore checked up the MDX formula in the Measuresformula table for SEQ 210 i.e. Periodic formula for YTD. The original formula is as follows:

IIF(([%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="LEQ" OR [%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="AST") AND NOT ([%TIMEDIM%].PROPERTIES("ISBEGINNING")="1"),[MEASURES].[YTD],[MEASURES].[YTD]-([MEASURES].[YTD],[%TIMEDIM%].LAG(1)))

This seems to be incorrect, so I modified it as follows:

IIF(([%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="LEQ" OR [%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="AST"),[MEASURES].[YTD],IIF(([%TIMEDIM%].PROPERTIES("ISBEGINNING")="1"),[MEASURES].[YTD],[MEASURES].[YTD]-([MEASURES].[YTD],[%TIMEDIM%].LAG(1))))

But the periodic calculations for January somehow does not work even after the modification.

Do you have some suggestions?

Raja