Troubleshooting reports connected to Intelligent Cubes

While reporting on Intelligent Cubes, a few scenarios can produce unexpected results. To troubleshoot these issues, review the following sections.

No data is returned for the report

If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios:

• The view filter for the report is too restrictive (see View Filters). Modify or remove the view filter to attempt to return data for the report. If removing the view filter does not allow the report to return data, the cause may be due to your security filter, as described below.
• Your security filter does not allow you to see the data available on the Intelligent Cube.

Resolving security filter resolution

If security filters are used to maintain data access security, this can cause data to not be displayed for a report connected to an Intelligent Cube.

While this may be due to normal data access security, the data available on the Intelligent Cube may prevent you from viewing all possible data in a data source (see Security filter resolution for reports connected to Intelligent Cubes.) To verify whether there is additional data that is not being returned, you can create or view a report that connects directly to a data source rather than an Intelligent Cube. You can also contact the designers of the Intelligent Cube to review whether additional data can be added to the Intelligent Cube so that it supports your report.

No data is returned for a metric or metrics on the report

If no data is returned for a metric or metrics on a report connected to an Intelligent Cube, this can be caused by either dynamic sourcing or your security filter.

When this is caused by your security filter resolution, no data is displayed for the metric or metrics. However, when this is caused by dynamic aggregation, null values are displayed for the metric rather than no information at all. The image below shows the difference between security filter resolution and dynamic aggregation as the cause for metrics not displaying any data.

By default, null values are represented by dashes (--) on reports. For information on changing the display of null values, see Changing the display of null values.

If dynamic aggregation is the cause for null values being displayed, resolutions for this issue are described in Metrics that are not dynamically aggregated by default.

The report fails due to the unavailability of Intelligent Cubes

An unavailable Intelligent Cube can cause your reports connected to this Intelligent Cube to fail. This is because the report depends on the Intelligent Cube to provide the data for the report.

The scenarios listed below cause reports to return error messages when Intelligent Cubes are unavailable:

• The Intelligent Cube is not published. This scenario can occur when an Intelligent Cube is removed to:
  • Update it with new data available in the data warehouse.
  • Release its resources for more frequently used Intelligent Cubes.
  • Provide space for a new Intelligent Cube because Intelligent Cube storage limits have been exceeded.

  Contact your administrator to determine why an Intelligent Cube is no longer published and whether there are plans to publish it again.

• The Intelligent Cube is currently offline. In this scenario, the Intelligent Cube is published but has been made unavailable for reporting. Contact the administrator of Intelligent Cubes to determine why the Intelligent Cube has been made unavailable, as well as if and when the Intelligent Cube will be made available again.
• The Intelligent Cube is being published, but the publishing process is not complete. This scenario can occur when an Intelligent Cube is first being published. If you wait for the Intelligent Cube to publish, you should then be able to run your report without experiencing this error.