TM1 Forum

Hi All,

I am trying to delete or replace existing attribute's(alias name) data from }ElementAttributes cube and insert new attribute element from DB view.
My Element attributes cube looks like below :

| }ElementAttributes_DIM
| -----------------------
| Desc | Code(Alias) | Brand_Code | Pr_Desc | Year
DIM |
--------------------------------------------------------------
--Hyundai |
Hyundai-Accent |Hyundai-Accent | 1234 | Hyundai | Accent | 2019
Hyundai-Verna |Hyundai-Verna | 1114 | Hyundai | Verna | 2018
Hyundai-Santro |Hyundai-Santro | 1000 | Hyundai | Santro | 2019

From the year 2020 i am getting new set of codes(code(alias)) to be loaded in Element Attributes cube.

For Eg : from DB view from year 2020
Code(alias) column
HYAC instead of 1234
HYVN instead of 1114
HYSA instead of 1000

My question is how can i replace code(Alias) data in )Element Attributes cube and load a new values from DB view.

It will be grateful if any of you could suggest me with your ideas

TIA
Hselin

An element attributes cube is no different from a data standpoint than any other cube so it can be updated with a simple Turbointegrator process. Check the TI manual for instructions on how to write such a process.

Thanks tom,

I understand attributes cube is no different . My question is how can i replace an alias column values through TI process .

i tried
DimensionElementInsert
DimensionElementComponentAdd

but when i do this i get
"Error: MetaData procedure line (43): Dimension element name "Hyundai-Accent " is an alias for another element in dimension "DIM" "

TIA

AlphaWay wrote: ↑Tue May 26, 2020 3:30 pm Thanks tom,

I understand attributes cube is no different . My question is how can i replace an alias column values through TI process .

i tried
DimensionElementInsert
DimensionElementComponentAdd

but when i do this i get
"Error: MetaData procedure line (43): Dimension element name "Hyundai-Accent " is an alias for another element in dimension "DIM" "

TIA

DimensionElementInsert adds another element to the dimension. Why would you do that if all you want to do is change the alias of an element? Use AttrPutS since an alias is just a text attribute.