Skip to Content
0
Former Member
Jul 01, 2009 at 05:41 PM

How to copy data with script logic from one part of the database to another

488 Views

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