Hi we have an issue at times were the public subsets created on dimension gets cleared randomly.
Can yuo guys tell me where should i start trouble shooting this .
Some times it happens after server restart , sometimes it happens randomly when server is running.
Thanks,
Tm1 public subsets gets cleared
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Tm1 public subsets gets cleared
If subsets are "getting cleared" then it's because elements are being deleted and added back to the dimension. To avoid this unwind the dimension rather than deleting elements. There are plenty of topics you can find on unwinding dimensions.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: Tm1 public subsets gets cleared
I would inestigate the previous sugestion as there are risks with deleting and re-inserting elements. However you could perhaps make your subsets dynamic with MDX instead of static members, or recreate the subsets when you rebuild the dimension in TI.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Tm1 public subsets gets cleared
Indeed. As a general rule I make all my user subsets MDX-based, if possible, even if it only has one member to avoid the problem noted in this thread.
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Tm1 public subsets gets cleared
Okay I am using the below code to remove my levels from hierarchy in my dimension,This is the only one I can think of where the dimension element is touched again.
This will remove the element from its parent and put seperatley.
vMax = DIMSIZ(vDim);
vCount = 1;
WHILE (vCount <= vMax);
vElem = DIMNM(vDim, vCount);
vMaxParents = ELPARN(vDim, vElem);
WHILE (vMaxParents>0);
vParent = ELPAR(vDim, vElem, vMaxParents);
DimensionElementComponentDelete(vDim, vParent, vElem);
vMaxParents = vMaxParents - 1;
END;
vCount = vCount + 1;
END;
Could this cause an issue .For example I create a manual subset with two members from level2 . They get deleted randomly .
This will remove the element from its parent and put seperatley.
vMax = DIMSIZ(vDim);
vCount = 1;
WHILE (vCount <= vMax);
vElem = DIMNM(vDim, vCount);
vMaxParents = ELPARN(vDim, vElem);
WHILE (vMaxParents>0);
vParent = ELPAR(vDim, vElem, vMaxParents);
DimensionElementComponentDelete(vDim, vParent, vElem);
vMaxParents = vMaxParents - 1;
END;
vCount = vCount + 1;
END;
Could this cause an issue .For example I create a manual subset with two members from level2 . They get deleted randomly .
-
- MVP
- Posts: 3120
- 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: Tm1 public subsets gets cleared
If you don't delete elements from the dimension, this cannot be the reason that subsets would lose their elements. What you do is unwinding in the dimension (which is good and I also do that) but as Lotsaram already wrote unwinding is not the cause, it's deleting and reinserting elements.
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