TM1 Forum

Hi all

I starting cognos Tm1 version 10.1. I don't understand the difference between DIMNM and DIMIX.

Thanks all

DIMIX returns the index number of an element within a dimension.

e.g. DIMIX('Region','Brazil') returns 1 (or whatever the index of Brazil in the dimension Region is)

DIMNM returns the element of a dimension that corresponds to the index argument.

e.g. DIMNM('Region',1') returns Brazil (or whatever the element of the dimension Region corresponds to the index # of 1)

Does it make sense?

P.S. combined these two functions can achieve powerful results in rules and ti's

Thanks

ET

These 2 functions and many others are covered in the manuals that come with the installation of TM1. While I know it's a pain I would highly recommend going through the user guide as it will help fill in gaps like this,

Jim.

I should have suggested it first before providing examples