TM1 Forum

Hello,

I would like to copy data from one cube to another. When I start the TI-process I would like to set the Year that is beeing copied to the new cube. So the filter for the source_cube for the Year is dynamic.
Is there any way to do this? I tried to use MDX for the subset that I can define for the source_cube_view, but did not really help.

Thanks a lot for your help!

Toto

Toto,

If you want the TI to ask you what year to reference as it kicks off then you need to use the parameters tab...

If you want it to change on its own then you are looking at a subset (as you have already suggested)... e.g. a subset for "Prior Year" etc. but this will require update at some point either by manual interaction or a rollforward TI process (if you already have 1, there is no point creating a TI to update a single element subset.)

Hello Toto,

You could also use or create a SystemInfo Cube to store the year you would like copied, and use a CellGetN to retrieve this value in your process. This may be a better option if you want some measure of flexibility in your TI, but don't need to provide a different year every single time you run it.