MicroStrategy ONE

Cube Advisor: Options dialog box

The Options dialog box allows you to define the locations for the Metric Level file and the Enterprise Manager file. These files allow Cube Advisor to analyze your project and create Intelligent Cubes. The metric level file is required. The system automatically creates this file for you in certain circumstances, described below, although you can replace the automatically created file with another metric level file if you choose.

To access the Options dialog box, in Cube Advisor, from the Tools menu select Options.

  • Metric Level File: A metric level log file is used to track the use of dynamic sourcing. Cube Advisor uses this log file to help recommend and create Intelligent Cubes to support dynamic sourcing. 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 see Prerequisites for using Cube Advisor in the In-memory Analytics Help.

  • Enterprise Manager File: An Enterprise Manager report provides information on the performance benefits of each Intelligent Cube. While providing an Enterprise Manger report is optional, it includes important performance information related to creating Intelligent Cubes. For information on how to create the Enterprise Manager report, see Enterprise Manager report for Cube Advisor in the In-memory Analytics Help.

  • Ignore Reports That Are Covered By Existing Cubes: Select this option to exclude reports from the Cube Advisor analysis that already connect to an Intelligent Cube. This prevents Cube Advisor from analyzing and recommending Intelligent Cubes for reports that already connect to Intelligent Cubes.

  • Ignore Reports Not In Enterprise Manager File: If you are using an Enterprise Manager file, select this option to exclude reports from the Cube Advisor analysis that are not included in the Enterprise Manager file. This allows Cube Advisor to focus only on the files that were included in the Enterprise Manager file for further performance analysis.