MicroStrategy ONE

Enabling dynamic sourcing for Intelligent Cubes

By default, dynamic sourcing is disabled for Intelligent Cubes, and therefore they are not available for reports to check whether data requirements can be satisfied by the Intelligent Cube.

You can enable dynamic sourcing for Intelligent Cubes individually or you can enable dynamic sourcing for all Intelligent Cubes within a project. The following options are available for defining default dynamic sourcing behavior for Intelligent Cubes in a project:

  • Enable dynamic sourcing: Select this check box to enable dynamic sourcing for the project. By enabling dynamic sourcing, you can define the following Intelligent Cube default options:

  • Make Intelligent Cubes available for dynamic sourcing by default: Select this check box to enable dynamic sourcing for the Intelligent Cubes. You can clear this check box to disable dynamic sourcing for Intelligent Cubes.

  • Allow dynamic sourcing even if outer join properties are not set: Select this check box to allow reports to connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined. Selecting this check box allows more reports to access Intelligent Cubes using dynamic sourcing. However, this can cause incorrect data to be returned in certain scenarios when outer joins would be helpful.

    Rather than selecting this option, you can define your Intelligent Cube and the metrics used in the Intelligent Cube to support and use outer joins when necessary. This ensures all data is returned. However, outer joins can cause additional load on your database and require larger Intelligent Cubes. You can enable this support by defining the metric join type options, as described below:

  • Metric Join Type: Any metrics included in the Intelligent Cube that are to be available for dynamic sourcing must be defined to use outer joins in the Intelligent Cube. With the Intelligent Cube open,from the Data menu,select Report Data Options. In the Report Data Options dialog box,expand Calculations, and select Metric JoinType. For each metric to make available for dynamic sourcing, change the Join Type to Outer. Click OK to save your changes.

For information on enabling dynamic sourcing for Intelligent Cubes at the project level, see Accessing the dynamic sourcing VLDB properties for a project.

The steps below show you how to enable or disable dynamic sourcing for an individual Intelligent Cube.

Prerequisite

  • An Intelligent Cube has been created in a project.

To enable or disable dynamic sourcing for an Intelligent Cube

  1. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligent Cube opens in the Report Editor.

  2. From the Data menu, select Configure Intelligent Cube. The Intelligent Cube Options dialog box opens.

  3. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for dynamic sourcing by default options to enable or disable dynamic sourcing for the Intelligent Cube:

    • To enable dynamic sourcing for the Intelligent Cube, select Enabled.

    • To disable dynamic sourcing for the Intelligent Cube, select Disabled.

    • To specify that the Intelligent Cube inherits its dynamic sourcing behavior from the project settings, select Use Default Project-Level Behavior.

  4. In the Dynamic Sourcing area, use the Allow dynamic sourcing even if outer join properties are not set options to determine if reports can connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined:

    • Enabled: Select this option to allow reports to connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined. Selecting this option allows more reports to access Intelligent Cubes using dynamic sourcing.

    • Disabled: Select this option to prohibit reports from connecting to Intelligent Cubes using dynamic sourcing when some outer join properties are not defined. Selecting this option avoids the possibility of displaying incorrect data in reports.

  5. Click OK. The Intelligent Cube Options dialog box closes and you are returned to the Intelligent Cube.

  6. Click Save and Close to save your changes and close the Report Editor.