TM1 Forum

hi,

i am trying to create a dimension using perspective excel. can you please tell me how to create attribute using excel??

thanks
angel

angel1234 wrote: i am trying to create a dimension using perspective excel. can you please tell me how to create attribute using excel??

The TM1 reference manual tells you what worksheet and macro functions are available to Perspectives in Excel. You'll note that there isn't one for creating an attribute. This would need to be done either through the Server Explorer interface or via API code.

If you want to populate an EXISTING attribute with a new value, however, you can use the DBSA worksheet function.

Do you need to do this through Excel?

You can do it using the AttrInsert function in Turbo Integrator. If you need to initiate this from Excel then you can add an Action Button to trigger the TI Process and pass in a parameter of the Attribute to be added.

Personally when adding attributes I usually use a TI process that I developed which takes parameters to the Dim, Attribute Name and Attribute Type. I find that using the Server Explorer Edit Element Attributes option can take an age on large dimensions.

Usually, attributes are usually only created during development, and it is only the attribute values that change during normal operation, so as Alan said, I suspect that what want is just to change an attribute value. In which case DBSA will do the trick.

Regards

Paul Simon