Dimension View

The dimension view enables you to preview and edit hierarchical structures within staging tables, which can then be loaded to OLAP, using hierarchy mappings.

You can also make these adjustments to the tables:

  • Add elements by adding rows to the table.
  • Assign parent elements to create hierarchies.
  • Edit the weights of child elements in relation to their parents.
  • Change the order in which child elements are displayed. You cannot assign an order position to a parent element.
  • Change element types.
  • Edit attribute values.

The Dimension View tab for a table is enabled only if the table has a column named ID. The ID column, typically maps to element names in OLAP hierarchies. In addition, to enable the full functionality of the dimension view, the table must have columns named with these names:

  • ParentID
  • ElementType
  • Weight
  • OrderPosition

If no such columns exist in the table, the associated fields are displayed in the view but are disabled. In addition to these key columns, the dimension view displays any other columns of the table.

Note: You cannot assign a parent element if the ID or Parent ID columns of the table are primary keys.

If the dimension view is enabled for a table, the Dimension View icon is displayed on the table's card in the Relational Modeling dashboard.