Strategy ONE

Partition Large Datasets and Create Search Indexes

If you are importing large datasets into MicroStrategy Workstation, you can divide the dataset into multiple segments called partitions. The data in the partitions is processed simultaneously, improving the performance of your dashboard.

See the In-memory Analytics Guide to determine if your dataset is appropriate for partitioning and how to choose an appropriate partition attribute.

When you choose a partition attribute, all the tables that contain the attribute are partitioned. Creating a search index for an attribute improves performance for filters that use a search box on that attribute.

  1. Open the Preview dialog.
  2. Click All Objects View .
  3. Select an attribute from the Partition Attribute drop-down.

  4. To split your dataset, enter a value in the Number of Partitions textbox.

    The number of partitions should be less than or equal to the number of CPU cores on your machine

  5. To create a search index on an attribute, select the corresponding checkbox
  6. Click Close.