Download IBM Cognos Express Version 10.1.0: Cognos Connection User Guide

Transcript
Example - Drill Through Between OLAP Reports in the Same Package
You want to drill through from an IBM Cognos Analysis Studio report that shows
revenue breakdown according to order method to a report created in Report
Studio, which shows details of planned and actual revenue.
Both of these reports exist as samples in the Sales and Marketing (cube) package.
The reports are both based on the same package, so the data is conformed. For
more information, see “Conformed Dimensions” on page 120. You decide to use a
parameterized drill-through definition for greater control, because prompt
parameters exist in the target already.
You also decide to restrict the scope of access to the drill-through target, so it that
it is only available to a report in the source package that uses the measure
Revenue. This means that any reports created in the package will see this
drill-through definition if they contain the measure Revenue. If the source report
does not contain order year or order method, then users will be prompted for
values for those parameters when the drill-through target is run.
You must have the IBM Cognos Business Intelligence samples from the
deployment zip file IBM_Cognos_DrillThroughSamples installed to follow this
exercise. If you want to check the target report, you must have access to Report
Studio.
128
IBM Cognos Express Version 10.1.0: Cognos Connection User Guide