Dimension View

The dimension view enables you to preview and edit hierarchical structures in the Staging database, 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 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 all the fields of the dimension view, the table must have columns named ParentID, ElementType, and Weight. 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

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.