In what scenarios can you drill up and down in a report in Cognos?

Table of Contents

For more information, see the IBM Cognos Analytics Getting Started guide. Drill up and drill down is available only when you are using dimensionally structured data and viewing the report in HTML format. Furthermore, you can only drill on members in a level.

What is drill up and drill down in Cognos?

You can link groups of data items from different queries so that when you drill up or drill down in one query, the data item also drills up or drills down in the linked queries. When you drill down or up, you can specify whether the column title shows the member caption value or the level label value.

How do you drill down into data within a report?

Turn on drill-down for a chart

Edit your report.
Select a chart.
On the right, in the DATA properties panel under Dimension, turn on Drill down.
Add dimensions to the chart. Each dimension you add becomes another level of detail you can drill into.
Select the Default drill down level.

What is drill down and drill through reports?

Drill down is a capability that takes the user from a more general view of the data to a more specific one at the click of a mouse. For example, a drill down report that shows sales revenue by state can allow the user to select a state, click on it and see sales revenue by county or city within that state.

How do I enable drill up and drill down in Cognos analytics?

From the Data menu, click Drill Behavior. On the Basic tab, in the Report output drill capabilities box, select the Allow drill-up and drill-down check box. By default, IBM Cognos Report Studio determines which items can be drilled on based on the dimensional structure.

What are the advantages of Cognos analytics?

Some of these are:

Lower costs—reduces maintenance due to complete report coverage and a zero-footprint environment.
Faster results—shortens reporting time due to seamless integration and adaptive authoring.
Improved decision making—reports and dashboards present data in easily-understood formats.

How do you make a drill down?

Add drill up/drill down using an existing hierarchy

Create a visualization using an existing hierarchy.
Convert the table to a matrix or chart.
To enable drill-down, collapse the matrix.
Double click a top-level hierarchy field.
Drill down further by clicking one of the fields.
Drill up by clicking the up arrow.

What is drill up drill down?

That’s what we call “drill down,” as it’s a feature allowing you to go much deeper into more particular data or information layers being assessed. On the other hand, drill up allows the user to zoom out the data or information stepwise.

How do you use a drill down?

Use Drill Down Buttons

With the PivotChart selected, click the Analyze button.
Expand the Show/Hide group.
Click the Field Buttons list arrow.
Select Show Expand/Collapse Entire Field Buttons.
Click the Collapse Entire Field (+) button to collapse the lowest level of data.

Is IBM Cognos web based?

IBM Cognos Business Intelligence is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company.

How do I enable Drilldown and drill-up in Cognos Analytics-reporting?

Click the Show properties icon , and in the Properties pane, double-click the Advanced drill behavior property. On the Basic tab, in the Report output drill capabilities box, select the Allow drill-up and drill-down check box. By default, IBM® Cognos® Analytics – Reporting determines which items can be drilled on based on the dimensional structure.

How do I enable drill-up and drill-down in the report studio?

How do I change the drill-up or drill-down behavior for data items?

From the Advanced tab, you can change the drill-up or drill-down behavior for any data item by selecting the data item and then choosing one of the following behaviors.

How do I drill down or up in a column title?

When you drill down or up, you can specify whether the column title shows the member caption value or the level label value. By default, titles use member captions. Using level labels may be more meaningful. For example, within the Country or Region column, you drill down on Australia.