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
TI process with parameter
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TI process with parameter
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.)
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.)
Declan Rodger
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: TI process with parameter
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.
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.