Copy from One to Many members.

[former_member1167574]

As in BPC only one to one copy is possible. So I'm trying to write logic script for copy from one to many.

So, I've created period dimension in which user will select one date & user only will select for how many days that data should be copied. So it'll be a copy from one day to many days copy in period dimension.

Regards,

Mehul Magare

[former_member186338]

Hi Mehul,

Copy from one to many - RUNALLOCATION:

*RUNALLOCATION

*FACTOR=1

*DIM PERIOD WHAT=MEM1; WHERE=MEM2,MEM3,MEM4

*ENDALLOCATION

Vadim

[former_member1167574]

Is this work for any date from user to any number of days he wants?

[former_member186338]

I do not understand what do you mean by number of days... please provide a detailed sample with real dimension members!

Please read:

Vadim

[former_member1167574]

I've P_period_abex time dimension so I've to copy data to the day onwards selected by user.Lets say user enters today's date 14-07-15 so hes should get data for that day and that data should get copied from 15-07-15 till that fiscal period.

[former_member186338]

Sorry, but if you want to get help - spend some time to provide a real sample!

Your explanation is absolutely unclear: "that data should get copied from 15-07-15 till that fiscal period" what do you mean by "till that fiscal period"?

[former_member1167574]

I mean till end of the year. As i'm taking period 1-04-2015 to 31-03-2016 so if user selects 14-07-2015 so that data of 14-07-2015 should be copied to everyday till 31-03-2016. Hope i'm clear now.

[former_member186338]

Something like:

%P_period_abex_SET% - user selects 14-07-2015

The TIMEID property is correctly set for all base members in the increasing order:

20150714,20150715...

Let's assume you have property FYEAR = 2015 for 1-04-2015 to 31-03-2016

Then:

*SELECT(%Y%,[FYEAR],P_period_abex,[ID]=%P_period_abex_SET%) //%Y% - 2015

*SELECT(%TID%,[TIMEID],P_period_abex,[ID]=%P_period_abex_SET%) //%TID% - 20150714

*SELECT(%DAYS%,[ID],P_period_abex,[TIMEID]>%TID% AND [FYEAR]=%Y%)

*RUNALLOCATION

*FACTOR=1

*DIM P_period_abex WHAT=%P_period_abex_SET%; WHERE=%DAYS%

*ENDALLOCATION

Vadim