Strategy ONE
Enable Dynamic Sourcing for Report
Enable Dynamic Sourcing for Report is an advanced VLDB property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.
By default, dynamic sourcing is disabled for reports, and they therefore retrieve their results by running against the data warehouse. 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 by modifying the Enable Dynamic Sourcing for Report VLDB property. This VLDB property has the following options:
- Disable dynamic sourcing for report: Dynamic sourcing is disabled for reports.
- Enable dynamic sourcing for report (default): Dynamic sourcing is enabled for reports.
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 defining a project-wide dynamic sourcing strategy, see the In-memory Analytics Help.
Levels at Which You Can Set This
Project, report, and template