Skip to Content
0
Former Member
Mar 03, 2015 at 08:20 AM

Scoping from Context value in Logic Script

17 Views

Hi All,

How do we change the fixed value (i.e. 2016.01 in my example script below) to a more dynamic value like to take the value from "CONTEXT" or Time in column Axis?

Thank you for your help.

*XDIM_MEMBERSET TIME = NONE

*WHEN KF

*IS PRICE

*REC(EXPRESSION = %VALUE%, TIME = 2016.01)

*ENDWHEN

*COMMIT

*XDIM_MEMBERSET TIME = 2016.01

*WHEN KF

*IS QTY

*REC(EXPRESSION = %VALUE% * [KF].[PRICE] , KF = Total)

*ENDWHEN

*COMMIT