The TABDIM function made useful

[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?

[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.

[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!