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