Cleansing Exercise

[LeeTaylor1979]

Hello All.

I am currently having a tidy up ready for the new year.

What I want to do is using a list of Cubes (In Excel) put all the Dimensions used in each of these cubes.

I have found that TABDIM formula should do what i need apart from i have a list of over 100 cubes.

Rather than type in the cube names I am trying to reference cell A1, A2 and so on. eg.

A B
1 AircraftFleetSize =TABDIM("TM1serv:A1"1)
2 AircraftInfo =TABDIM("TM1serv:A2"1)
3 AircraftMaterials =TABDIM("TM1serv:A3"1)

This does not work.

Can anyone point in the right direction so I don't have to type out over 100 TABDIM formulas ?


Regards


Lee

[Martin Ryan]

You can use this as a starting point. It does the reverse (gives a list of unused dims), but you'll be able to butcher it for your requirements.

Martin

[Mike Cowie]

AircraftFleetSize =TABDIM("TM1serv:A1"1)

In order to reference what is in cell A1 the formula should be something like:

Code: Select all

=TABDIM("tm1serv:" & $A1, 1)

(Note I made the reference an absolute column reference in case you copy the formula across columns).

The reference to the dimension index can, of course, also be a cell reference too if you wanted to list 1 - n across columns. Then you could just write one TABDIM formula and copy it down and across.

Hope that helps.

Regards,
Mike

[LeeTaylor1979]

Thanks Guys,

I have opted for Mikes suggestion which has worked exactly how I wanted.

Martin I will keep your link though if that ok for future exercises.


Regards

Lee

[Steve Vincent]

Lee, take a look at the TM1pedia that Duncan designed. Its a method of documenting a TM1 installation but part of it does exactly what you are looking for, and more besides

[LeeTaylor1979]

Steve I totally forgot about this.

Duncan passed it to me when he left.


Cheers


Lee