Enabling or disabling dynamic sourcing for projects

By default, projects are enabled for dynamic sourcing. However, you can disable dynamic sourcing for an entire project. This allows project administrators to have project-wide control over the use of dynamic sourcing.

The steps below show you how to enable or disable dynamic sourcing for projects as well as define default dynamic sourcing behavior for Intelligent Cubes.

For information on defining default dynamic sourcing behavior for reports, Intelligent Cubes, attributes, metrics and aggregate tables, see Accessing the dynamic sourcing VLDB properties for a project.

Prerequisite

• A project has been created in MicroStrategy.

Enabling or disabling dynamic sourcing for a project

1. In MicroStrategy Developer, log in to a project source with a user account with administrative privileges.

2. Right-click a project and select Project Configuration. The Project Configuration Editor opens.

3. In the Categories list, expand Intelligent Cubes, and then select General.

4. Perform one of the following to either enable or disable dynamic sourcing:

   • To enable dynamic sourcing for the project, select the Enable dynamic sourcing check box.

   • To disable dynamic sourcing for the project, clear the Enable dynamic sourcing check box.

5. You can define default dynamic sourcing behavior for all Intelligent Cubes in a project, using the check boxes described below:

   • Make Intelligent Cubes available for dynamic sourcing by default: Select this check box to enable dynamic sourcing for all Intelligent Cubes in a project. You can clear this check box to disable dynamic sourcing as the default behavior for all Intelligent Cubes in a project.

   • 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.
     
     To work around this situation, you can define your Intelligent Cube to support and use outer joins when necessary, 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.

6. Click OK to save your changes to the project and close the Project Configuration Editor.

For information on how to enable or disable this dynamic sourcing behavior for individual Intelligent cubes, refer to Enabling dynamic sourcing for Intelligent Cubes.