Before you set up drill-through access, you
must understand the key concepts about drilling through. Knowing these
concepts will help you to avoid errors so that report consumers drill
through as efficiently as possible.
Drill-through Paths
You can create a drill-through path in a source
report in Report Studio, or using Drill-through Definitions in IBM® Cognos® Connection.
A drill-through path is the definition of the path that is taken when
moving from one report to another, including how the data values are
passed between the reports.
Selection Contexts
The selection context represents the structure
of the values selected by the user in the source.
Bookmark References
When you drill through, the values that you
pass are usually, but not always, used to filter the report.
Members and Values
Dimensionally modeled data, whether stored in
cubes or stored as dimensionally-modeled relational (DMR) data, organizes
data into dimensions. These dimensions contain hierarchies. The hierarchies
contain levels. And the levels contain members.
Member Unique Names
The member unique name (MUN) is a unique identifier
for a member in IBM Cognos reports. It is stored
in the report specification when the member is referenced in the report
directly.
Conformed Dimensions
If you work with more than one dimensional data
source, you may notice that some dimensions are structured the same,
and some are not.
Business Keys
When drill-through access is defined from a
member to a relational value, the business key of the member is passed
by default.
Scope
Scope is specific to drill-through definitions
created using Drill-through Definitions in IBM Cognos Connection
(package drill-through definitions). The scope you set defines when
the target report is shown to the users, based on the items they have
in the source report.
Mapped Parameters
Drill-through targets may contain existing parameters or you can add parameters to the target for greater control over the drill-through link.