Hi All,
Can we add a new element to measure dimension without data loss in cube. Since the cube is dependent to many other cubes via rules.
Adding new element to measure dimension
-
- Community Contributor
- Posts: 287
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Adding new element to measure dimension
Yes of course, provided you aren't inserting the new element as a child of an already existing zero level element.
-
- MVP
- Posts: 3113
- 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: Adding new element to measure dimension
Adding a member cannot result in data losses except if you change an N-level element to a C-level element by inserting the new member as a child of an existing n-level element.
The opposite, removing a member, will most probably lead to a loss of data, or rules/TI processes not performing the way they are set up to perform.
The opposite, removing a member, will most probably lead to a loss of data, or rules/TI processes not performing the way they are set up to perform.
Last edited by Wim Gielis on Fri Dec 21, 2018 2:22 pm, edited 1 time in total.
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: 3113
- 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: Adding new element to measure dimension
To be clear for those who would have doubts, this holds true for all dimensions, not only 'measures' dimensions.
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: 19
- Joined: Mon Jul 09, 2018 12:45 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: MS Excel 2010
Re: Adding new element to measure dimension
Thank you All for the detailed explanation!