Can we maintain a empty tm1 dimension

Post Reply
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Can we maintain a empty tm1 dimension

Post by spartan »

Hello All,

I have a scenario like, a ti process is used to create,insert and delete elements in the dimension, it is behaving normal except for the last element of the dimension. It is creating a dimension and adding the elements in the dimension through ti process and deleting as well. But it is not deleting the last element in the dimension.

1.Can a tm1 dimension be empty, without having any elements?
Wim Gielis
MVP
Posts: 3234
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Can we maintain a empty tm1 dimension

Post by Wim Gielis »

Yes. Did you explore the DimensionDeleteAllElements function ? (to be used with caution)
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Can we maintain a empty tm1 dimension

Post by lotsaram »

spartan wrote: Mon Oct 14, 2019 10:09 am I have a scenario like, a ti process is used to create,insert and delete elements in the dimension, it is behaving normal except for the last element of the dimension. It is creating a dimension and adding the elements in the dimension through ti process and deleting as well. But it is not deleting the last element in the dimension.
Post your code.
If you *think* the TI *should* be deleting all elements but one element is getting left behind then chances are there is something wrong with your code.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Can we maintain a empty tm1 dimension

Post by macsir »

Are you trying to delete the elements from the first to the last?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply