Script Logic problem - default.lgf

100 Views

Hi

I have an input schedule and when I saved the data, I need to derive values (year month) to another dimension (Year) (which will be used for annual planning).

BPC 10.0

input schedule 1:

Year 0001 0001 0001 0001

Product Time 2017.01, 2017.02, 2017.03 .... 2018.01, 2018.02

B

C

D

My default.lgf:

* XDIM_MEMBERSET TIME =% TIME_SET%

* XDIM_MEMBERSET YEAR =% YEAR_SET%

* WHEN YEAR

* IS "0001"

* FOR% TP =%%% TIME_SET

* SELECT (% YEAR2%, [YEAR], TIME, ID =% TP%)

* REC (EXPRESSION =% VALUE% YEAR =% YEAR2%)

* NEXT

* ENDWHEN

* COMMIT

ERROR

Error executing logical proposal ()

Memb. "" Does not exist

I want to replace the value in the year 0001 for the "year.month" inserted.

note: input schedule has one or more periods .example from 2017.01 to 2019.01

Thanks and Regards