The TABDIM function made useful

Suggest and discuss enhancements for TM1
Post Reply
Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

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? :-)
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
User avatar
Alan Kirk
Site Admin
Posts: 6606
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

Post by Alan Kirk »

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.
"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.
Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

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!
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
Post Reply