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 is 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.
In what scenarios can you drill up and down in a report in Cognos?
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 down and drill through reports?
Drill down and drill through analysis are two extremely powerful features in business intelligence. 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 you drill down data in Excel?
How to Drill-Down Chart Data in Excel
- 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.
What is drilling up and down?
Drilling up. Drilling up means to replace the data you are drilling up on with the data for the parent element of that data. Drilling down means to replace the data you are drilling down on with the data for the child element of that data. You drill down to see more detail about data.
What is burst reporting?
Bursting is the process of running a report once and then dividing the results for recipients who each view a subset of the data. For example, salespeople in different regions each need a report showing the sales target for their country or region.
What are drill-down reports?
Drill down is an analytics capability that allows users to instantly shift from an overview of data to a more detailed and granular view within the same dataset they are analyzing by clicking on a metric in a dashboard or report.
Why drill-down report is used?
Benefits of Drill Down and Drill Through Reports Gain instant knowledge of different depths of the data – A drill down report gives the user a deeper insight of the data by letting him see what makes up the figures he’s analyzing.
How do you 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.
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 drill down in a report?
When you run a report, you can drill down or drill up by right-clicking the data item and choosing the action from the context menu. The menu items will be disabled if an item cannot be drilled up or down on. When you drill down in a report that uses a very large data sources query results can be much larger than what can be held in memory.
How do I edit Cognos Viewer portlets?
Select the Edit icon (highlighted in red below) on each of the Cognos Viewer portlets. Step 2: Select the report for each Cognos portlet. Click Entry (highlighted in red below) to choose the appropriate report. In our example, we will set the prompt report to be in the left-most portlet.
What is Data Science in IBM Cognos?
Data Science. Information Management. A request we often get is to build more dynamic dashboards and reports. This can be accomplished by a combination of Report Studio prompt reports, portlets, drill-up/drill-down and filtering. The key to this interactivity is communication between IBM Cognos portlets and channels.
