Hi all,
Right now, i am trying to insert a new element into a ElementAttribute dimension. The normal way of me doing in a normal dimension (not element attribute dimension) is to right click onto the dimensionm and select "Edit Dimension Structure". But when i try to do this with my element attribute dimension, the selection went dim and cannot be select. Is this the correct way to insert a element in element attribute dimension?
Secondly, while i failed to insert it with the way mention above, i did tried to insert in through DimensionElementInsert method. This works perfectly fine until whenever i tried to insert something to thr newly added element, obtabCellWriteStatusGet() = 140 occurred. Is there something i should pay attention to.
Thank you for all the help i can get
Cannot insert new element in element attribute dimension
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Cannot insert new element in element attribute dimension
You can right-click the dimension in server explorer, select Edit Element Attributes, and then Edit->Create New Attribute or you can use DimensionAttrInsert in a TI process.
-
- Posts: 5
- Joined: Thu Aug 17, 2017 3:57 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Cannot insert new element in element attribute dimension
Thank you for your rapid reply.
This is exactly i tried to do, but the "Edit Dimension Structure" cannot be select (dim).
Using the ti process method is fine until i tried to insert value into the element, and result the error i mention with my previous post.
This is exactly i tried to do, but the "Edit Dimension Structure" cannot be select (dim).
Using the ti process method is fine until i tried to insert value into the element, and result the error i mention with my previous post.
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Cannot insert new element in element attribute dimension
Are you right-clicking on the attribute dimension or the dimension whose elements you're trying to add attributes for? For example, if I want to add a new attribute to a Product dimension, I right-click the "Product" dimension and select "Edit Element Attributes...", not the "}ElementAttributes_Product" dimension and "Edit Dimension Structure...".
Edit:
Using the TI process, are you inserting the attribute in the Prolog Tab? How are you then trying to add a value to the attribute, are you using AttrPutS or AttrPutN?
Edit:
Using the TI process, are you inserting the attribute in the Prolog Tab? How are you then trying to add a value to the attribute, are you using AttrPutS or AttrPutN?
-
- Posts: 5
- Joined: Thu Aug 17, 2017 3:57 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Cannot insert new element in element attribute dimension
Let me explain my problem in detail here.
Lets say i have a dimension call tradeId, where it stores id import from db. I also have a ElementAttribute cube where it stores some kind of attributes for each of the trade id (attribute a, b, c etc..) the goal i am trying to achive is to add a new attribute for each of the tradeId, let say attribute d.
Yes, i am using AttPutN to insert into the element attribute cube.
Lets say i have a dimension call tradeId, where it stores id import from db. I also have a ElementAttribute cube where it stores some kind of attributes for each of the trade id (attribute a, b, c etc..) the goal i am trying to achive is to add a new attribute for each of the tradeId, let say attribute d.
Yes, i am using AttPutN to insert into the element attribute cube.
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Cannot insert new element in element attribute dimension
Below is sample code for adding "Description" as an attribute to TradeID assuming the TradeID is variable V1 and description is variable V2 off your datasource.
Prolog tab:
Data tab:
Prolog tab:
Code: Select all
AttrInsert('TradeID, '', 'Description', 'S');
Data tab:
Code: Select all
AttrPutS(V2, 'TradeID', V1, 'Description');
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Cannot insert new element in element attribute dimension
As was said before, You can right-click the dimension in server explorer, select Edit Element Attributes, and then Edit->Create New Attribute or you can use AttrInsert in a TI process.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 5
- Joined: Thu Aug 17, 2017 3:57 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Cannot insert new element in element attribute dimension
Dear a,
I got it using was's method. Lesson learned. I am suppose to edit the dimension's element attribute, rsther than directly edit the element attrbute's dimension.
Thx for all the help guys.
I got it using was's method. Lesson learned. I am suppose to edit the dimension's element attribute, rsther than directly edit the element attrbute's dimension.
Thx for all the help guys.