Skip to Content
author's profile photo Former Member
Former Member

LTD and Allocation

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 .

Capture2.PNG (4.5 kB)
Capture1.PNG (7.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 14, 2016 at 08:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.