LTD and Allocation

[former_member269849]

Hi experts,

so I have KPI_I01 loaded value

KPI1040 : the cumulated value of KPI_I01  ( AST and we LTD measures life to date)

when I execute  this script in Calculation.LGF

*XDIM_MEMBERSET MEASURES = PERIODIC

*XDIM_MEMBERSET TEMPS=BAS(2015.TOTAL)

*XDIM_MEMBERSET KPI_CDG =KPI_I01

*WHEN_REF_DATA = MASTER_DATA

*WHEN KPI_CDG

*IS *

*REC(EXPRESSION=[MEASURES].[LTD],KPI_CDG=KPI10406)

*ENDWHEN

*COMMIT

and  this script in default .LGF

//Allocation

*SELECT(%LASTTID%,[TIMEID],TEMPS,ID=%TEMPS_SET%)

*SELECT(%Y%,[YEAR],TEMPS,ID=%TEMPS_SET%)

*SELECT(%BS%,[ID],KPI_CDG,ACCTYPE=AST)

*SELECT(%TARGET%,[ID],TEMPS,TIMEID>%LASTTID% AND YEAR=%Y% AND CALC=N)

*XDIM_MEMBERSET KPI_CDG=%BS%

*RUNALLOCATION

*FACTOR=1

*DIM TEMPS WHAT=%TEMPS_SET%;WHERE=%TARGET%

*ENDALLOCATION

*COMMIT

as you can see at the sceershot the allocation does not work  why ?

and the scipt of the custom measures LTD  is SUM([%TEMPS%].[2015.01]:[%TEMPS%].CURRENTMEMBER)

and when I change [MEASURES].[LTD] to [MEASURES].[YTD] it's working

Thank you .

[former_member186338 · Accepted solution]

Sorry, but not clear!

Show the report for KPI_I01

With 3 measures in rows:

PERIODIC

YTD

LTD

What is the ACCTYPE for KPI_I01?

Vadim

[former_member269849 · Accepted solution]

Hi Vadim

thank you for your help ,

the ACCTYPE    of KPI_I01 is  EXP

*and  here are the screnshots

Periodic

YTD

LTD

LTD is not repated overtime i think this is the problem ?

[former_member269849 · Accepted solution]

and here are the resulat that the client is expectiong because  KPI_I is equity so it's LTD not YTD

[former_member186338 · Accepted solution]

Yes! LTD is not complete!

[former_member269849 · Accepted solution]

and how can I resolve that ?

[former_member186338 · Accepted solution]

Learning MDX!

[former_member269849 · Accepted solution]

and what about other solution  to use carryforward to copy the last value of the year to the year and then we use YTD not this LTD measure , is it a good solution ?( or not using the the carryforward but to copy by script )

[former_member186338 · Accepted solution]

Test LTD like:

'IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM([%TEMPS%].[2015.01]:[%TEMPS%].CURRENTMEMBER,-[MEASURES].[/CPMB/SDATA]),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM([%TEMPS%].[2015.01]:[%TEMPS%].CURRENTMEMBER,[MEASURES].[/CPMB/SDATA]),0))';SOLVE_ORDER=3

If you account dimension name is ACCOUNT

[former_member186338 · Accepted solution]

Report:

With LTD measure here:

'IIF([%INACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM([%PERIODS%].[2005.JAN]:[%PERIODS%].CURRENTMEMBER,-[MEASURES].[/CPMB/SDATA]),IIF([%INACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM([%PERIODS%].[2005.JAN]:[%PERIODS%].CURRENTMEMBER,[MEASURES].[/CPMB/SDATA]),0))';SOLVE_ORDER=3

[former_member269849 · Accepted solution]

it's generating CX_SY_CONVERSION_NO_NUMBER exepction .

[former_member186338 · Accepted solution]

When it's generating exception? Screenshot!

I have no issues!

[former_member269849 · Accepted solution]

Thank you so much Vadim