Subscription and Report Results Troubleshooting

Drilled-To Report Returns No Data or Incorrect Data

If you are using In-memory services, you may drill to a report and find that the new report does not return any data, or returns subtotals that are inconsistent with the subtotals on the parent report. This is because the parent report is using an Intelligent Cube for its data source, and that Intelligent Cube does not contain data at the level you have drilled to.

You can confirm whether a report is connecting to an Intelligent Cube in SQL View. If the SQL View contains the line Intelligent Cubes Accessed: the report is connecting to one or more Intelligent Cubes. The Intelligent Cubes the report is connecting to are listed below that line.

You can disable the use of Intelligent Cubes for a report in the report's VLDB properties. In the VLDB Properties dialog box, in the Advanced category, under Dynamic Sourcing, clear the Enable Dynamic Sourcing check box. Be aware that this causes the report to use the data warehouse instead of the Intelligent Cube, which may cause an unexpected load on the data warehouse.