Hi experts,
I've defined a custom measure in BPC 7.5 NW SP9 to roll the last 12 months from a date following this tutorial
Here's my customized MDX:
MEMBER [MEASURES].[ROLLING12] AS 'IIF([%CONCEPTO%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(LastPeriods(12,CLOSINGPERIOD([%TIEMPO%].[LEVEL02])),-[Measures].[/CPMB/SDATA]),IIF([%CONCEPTO%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(LastPeriods(12,CLOSINGPERIOD([%TIEMPO%].[LEVEL02])),[Measures].[/CPMB/SDATA]),IIF([%CONCEPTO%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA],CLOSINGPERIOD([%TIEMPO%].[LEVEL02])),IIF([%CONCEPTO%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA],CLOSINGPERIOD([%TIEMPO%].[LEVEL02])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3
Anyway, when I perform a query to the server through EVDRE(), if I've selected MEASURES=ROLLING12, i receive an error like "Errors Found Retrieving Data", any idea of what's happening?
Any suggestions would be appreciated, thanks in advance!
Regards
André