Problems When Drilling Through
The topics in this section document problems you may
encounter when drilling through reports.
- Cannot Drill Through Between PowerCubes Because MUNs Do Not Match
We recommend that business keys be unique throughout the dimension for PowerCubes. These keys are used as the source value for levels in a hierarchy of a dimension. If the values are not unique throughout the dimension, the corresponding Category Code values may be generated with tildes. - Unexpected or Empty Results When Drilling Through
When you drill from a source report to a target report, there might be no data returned. This might be the correct result if there is no data that corresponds to the drill-through selections or if you do not have permission to view the data. - Cannot Drill Through From a Relational Source to a Cube
By default, you cannot drill through from a relational data source to a cube. This is because a cube expects a Member Unique Name (MUN) as a parameter value and relational sources do not use MUNs. - Calculations Do Not Appear in the Target Report
If you drill through to PowerPlay® Studio from a report in Report Studio, Analysis Studio, or PowerPlay Studio, calculations on the edges in the target report might not appear. - Nested Crosstab Only Filters on Some Items
If you perform a parameter-based drill-through from a source report to a Report Studio target report with two or more dimensions nested on a row or column, you may encounter unexpected results depending on the filters applied to the target report. - Data is Not Filtered in the Target Report After Drill-Through
You drill through to a target report, but no filtering occurs in the target report. For example, you drill through on a crosstab intersection of Camping Equipment and 2010 and expect to see only data for Camping Equipment for 2010 in the target report. Instead you see all products for all years. This occurs because the target report has no filters for the parameters that were passed. - Drill-through links in active reports do not work
When viewing an active report that contains drill-through links in Microsoft Internet Explorer 8 and later, the links do not work.
Parent topic: Troubleshooting