BPC NW 10.1 Classic custom measure issue

[Former Member]

Hello experts,

We have created a custom measure for last 12 periods as below and is working fine till our BPC systems upgrade. Recently we were upgraded to BW 7.5 HANA with BPC 10.1 classic from BW 7.4 SP13 with BPC 10.1 SP08.

After upgrade on wards this measure is giving last 9 months data instead of 12 months.

'IIF([%ACCOUNTGL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(LASTPERIODS(12,CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]),
IIF([%ACCOUNTGL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(LASTPERIODS(12,CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),[MEASURES].[/CPMB/SDATA]),
IIF([%ACCOUNTGL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA],CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),
IIF([%ACCOUNTGL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA],CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),NULL))))';SOLVE_ORDER=3

Someone please suggest me on this issue. Thank you !

Regards,

Raji P

[Former Member]

time.png

thank you for your reply vadim, attached time dimension screen shot.

Regards,

Raji P

[former_member186338]

Is it a joke??????????????

Where are members and property values?????????

[Former Member]

Apologies , please find the attached clear screen shot. Thank you !

time-dim.png

Regards,

Raji P

[former_member186338]

BASE_PERIOD is not maintained!

001 - JAN

002 - FEB

etc...

[former_member186338]

Please provide screenshot of administration page of your time dimension with properties visible.