MicroStrategy ONE

Enabling Data Mart Optimization

If you created the data mart table using a different database instance than the primary database instance used by your project, but which points to the same data warehouse, you can enable data mart optimization for the database instance. This can improve the performance of reports that access the data mart.

For example, you have built a data mart report to create an aggregate fact table in your data warehouse. You have specified a database instance that is different from your project's primary database instance, but points to the same data warehouse as the latter. When you execute the report without using data mart optimization, Intelligence Server treats the database instance as one that points to a different database, and the following operations are performed:

  • The results for the data mart are fetched from the warehouse into Intelligence Server's memory.
  • A new table for the data mart is created in the data warehouse.
  • The results are loaded into the table, one row at a time.

However, if you use data mart optimization, the following operations are performed:

  • A new table for the data mart is created in the data warehouse.
  • The results for the data mart are loaded into the new table directly, without being loaded into Intelligence Server's memory.

In this example, using data mart optimization thus results in simpler SQL queries, and can conserve Intelligence Server's resources.

Do not use data mart optimization unless you are sure that the database instance for the data mart points to the same data warehouse as the project's primary database instance.

To Enable Data Mart Optimization

  1. In MicroStrategy Developer, log in to your project source with administrative privileges.
  2. In the Folder List, expand Administration, then expand Configuration Managers, and select Database Instances.
  3. Double-click the database instance for which you want to enable data mart optimization.
  4. Click the Advanced tab.
  5. Under Data mart optimization, select This database instance is located in the same warehouse as, and from the drop-down list, select the primary database instance for your project.