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?
Can we maintain a empty tm1 dimension
-
- 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
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
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
-
- 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 your code.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.
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.
- 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
Are you trying to delete the elements from the first to the last?