Scenarios that benefit from dynamic sourcing

Dynamic sourcing can greatly improve the performance of your projects, because it allows reports to automatically detect an Intelligent Cube that can satisfy its data requirements, and execute against the Intelligent Cube rather than the data warehouse.

This section also discusses how you can tune your project to better support dynamic sourcing for these features, as described in Tuning your project for dynamic sourcing.

Dynamic sourcing complements the ability to create reports that are connected to a specific Intelligent Cube. This feature gives you the following performance benefits:

• Report designers do not need to know whether an Intelligent Cube includes the information they need, or which Intelligent Cube they should use. With dynamic sourcing, an Intelligent Cube that can satisfy the report's data requirements is detected automatically, without the report designer having to consider which Intelligent Cubes are available.
• The performance of pre-existing reports can be improved without having to modify the report to access a specific Intelligent Cube. Dynamic sourcing can allow these reports to automatically detect an Intelligent Cube that satisfies the report's data requirements.
• The performance of prompted reports can be greatly improved. Prompted reports can cause performance issues, because it is difficult to use report caches with them. When different prompt answers are chosen, a report cache cannot return information for the report and the report request must be submitted through the data warehouse again.
• With dynamic sourcing, Intelligent Cubes can provide a set of data that can satisfy the data requirements of reports executed with different prompt answers.
• Reports can drill from one Intelligent Cube to another Intelligent Cube.