Skip to Content
avatar image
Former Member

R3/R12 Custom MEASURES BPC NW 10.0

Hello Experts,

We are running the following version of BPC:

•NW Version 10.0, SP21

•ABAP Calc Engine

Our model 'S_AND_OP' is a Standard, Periodic and includes the following Dimensions (Types):

•ANALYSIS (Subtable S)

•BRAND (User Defined U)

•CATEGORY (Category C)

•CUSTOMER (Entity)

•DATASRC (Audit)

•INDUSTRY (User Defined U)

•METRIC (Account A)

•PRODUCT (User Defined)

•RPTCURRENCY (Currency)

•SUPPLY_SITE (User Defined)

•TIME (Time)

In our MEASURES Dimension we display data as Periodic, QTR to Date or YTD volumes We are trying to create Rolling 3 and Rolling 12 month Measures.

We have followed the notes and used the suggested code from the following blog, creating the MEASURES using transaction SE38 (UJA_MAINTAIN_MEASURE_FORMULA). http://scn.sap.com/people/robert.marshall/blog/2011/01/04/rolling-12-custom-measure-in-bpc-7x-version-for-ms-and-nw ... but the results aren't quite what we expected to see and are struggling to root cause it.

R3 has the following code:

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

Our R3 produces results that are QTRS.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2016 at 11:08 AM

    Please provide a screenshot of the test report with standard and custom measures.

    Add comment
    10|10000 characters needed characters exceeded