About using Cube Advisor to support dynamic sourcing

MicroStrategy Cube Advisor allows you to create a dynamic sourcing strategy that can best support the reports in your projects. Cube Advisor provides the following features for creating and supporting a dynamic sourcing strategy:

Analyzes reports to determine whether their report definitions can support the use of dynamic sourcing.
Recommends and creates Intelligent Cubes that can be connected to by reports using dynamic sourcing. This includes the following:
- Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing.
- You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube.
Creates the Intelligent Cubes you decide should be created. These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube.

For additional information on dynamic sourcing strategies, see the In-memory Analytics Help.

Prerequisites

You must own the OLAP Services product to use the Cube Advisor tool for creating Intelligent Cubes.
Prior to analyzing and creating Intelligent Cubes with Cube Advisor you must provide a Metric Level file. Cube Advisor uses this log file to help recommend and create Intelligent Cubes. If Cube Advisor is installed on the same machine as the Intelligence Server you connect to, you do not have to manually provide this file. In this scenario, this file is created automatically when using Cube Advisor. To manually create this file refer to the section on Creating the Metric levels log in the In-memory Analytics Help. To enhance display and include performance-based analysis, you can also provide an Enterprise Manager file. For information on how to provide these files, refer to the Options dialog box. For enhanced performance-based analysis, MicroStrategy strongly recommends running Cube Advisor with the Enterprise Manager file.

Accessing the Cube Advisor

To access the Cube Advisor tool, from the Start menu, select Programs, then MicroStrategy, then Tools, and then Cube Advisor.

Using the Cube Advisor

The Cube Advisor is divided into the following screens and dialog boxes. To learn about a specific topic or process, use the links below. For a step-by-step guide to create Intelligent Cubes, use the links sequentially.