Supporting report execution through dynamic sourcing

When creating reports, you can enable and increase your chances that your report utilizes dynamic sourcing by following the recommendations below.

First, you must enable dynamic sourcing for your report. This can add some overhead to the execution of your report to check whether there are any Intelligent Cubes that meet the data requirements of your report. This overhead usually has no effect on performance. If an Intelligent Cube can be used, the report results can be returned quickly from the in-memory copy of data rather than querying the data warehouse. To enable dynamic sourcing for reports, see the In-memory Analytics Help.

The simpler your report is, the more likely it is that your report can connect to an Intelligent Cube to satisfy its data requirements. This does not mean that you should create reports with minimal data simply to take advantage of dynamic sourcing. However, the considerations listed below can help guide you to create a report to meet your reporting requirements as well as be well-suited for dynamic sourcing:

• Avoid the use of features that prevent the use of dynamic sourcing, which are described in the In-memory Analytics Help.

• Only add objects that are relevant to the analysis required for the report. When creating a report, you should determine whether certain attributes, metrics, advanced filtering techniques, and so on are required for the report or are extraneous to the analysis requirements of a report.