Skip to Content
0
Jun 18, 2015 at 02:19 PM

ROY BPC Custom Measure

110 Views

Hi,

We are on BPC 7.5, Netweaver base BW 7.4

We use currently a standard YTD measure using period as follows;

MEMBER [MEASURES].[YTD] AS 'IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME%].[LEVEL00], [%TIME%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME%].[LEVEL00], [%TIME%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[LEVEL03])),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[LEVEL03])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3

and I would like to create a custom ROY(Rest of Year (future Periods)) measure in which will be able sum next periods while you are on current period.

Please advise on how I can modify the above formula to cater for my requirements.

Description : Rest of the Year

Formula name : ROY

Thanks,

Themba