Skip to Content
0

BPC NW 10.1 Classic custom measure issue

Aug 24, 2017 at 11:38 AM

30

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 24, 2017 at 11:56 AM
0
time.png

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

Regards,

Raji P


time.png (55.2 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

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

0
Former Member

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

time-dim.png

Regards,

Raji P

time-dim.png (237.4 kB)
0

BASE_PERIOD is not maintained!

001 - JAN

002 - FEB

etc...

0
Vadim Kalinin Aug 24, 2017 at 11:48 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded