hi,
i am trying to create a dimension using perspective excel. can you please tell me how to create attribute using excel??
thanks
angel
how to create attribute using excel perspective
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: how to create attribute using excel perspective
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.angel1234 wrote: i am trying to create a dimension using perspective excel. can you please tell me how to create attribute using excel??
If you want to populate an EXISTING attribute with a new value, however, you can use the DBSA worksheet function.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: how to create attribute using excel perspective
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
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