It seems that if you manually place elements in a particular order within a dimension then that manual placement is lost once you introduce any automatic sort or change the sort order then save the dimension. If you set the auto sort off again then you do not get the manual placement restored.
This seems a shame when TM1 could keep track of this internally. Does anyone know a way round this?
Loss of original element order after auto sort switched on
-
John Hammond
- Community Contributor
- Posts: 300
- Joined: Mon Mar 23, 2009 10:50 am
- OLAP Product: PAW/PAX 2.0.72 Perspectives
- Version: TM1 Server 11.8.003
- Excel Version: 365 and 2016
- Location: South London
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Loss of original element order after auto sort switched on
.xdis are a pretty good way of ensuring that the sort order that you want can be established or re-established on demand.John Hammond wrote:It seems that if you manually place elements in a particular order within a dimension then that manual placement is lost once you introduce any automatic sort or change the sort order then save the dimension. If you set the auto sort off again then you do not get the manual placement restored.
This seems a shame when TM1 could keep track of this internally. Does anyone know a way round this?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.