Skip to Content
avatar image
Former Member

BPC NW 10.1 Classic custom measure issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

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

    Regards,

    Raji P

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2017 at 11:48 AM

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

    Add comment
    10|10000 characters needed characters exceeded