on 04-16-2014 11:43 AM
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
Hi Mathias,
Were you able to resolve the above issue. I have a similar requirement too.
Thanks
Rakesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.