Hello,
I inherited a dimension created via a TI process. I noticed there is a duplicate consolidation.However,when I open the Edit Dimension structure to delete that consolidation, it actually doesnt appear.I am thinking of deleting the whole dimension and just using the Dimension Worksheet since we dont add new dimensions often. Is there a way to do it to ensure I dont lose any data?
I was thinking of doing Export Dimension. Fix the error in the cma file and use that file as the new dimension worksheet. Will that work?
replacing dimension with dimension worksheet
-
Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: replacing dimension with dimension worksheet
yes that will work, but if you *think* you have a dupliacte consolidation but cannot find it in the editor, then its more likely that you don't have a duplicate in the first place. if its not broke don't fix it 
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Re: replacing dimension with dimension worksheet
Hey Steven,
It is in the editor but it only appears after I click the - and then the + of the consolidation.I guess this problem is related to my earlier post about "All" not capturing all hierarchies.
It is in the editor but it only appears after I click the - and then the + of the consolidation.I guess this problem is related to my earlier post about "All" not capturing all hierarchies.
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: replacing dimension with dimension worksheet
Hi telula,
The 'All' button lists all unique elements that are defined in the dimension. If an element (either base level or consolidated level) appears multiple times in the dimension (in different hierarchies), only the first occurrence of the element will be listed.
If you want to open up all hierarchies you can use the 'Expand all elements' button in the subset/dimension editor.
Please note that the duplicate consolidation you're referring to could be added twice in the shown subset, but this does not necessarily need be the case in the actual dimension structure. In this case you only need to change the subset, not the dimension structure.
Michel
The 'All' button lists all unique elements that are defined in the dimension. If an element (either base level or consolidated level) appears multiple times in the dimension (in different hierarchies), only the first occurrence of the element will be listed.
If you want to open up all hierarchies you can use the 'Expand all elements' button in the subset/dimension editor.
Please note that the duplicate consolidation you're referring to could be added twice in the shown subset, but this does not necessarily need be the case in the actual dimension structure. In this case you only need to change the subset, not the dimension structure.
Michel