TM1, Rules Cube, DIMIX function

[gdunster]

I have several questions around this function. 
The book says the DIMIX format is DIMIX(server_name:dimension, element). 
I have seen examples in the book used in two ways, One: DIMIX('Month',!Month) and DIMIX(!Month,'Month'). 
What is the differance between 'Month' and !Month? 

Second questions, where do you find the element name in a time dimension?  I see attributes and aliases but how do you find the element name to use in this function?

Third question, how can you use attributes?  where can you see them in a report?

Thanks, in adviance.  Garry

[MFGF]

I'm moving this to the TM1 forum as you are more likely to get an answer in there :)

MF.

[Brandon Miller]

Not certain what book you are talking about, you should be looking at the TM1 Reference Guide. The correct syntax is: DIMIX(server_name:dimension, element)

So in your example below, DIMIX('Month',!Month) would be correct. Note that in Architect the server name is typically never used, for example DIMIX(server_01:Month, !Month). When you let Performance Modeler develop code for you the server name will often times be put in the code but it is not necessary.

1. 'Month' is a hardcoded dimension name. When used a rule !Month is telling the rule to evaluate each element in the Month dimension through the DIMIX function. If you did something like DIMIX('Month', 'Feb'). Then only Feb will be evaluated in the function. When using the !Month expression your are essentially saying: DIMIX('Month', 'Jan') then DIMIX('Month', 'Feb') then DIMIX('Month', 'Mar'). etc. The TM1 documentation has some decent explanations on the bang (!) and how it is used.

2. Make certain no Alias is turned on when you are in a subset editor and that is the element name. You can also use Aliases in your function as they work interchangeably with the element name. If you need to look up an attribute for an element then you can use the ATTRS or the ATTRN functions. Remember that text and numeric attributes have no uniqueness requirement.

3. I assume you are referring to creating a report in Report Studio? When you are creating the FM package for your cube you chose to have the display name use either the element ID or an Aliases and you can do this assignment for each different dimension. Text and Numeric attributes will show up for you in Report Studio when you first expand your dimension.