Hello
TABDIM allows us to get the dimension names that make up a cube. Great.
But TABDIM remains the same, even if the cube dimension order gets reordered.
Can't we have an optional 3rd parameter that says:
- if 0 or omitted: give the same result as now, that is, TABDM following the original dimension order
- if 1 or all else except 0: give the result following the current dimension order
In that case we could check whether the s-type elements are currently in the last dimension.
Or am I missing something on this Saturday morning?
The TABDIM function made useful
-
- MVP
- Posts: 3182
- 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:
The TABDIM function made useful
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
- Alan Kirk
- Site Admin
- Posts: 6622
- 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: The TABDIM function made useful
I've yet to have the need to reorder my dimensions, so I can't comment extensively on the effects of doing so. But this seems to me to be a most beneficial suggestion for those who do.
I'd propose that such a change be done in tandem with the creation of a TabDimCount function which returns the number of dims in the cube to finally get rid of the ridiculous situation of having to do a loop of TabDims to find the first empty string.
I'd propose that such a change be done in tandem with the creation of a TabDimCount function which returns the number of dims in the cube to finally get rid of the ridiculous situation of having to do a loop of TabDims to find the first empty string.
"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.
-
- MVP
- Posts: 3182
- 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: The TABDIM function made useful
Hi Alan
Me too, I very seldom reorder dimensions. It's just always good from the first time
But AFAIK, you cannot know whether dimensions were reordered or not, on any given cube.
TabdimCount would be most useful too! And a shame it doesn't already exist. Everything in TM1 centers around cubes and dimension, and we cannot count them in an easy way!
Me too, I very seldom reorder dimensions. It's just always good from the first time
But AFAIK, you cannot know whether dimensions were reordered or not, on any given cube.
TabdimCount would be most useful too! And a shame it doesn't already exist. Everything in TM1 centers around cubes and dimension, and we cannot count them in an easy way!
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