Skip navigation.
spilling the beans


| | |

. "Edit Attributes..."
if you get the following message "This operation accesses a dimension containing a large number of elements. The uploading of these elements from the server may take a few minutes. Continue?"
edit directly the attributes cube instead, it is much faster:
- View -> Display Control Objects
- Open the cube }ElementAttributes_dimension
- then modify the required fields like in any cube

. "Add New Attribute"
for large dimensions, it is faster to just create a temporary TI process with the following code in the Prolog
ATTRINSERT('Model',, 'InteriorColor', 'S');
This example creates the InteriorColor string attribute for the Model dimension.

.checking if an attribute/alias already exists
let's say we want to create an alias Code for the dimension Customer.
In Advanced->Prolog Tab:
If(DIMIX('}Element_Attributes_Customer','Code') = 0);

So you do not have to worry about the AttrInsert generating an error if you ever have to run the process again.

If you update aliases in TM1, you will need to clear the excel cache to see the changes by running the macro m_clear or just restart excel.

Average rating
(3 votes)

adding new attribute

I'll have to test if it is possible to add a new attribute by simply adding a new element in the dimension }ElementAttributes_

I dint get the attributes concept

please explain me in detail.. i am not able to enter anything in prolog.. its throwing error..