Efficient way to copy value in the Procedure

andreaLin.... · 2025-06-10T09:29:23+00:00

There was an error rendering this rich post.

Hi all,

I'm trying to improve my current Procedure
i have a cube with 3 dim ( Drivers, Month, Type A or B)
My goal is to copy the value from Driver 2 Type A → Driver 3 Type B as you can see in the image below

My step is:
1) copy the original cube into a Temp cube 1
2) Clean the Temp cube 1 using the selection on Driver targeting everything except the Driver 2
3)Copy Temp cube 1 into a Temp cube 2 (Month, Type A or B) using the Refer to function
4)Copy the Temp cube 2 into the original cube

if i don't clean the temp cube 1 first the "refer to" seems to not work well (the value in temp cube 2 will be the sum of every value of Driver 1 , 2 and 3)

i'm not sure if this is the correct way to do it, i hope you can help me

Thanks

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @andreaLin.... ,

if your driver values are only dimensioned by month and driver, do the following

create a temp cube by month only
select the source driver (2); interactive selection?
copy the source (driver 2) into that temp cube
select the target driver (3), maybe as well with an interactive selection
copy the temp cube into cube b extending on driver

That should do the trick.

Best,
Helmut

All comments

Helmut Heimann

Hi @andreaLin.... ,

if your driver values are only dimensioned by month and driver, do the following

create a temp cube by month only
select the source driver (2); interactive selection?
copy the source (driver 2) into that temp cube
select the target driver (3), maybe as well with an interactive selection
copy the temp cube into cube b extending on driver

That should do the trick.

Best,
Helmut