How do I trace/debug Custom Measure formula in NW BPC10?

[Former Member]

How can I trace/debug measure formula in NW BPC 10. I like to do a trace of YTD measure from BW backend.

Thanks,

AD

[Former Member]

I am trying to create a custom measure similar to YTD say name NEW_YTD and trying to use the H2 second Hierarchy in Time dimension. How do I specify Hierarchy in the NEW_YTD custom measure. I have copied the formula from YTD to NEW_YTD and tryin gto enter Hierarchy. The current YTD code is as given below with [H2] hierarchy entered. This code does not work.

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

[Former Member]

Thanks Andy. But I have already looked at the link before entering this message.

[former_member186338]

"H2 second Hierarchy in Time dimension" - I don't think it's a right way. To my mind second hierarchy in TIME dimension is not supported well and will create a lot of issues.

Vadim

[Former Member]

Thanks Vadim.

[former_member200327]

What do you mean debug YTD formula? This is an MDX and the whole formula is being sent to either MDX server or HANA MDX. You can see in ABAP what values were substituted in the formula, but deeper than this it goes out of ABAP - so no debug.

[Former Member]

Hi Ajay,

You can't debug.

have a look at some examples.

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/c9/31cc0adc39455482630f8e978ae6c3/content.htm

Andy