Add Alias Attribute to Element

[wigglyrat]

Hello, I have an element that I am adding to a dimension via TI - to do this I have added to the Prolog for the TI:

DimensionElementComponentAdd(s_DimSample, 'All Agency Codes', 'FinGLAdjs', 1)

which has worked fine.

I want to add an alias to this element only 'Finance GL Adjustments'. How would I add this for that element only?

(The TI deletes all elements and rebuilds the hierarchy - 'FinGLAdj' is not included in our data warehouse (which is where the other elements are pulled/created from) so that is why this specific one is added in this manner, individually.)

Many thanks in advance,

[Wim Gielis]

Then you use AttrPutS or CellPutS in the Epilog of the process, to that 1 element and onto the correct alias.

[BariAbdul]

Please go through this link,It is pretty useful:
http://bit.ly/1WNidi4 Thanks

[qml]

Not that there is anything wrong with this approach, but in order not to maintain an additional TI that adds one hardcoded element with some attributes I would change the SQL query of the main process that rebuilds this dimension, so that it returns FinGLAdjs as well. Since this dimension element is not present in your source data warehouse you can just do a select <some static values> from dual and union that with the existing query. That way your existing TI will be able to add this element with attributes without writing or changing any code (except this query change of course).

[wigglyrat]

thank you for your help!

[Wim Gielis]

but in order not to maintain an additional TI that adds one hardcoded element with some attributes

Hello Tom

Do you mean an extra TI process, or just extra statements in the same TI process ?