Skip to Content
0
Former Member
Sep 30, 2011 at 06:38 PM

[BPC75NWSP9] Error with custom measure

27 Views

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é