How to create Attributes using Dimension worksheets.

[Radhika]

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

[Steve Vincent]

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.

[Gabor]

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

[lotsaram]

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.

[Radhika]

Hi All,

Thank you for the response and approach.

Thannks,
Radhika