The TABDIM function made useful

Suggest and discuss enhancements for TM1
Post Reply
Wim Gielis
MVP
Posts: 2646
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

The TABDIM function made useful

Post by Wim Gielis » Sat Sep 20, 2014 8:44 am

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

User avatar
Alan Kirk
Site Admin
Posts: 6295
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: The TABDIM function made useful

Post by Alan Kirk » Sat Sep 20, 2014 10:30 am

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: 2646
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: The TABDIM function made useful

Post by Wim Gielis » Sat Sep 20, 2014 4:25 pm

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

Post Reply