Adding in a list of elements into a dimension via active form

[Wim Gielis]

Then the TI code would need to do a DimensionElementInsert as well as DimensionElementComponentAdd.

Strictly speaking, DimensionElementComponentAdd is enough as it will add the child element if it doesn't exist.

Unless you want to choose the InsertionPoint in the dimension, which is typically ''.

[nxw]

Hi All,

Not to worry about users adding it in- this form is only intended to a set number of users within the data team.

It would be a set data source - as in a list from a vendor pricelist.

[lotsaram]

Hi All,

Not to worry about users adding it in- this form is only intended to a set number of users within the data team.

It would be a set data source - as in a list from a vendor pricelist.

You are going about this completely the wrong way. If there is a set datasource, like "the vendor pricelist" for example and you know the format then just use that as a datasource for a TI and have the TI insert the elements into the dimension. Why would you take this list and then copy/paste (or retype) into another interface? Its just an opportunity for a typo or other human error.