Hi,
I have done many TI to transfer data based on source view and target view.
For all of them I configure dimensions in the source cube for the data I need to transfer. For the target cube, I create target subsets, target views to clear data, data will be loaded based on elements in the source cube dimensions.
This time is a little different. I need to fill in data on consolidated cells and I want to construct a target view using MDX to exclude elements I don't need and have the process to drop data ONLY into the intersections determined by the target view.
Can it be done? If so, what do I need to specify? I can only think of using IF in Data tab but it seems too complicated.
Thanks!
Kenneth
TI create view for loading data into
-
- MVP
- Posts: 3105
- 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: TI create view for loading data into
A practical example would be good to understand what you mean. In fact, I don't have a clue what you want to do.
Filling in data on consolidated cells seems weird too.
Filling in data on consolidated cells seems weird too.
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
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TI create view for loading data into
I agree with Wim that we need more information:
- Where is the data coming from that you are loading into the target cube?
- If it is a cube, what is the dimensionality of the source and target cubes?
- What do you mean by "fill in data on consolidated cells"? Please be specific.
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: TI create view for loading data into
Thanks Tom and Wim.
Just tested and realized I forgot to name the DataSourceCubeView. It works right after.
To provide details, I was trying to put text to consolidated intersections based on certain criteria. There's no source data cube so to speak but I named the target cube as the source to get the dimensions as variables any way. So I loop the dimensions using MDX to filter the dimension elements to create a view for the intersections I need. I checked the view and works fine.
In "Data" I simply run CellPutS to put text into the intersections without specifying any condition. In my earlier attempts I realized CellPutS ignored my view and loaded into all intersections. Then I realized I didn't specify DataSourceCubeView, once I name it to the view I created it seems to work.
Hope I have explained it clear this time.
Kenneth
Just tested and realized I forgot to name the DataSourceCubeView. It works right after.
To provide details, I was trying to put text to consolidated intersections based on certain criteria. There's no source data cube so to speak but I named the target cube as the source to get the dimensions as variables any way. So I loop the dimensions using MDX to filter the dimension elements to create a view for the intersections I need. I checked the view and works fine.
In "Data" I simply run CellPutS to put text into the intersections without specifying any condition. In my earlier attempts I realized CellPutS ignored my view and loaded into all intersections. Then I realized I didn't specify DataSourceCubeView, once I name it to the view I created it seems to work.
Hope I have explained it clear this time.
Kenneth