cancel
Showing results for 
Search instead for 
Did you mean: 

Formula for Custom Measure HYTD (BPC 10.0 NW)?

Former Member
0 Kudos


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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Mathias,

Were you able to resolve the above issue. I have a similar requirement too.

Thanks

Rakesh

0 Kudos

Hi Rakesh, did you get the answer for the requirements. Am also looking for the solution.