How to see the no.of dimensions in cube

想想111

Hello,
thanks in advance.

actually i have 4000 thounds of cubes i just want to see the maximum number of dimensions in cube.anyone of them please helpme on this?


thnaks
advance.

shaochaowei

This may help.


have you heard of doing a search for similar topics before posting a new question?

By the way if you really have 4000 cubes then I think there is something seriously wrong with your model ...

zhutou1989

4000 wow. That's by far the largest number I've heard of. I wonder if this is a conversion from an old Congos Planning model?

hsszjw

still i am not able to full the no.of dimensions in cube? kidly someone help me out on this
?

Esuom

Hi. Are you trying to achieve something like what's shown in the attached - but instead of listing the dimensions and the associated cubes you want to list the cubes only wanting to see how many dimensions each cube contains. There are a few ways to do this. One through the API (as shown in the attachment). The other ways through Excel or a TI process, as covered in the forum.

zerofeng111

mincharug.shulft wrote:still i am not able to full the no.of dimensions in cube? kidly someone help me out on this
?

Check the TABDIM TM1 Excel function.

sjgogo

Could be wrong but sounds like the number of dimensions each cube contains is what's trying to be retrieved. Tabdim would work if you keep going with the index number until you hit a blank for the dimension name.

落日清风

mincharug.shulft wrote:still i am not able to full the no.of dimensions in cube? kidly someone help me out on this?

So what you're saying is that you were either:
(a) Unable to navigate to the thread that Lotsaram pointed you to; and/or
(b) Unwilling to download the workbook that he included in that thread; and/or
(c) Downright determined not to enter your server name in cell B1; and/or
(d) Absolutely committed to not then press the [F9] key?

While people are more than willing to help, in this case you had the solution served up to you on a platter. What, exactly, was the problem that you had with following it?

chenwu521

jrizk wrote:Could be wrong but sounds like the number of dimensions each cube contains is what's trying to be retrieved. Tabdim would work if you keep going with the index number until you hit a blank for the dimension name.

Yup, but when you're not using the API, that is the usual approach for determining the number since neither Excel worksheet functions nor TI give you a function which returns the number of dimensions.

However whack a simple CountA/CountIf function off to the side of Lotsaram's worksheet formulas and bingo, you get the number of dimensions in the cube all neatly lined up. The OP doesn't even give any indication of whether they've tried that, or anything else in that thread.

wanglinyangling

hello,
thnaks for quick reply.
actually i am using 9.0 applix i cann't able to see? could you please let me know in which version i could see it Tm1 dimension mapping??
thanking u.