TM1 Forum

Hi All,

I am using Dimesnion Worksheets to create dimensions.
Can we create Attributes using Dimension worksheets. If yes, request you to let me know the process.

TM1 Version: 9.5.1, OS: Windows 2003, Excel Edition: 2003.

Thanks & Regards,
Radhika

If they are only ever created or edited via the XDI then use any column after C to add DBRA formula. If at any point a dim is edited in the server explorer and the user chooses to save over the XDI, the other columns in the XDI will be wiped out.

Yes, this is possible but not officially supported as far as I know, so the usage might cause other trouble, but I am not aware of it.
I use this from time to time instead writing a TI and loop through a list of attribute elements to edit larger attribute dimensions.

Let's say you have a dimension test.dim with respective attribute dimension }elementattributes_test.dim.
If you create a file }elementattributes_test.xdi you can use this to edit attribute elements.
N in col A creates numeric elements as known from other dimension worksheets, letter A creates an alias attribute and G (instead S) comes back with a text attribute.

Gabor

A simpler and less risky approach to creating an }ElementAttributes XDI would be to use an action button to run a generic process to insert a dimension attribute. That way the dimension can be edited entirely from within Excel.

For columns D onwards you can use something like DINNM(DIMIX()) combination with COLUNM()-3 to return attribute values which will automatically update as new attributes are added.

Hi All,

Thank you for the response and approach.

Thannks,
Radhika