Hi experts, I would like to create a script logic (which is executed by default.lgf) with the following characteristics.
I would like to copy data from this part of the database:
Account: AA
Entity: xy
Time: 2009.ACT
Assetclass: XYZ
Department: NoDept
Datasrc: Input
IntCo: Non_Interco
Prodline: abc
Category: BudgetV1
RptCurrency: LC
Measures: Periodic
...to this part of the database
Account: BB
Entity: xy
Time: 2009.ACT1
Assetclass: NoClass
Department: NoDept
Datasrc: Input
IntCo: Non_Interco
Prodline: abc
Category: BudgetV1
RptCurrency: LC
Measures: Periodic
As you can see, only dimensions TIME, ASSETCLASS and ACCOUNT differ.
I tried to use the following script logic, but I didn't work (when sending any data into the database, no data was written into the dimensions described above):
=======
*XDIM_MEMBERSET Account=<ALL>
*XDIM_MEMBERSET Entity=xy
*XDIM_MEMBERSET Time=<ALL>
*XDIM_MEMBERSET Assetclass=<ALL>
*XDIM_MEMBERSET DEPARTMENT=NoDept
*XDIM_MEMBERSET IntCo=Non_Interco
*XDIM_MEMBERSET Prodline=abc
*XDIM_MEMBERSET Category=BudgetV1
*XDIM_MEMBERSET Rptcurrency=LC
*WHEN Account
*IS "BB"
*WHEN Time
*IS "2009.ACT1"
*WHEN Assetclass
*IS "NoClass"
*REC(EXPRESSION=GET(Account="AA",Time="2009.ACT",Assetclass="XYZ"))
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
=============
Can anybody help me to do it the right way?
Best regards,
Stefan