Skip to Content
0
Former Member
Apr 17, 2012 at 12:54 PM

Script: Copy from single member to multiple members with "attribute=X"

15 Views

Hi,

i've struggled with a simple script all afternoon.

I have some data on a specific time dimension. TIME=SALARY.

I want to copy this "set of data" out to all time dimensions which has the attribute "BUDGET=X".

So my challenge is to isolate a specific time im my member set and copy it to multiple members..

My old script is manually maintained.

XDIM_MEMBERSET TIME = "SALARY"

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

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

ETC.

Now I instead want something like:

XDIM_MEMBERSET TIME = "SALARY"

*REC(EXPRESSION = %VALUE%, "ALL PERIODS WITH ATTRIBUTE BUDGET=X").

So instead of having to change my script from time to time - I can just change my masterdata.

Any suggestions or solutions ? :-)

Regards

jdalby