Element table

Element tables are referenced by the hierarchy ElementsTableName property.

In Element tables, these columns have special meaning:

Column name Expected Data Type Required Explanation
ID nvarchar Yes Contains element name.
ElementType nvarchar No Contains element type. Optionally, use ElementType to specify elements of these types:
  • N: Numeric
  • S: String

If this column is not present or is empty, the type defaults to N.

OrderPosition int No Defines the order in which the elements are created in the hierarchy.
DataSourceId int No Value of this column will be set to 0 in case the row is affected by a manual editing operation.
<columns referenced by dimensionAttribute ElementTableColumnName property> No Value of this column is used to fill in dimension attribute value.