Periodic Measure does not calculate correctly (YTD application)

[former_member407019]

Hello,

We are on BPC version 10.1 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).

Below is the measurement data and the system support package:

The original formula is as follows:

MEMBER [MEASURES].[YTD] AS 'IIF(([%CUENTA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%CUENTA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ"),-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIEMPO%].[%TIMEBASELEVEL%])), ([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIEMPO%].[%TIMEBASELEVEL%])))' SOLVE_ORDER=3 MEMBER [MEASURES].[PERIODIC] AS 'IIF(([%CUENTA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%CUENTA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP") AND NOT ([%TIEMPO%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="TOTAL" OR [%TIEMPO%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="Q1" OR [%TIEMPO%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN" ), [MEASURES].[YTD]-([MEASURES].[YTD],[%TIEMPO%].LAG(1)), [MEASURES].[YTD])' SOLVE_ORDER=3

Could you tell me how to correct this problem? Thank you very much for your kind help

[benniejayfguevarra]

Hi Diego, can you show an example of AST/LEQ and INC/EXP accounts with data?

[former_member186338]

Please provide screenshot of your time dimension with properties visible!

[former_member186338]

P.S.

How to check your BPC version:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

[former_member407019]

Next I share the image of the time dimension and an image of the transactional data;

[benniejayfguevarra]

Hi Diego,

Please also show the 2019 and 2020 time members and the ACCTYPE of the account in your screen shot.

Thanks,

Bennie

[former_member407019]

Yes, of course. Look;

[former_member186338 · Accepted solution]

You have incorrect values in PERIOD property - have to be ENGLISH: JAN,FEB,MAR....

For JAN you have ENE and this is the reason for incorrect results!

In the standard measure formula you have:

...OR [%TIEMPO%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN"....

[former_member407019 · Accepted solution]

Thank you. As always, you respond to inquiries. It is good to have a great expert like you.