MicroStrategy ONE

Warehouse Partition Mapping

Warehouse partition mapping is the mapping of partitions, where the mapping is performed by and maintained in the data warehouse.

Workstation does not support creating new warehouse partition mapping or updating existing warehouse partition mapping tables. This means the Add to Project option is disabled, as shown below. Users can preview warehouse partition tables, as well as create or edit attributes and facts based on partition mapping tables.

  1. Choose File > Edit Schema.

  2. Select an environment and project.

  3. In the left pane of the bottom panel, partition base tables are listed under Partition Base Tables. Click a table to view warehouse table data in the database.

  4. In the corresponding preview, you can view partition level attributes, as well as create and edit attributes/facts.