Enabling or disabling dynamic sourcing for reports

By default, dynamic sourcing is enabled for reports. You can enable dynamic sourcing for a report so that active Intelligent Cubes (that are also enabled for dynamic sourcing) are checked to see if the report can retrieve its data from an Intelligent Cube. If an Intelligent Cube fits the data requirements of a report, the report can be run without executing against the data warehouse.

You can enable or disable dynamic sourcing for reports by modifying the Enable Dynamic Sourcing for Report VLDB property.

You can enable dynamic sourcing for reports individually or you can enable dynamic sourcing for all reports within a project. While the definition of the VLDB property at the project level defines a default for all reports in the project, any modifications at the report level take precedence over the project level definition. For information on accessing the VLDB Properties Editor for a project to define a default dynamic sourcing option for all reports, see Accessing the dynamic sourcing VLDB properties for a project.

You can track various information related to dynamic sourcing that can help determine why dynamic sourcing succeeded or failed for reports, as described in Tracking the use of dynamic sourcing.

The procedure below describes how to enable or disable dynamic sourcing for an individual report.

To enable or disable dynamic sourcing for a report

1. In MicroStrategy Developer, browse to a report, and then right-click the report and select Edit. The report opens in the Report Editor.
2. Choose Data > VLDB Properties. The VLDB Properties Editor opens.
3. Choose Tools > Show Advanced Settings option if it is not already selected.
4. In the VLDB Settings list, expand Dynamic Sourcing, and then select Enable Dynamic Sourcing for Report.
5. Clear the Use default inherited value check box.
6. Select either Disable or Enable depending on whether you want to disable or enable dynamic sourcing for the report.
7. Click Save and Close twice.