Hi guys,
I have a cube like this:
On the top I have the dimension of period. I want to create a process that will copy data from one period to another.
I tried to do this using the view of the cube as source:
But the period that I am going to copy every time that I run the process should be a parameter that user will choose.
So I thought that is not going to work on this case.
I also think in creating a view on prolog with this specific parameters that I want and then writing the data on cube, but I don't know how to do that. I know how to create a view on prolog, but what I've to do to write on data tab using this view as base?
If anyone has another tip for this I appreciate.
Best regards,
JR.
Filter on TM1
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Filter on TM1
As your process takes a view as data source, your variables will be your dimension elements, plus 1 variable for the value in the cube (that you copy).
So then in the Data tab, use those variables and populate the target cells, for example by keeping everything constant but changing the element for the period.
So then in the Data tab, use those variables and populate the target cells, for example by keeping everything constant but changing the element for the period.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Filter on TM1
Hi Wim,
It worked fine.
Thanks a lot for helping.
Best regards,
JR
It worked fine.
Thanks a lot for helping.
Best regards,
JR