MicroStrategy ONE

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 dynamic sourcing for reports individually or you can enable dynamic sourcing for all reports within a project. For information on defining default dynamic sourcing behavior for reports, see Accessing the dynamic sourcing VLDB properties for a project.

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

Prerequisite

  • A project that has been created in MicroStrategy.

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. From the Data menu, select VLDB Properties. The VLDB Properties Editor opens.

  3. From the Tools menu, select the Show Advanced Settings option if it is not already selected.

  4. In the VLDB Settings list, expand Dynamic Sourcing, and then select Enable DynamicSourcing for Report.

  5. Clear the Use default inherited value check box.

  6. Select one of the following options depending on whether you want to disable or enable dynamic sourcing for a report:

    • To disable dynamic sourcing for the report, select Disable dynamic sourcing for report.

    • To enable dynamic sourcing for the report, select Enable dynamic sourcing for report.

  7. Click Save and Close to save your changes to VLDB properties and close the VLDB Properties Editor.

  8. Click Save and Close to save the report and close the Report Editor.