.
You can drill through to another report or data source to reveal more detailed information from the current cube. You can drill through to information in another cube or to details in IBM Cognos Query or Impromptu Web Reports, depending on what your PowerPlay administrator has set up. For example, your report shows the 2005 sales for regions in the Americas, but another report contains the specific sales information for the United States region. You drill through to the current report to see sales for each branch in the United States region.
When you drill through to a report, its current measure and dimension line are applied to the new report or query. For example, a report uses the Actual Revenue measure and the 2005 level from the Years dimension. The report that you drill through to also shows revenue for 2005.
When you drill through to a report, your current row and column selections are applied to the new report or query. This helps you to create a drill-through report that includes only the specific data and filtering criteria that you are interested in.
Drill-through information is applied when it is valid for the report or query that you drill through to. For example, you have filtered a report by product. If Product is not a dimension in the report or query that you drill through to, then the filter cannot be applied, and data for all products appears.
If you attempt to drill through to a target that is located on a different computer, you may receive an IBM Cognos Application Firewall rejection message. If this occurs, contact your administrator.
If you drill through to a time-based partitioned cube that contains data that is categorized differently among the PowerCubes that form the time-based partitioned cube, you may receive data that appears inconsistent.
For example, you drill through to a time-based partitioned cube that contains data on the top ten sales staff in San Francisco for 2003. Dave Mustaine, a sales representative in San Francisco, shows total sales for 2003 of $60,000. When you drill further to isolate Dave Mustaine without a regional context, you see total sales of $72,000 for 2003, a value which is inconsistent with the original total sales reported. Because Dave Mustaine joined the Denver sales office for two months during 2003, his $12,000 in total sales for those months were not returned in the original view, which showed Dave Mustaine for San Francisco only. Isolating Dave Mustaine with no context of San Francisco or Denver returns data for both regions for 2003.
Drill through is available only if it has been set up by your administrator.