Strategy ONE

Preview and Edit Tables

Starting in Strategy One (March 2025), you can edit object names, access the object editor, and unmap objects while in the Logical View. In the Physical View, right-click an element to create a new object or map it to an existing object.

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

  1. Open the Workstation window.
  2. In the Navigation pane, click Objects.
  3. Select one or more tables.

  4. 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.

  5. 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.
  6. Close the preview dialog.

Edit Tables

  1. Open the Workstation window.
  2. In the Navigation pane, click Objects.
  3. Select one or more tables.

  4. 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.

  5. 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.

  6. In the Logical View, you can perform the following actions:

    • To rename an object, double-click its name in the Logical View, type a new name, and press Enter.

    • To instruct Strategy 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 Strategy SQL Engine determines which tables to use in a query. Strategy SQL uses tables with the lowest logical size.

      If this field is grayed out, clear the check box next to Lock Logical Table Size.

    • To prevent users from editing the Logical Size, select the Lock Logical Table Size check box.

    • To access the object's editor, right-click the object and click Edit in Attribute Editor or Edit in Fact Editor.

    • To unmap the object, right-click the object and click Unmap.

  7. In the Physical View, you can perform the following actions:

    • To create an attribute, attribute form, or fact using the element, right-click the element and click Attribute, Attribute Form in Attribute, or Fact under Create New.

      The new attribute, form, or fact is added to the Logical View, where you can access the editor.

    • To map the element to an existing attribute or fact, right-click the element, click Attribute or Fact under Map to Existing, and choose an attribute or fact.

  8. Click Save or Save and Update Schema....

Related Topics

Create Tables

Create and Edit Hierarchies