Skip to Content
0
Former Member
Apr 16, 2014 at 10:43 AM

Formula for Custom Measure HYTD (BPC 10.0 NW)?

130 Views


Hi All,

Implementing SAP BPC 10.0 NW, I need to implement a Half Year to Date measure.

In transaction SE38 I tried to create the measure HYTD with following formula:

MEMBER [MEASURES].[YTD] AS
'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC"
OR
[%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ"),-([MEASURES].[/CPMB/SDATA],
CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])), ([MEASURES].[/CPMB/SDATA],
CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])))' SOLVE_ORDER=3

MEMBER [MEASURES].[HYTD] AS
'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC"
OR
[%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP"),IIF(([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JUL"
OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="AUG"
OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="SEP"
OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="OCT"
OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="NOV"
OR
[%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="DEC"),(([%TIME%].CURRENTMEMBER,[MEASURES].[YTD])-([%TIME%].CURRENTMEMBER.PARENT.PARENT.FIRSTCHILD.FIRSTCHILD.LEAD(5),[MEASURES].[YTD])),[MEASURES].[YTD]),[MEASURES].[YTD])'
SOLVE_ORDER=3

When I try to save I get following error message:

MDX statement error: The
argument ' IIF((.[2/CPMB/ACCTYPE]="INC" OR
.[2/CPMB/ACCTYPE]="EXP"),IIF(([/CPMBFDKSEI
PARENTH1].[2/CPMB/PERIOD]="JUL" OR

Message no.
UJO_READ_EXCEPTION018

Any ideas how to solve this and implement the HYTD measure?

Thanks a lot!

Mathias