Adding new element to measure dimension

Post Reply
Arb1486
Posts: 19
Joined: Mon Jul 09, 2018 12:45 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: MS Excel 2010

Adding new element to measure dimension

Post by Arb1486 »

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.
ascheevel
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

Post by ascheevel »

Yes of course, provided you aren't inserting the new element as a child of an already existing zero level element.
Wim Gielis
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

Post by Wim Gielis »

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.
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
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

Post by Wim Gielis »

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
Arb1486
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

Post by Arb1486 »

Thank you All for the detailed explanation!
Post Reply