MicroStrategy ONE
Preview and Edit Tables
MicroStrategy ONE (December 2024) introduces the ability to compare and edit logical tables, enabling a streamlined process to make necessary schema changes. Use the table preview dialog to ensure data model consistency, accuracy, and optimization.
Preview Tables
- Open the Workstation window.
- In the Navigation pane, click Objects.
- Select one or more tables.
-
Right-click the table(s) and choose Preview.
You can also access this dialog in the Schema editor. When viewing a schema, right-click a table, and choose Preview.
-
Choose a table view:
- Physical View: Displays the physical elements in the table such as the table name, column, and data type.
- Logical View: Displays the logical organization of the data such as hierarchies, attributes, forms, and metrics.
- Close the preview dialog.
Edit Tables
- Open the Workstation window.
- In the Navigation pane, click Objects.
- Select one or more tables.
-
Right-click the table(s) and choose Edit.
You can also access this dialog in the Schema editor. When viewing a schema, right-click a table, and choose Edit.
-
Choose a table view:
- Physical View: Displays the physical elements in the table such as the table name, column, and data type.
- Logical View: Displays the logical organization of the data such as hierarchies, attributes, forms, and metrics.
-
To instruct MicroStrategy to use the mapped attributes as the primary key and avoid aggregating the table during queries, select the Attributes fully represent the table's primary key check box.
-
Type a value in Logical Size. Logical table sizes affect how the MicroStrategy SQL Engine determines which tables to use in a query. MicroStrategy SQL uses tables with the lowest logical size.
If this field is greyed out, deselect the check box next to Lock Logical Table Size.
-
To prevent users from editing the Logical Size, select the Lock Logical Table Size checkbox.
-
Click Save or Save and Update Schema....