BPC MS GET function

[tommy_pettersson]

We have a input schedule simulating month forecasts based on actuals were script logic does the some of the calculation due to the number of values.

My Question is, is it possible to retrieve a specific month member saved as account value? The value format is TIMEID example Account1 where date value is 20171200.

Trying something like this were the users can change forecast date by them self.

This does not work, but can this be done in some other way.

*SELECT(%TID_X%,ID,TID,"TIMEID='GET(KATEGORI=BUDGET, Account1=DATE, CONTRACT=CONTRACT_NONE, TIME=9999.M, TYP=OTHER, PRODUCT=P1009S, PLINJE=PL_9999)'")

This works and will give 2017.DEC to use with *REC calculation but needs manual change in script *SELECT(%TID_X%,ID,TID,"TIMEID='20171200'"))

Best regards Tommy