The Differences between a Cognos Dashboard and an Active Report

Compare Cognos Dashboards vs Active Reports to understand key differences in capabilities, use cases, and best scenarios for each reporting style.

Cognos Dashboards and Active Reports are both powerful tools that can be utilized for highlighting KPI’s and showcasing relationships between data items in a visual manner. Determining which one to use will depend on, amongst other things, the sources you intend to pull from and the intended end users of the active report/dashboard. Here we’ll discuss the differences and similarities between the two Cognos applications.

 

User interface:

 

Cognos dashboard vs active reports image

Active Reports

As probably evident from the name, the interface for Active Reports is very similar to a regular Report in Cognos. In addition to the usual Sources and Toolbox tabs, there’s an Active Report Controls tab and an Active Report Variables tab. These additional tabs are what allow the report to have interactive capabilities.

 

Active Report Controls let you readily access the components of your report to create the desired layout, as well as filter and sort your data.

Cognos dashboard vs active reports image

 

Connections can be made between items in the Active Report Controls tab by right-clicking and selecting add connection. The Create a Connection window opens:

 

Cognos dashboard vs active reports image

 

Here, connections can be made between the objects in the Active Report to facilitate interactivity. This window also allows for a Behavior to be set, which controls what action is taken in the Target Control when certain parts of the Source Control are selected.

 

Active Report Variables are the means by which information gets passed to the controls as well as from one control to another. These variables essentially tie different parts of the report together, allowing them to react to changes in one another. For example, selecting an item in one active control can force another active report to show information pertaining to the selected item.

 

Cognos dashboard vs active reports image

 

In the Active Report Variable window, you can name and select the data type of the variable, as well as set it as a public variable. This option allows for variables to communicate with one another in other Cognos products, which is key to an Active Reports interactivity.

 

Overall, Active Reports have all the same capabilities you know and love about a normal Report. If your analysis ever requires offline use, Active Reports are the way to go as a subset of the data is internally stored. This might limit the capabilities of an Active Report depending on the size of the data source in use. Existing Reports can also be converted to Active Reports using the Convert to Active Report option in the File menu.

Dashboards

Dashboards in Cognos are great for visualizing key aspects in your data as well as highlighting relationships between sources. The interface consists of the following tabs:

Sources: Add one or more sources to your dashboard, navigate between data items, and add navigation paths (like a  hierarchy) within the data to drill down.

Pins: Store visualization for easy access. To pin a visualization, click the pin icon on the toolbar of the viz.

Cognos dashboard vs active reports image

Assistant: Explore the contents of your data or type commands to have the assistant show you certain components/ visualizations. For example, typing “show sales by region” will return the appropriate plot given your data source.

Visualizations: Visualize key aspects of the data source using one or more of the available visualizations.

Widget: Allows you to insert text items, images, media, webpages, and shapes to your dashboard.

Alongside allowing for multiple data sources, more than one tab can be utilized within a dashboard.

Cognos dashboard vs active reports image

Items can be inserted directly into a tab by dragging and dropping specific visualizations or multi-selecting data items from the Sources tab and dragging those to the workspace. A visualization that best fits the selected data will be automatically created in the workspace.

Directly above the Tab panel sits the option to filter your dashboard. You can add tab-specific filters as well as filters that apply to all the tabs in the dashboard.

 

Creating Connections: Much like in Active Reports, objects within a dashboard can be connected such that one updates depending on the selections made within another. The View Widget Connections  tab lets you maintain these relationships with the following toolbar:

Cognos dashboard vs active reports image

 

Once a connection exists between visualizations, a filter icon will appear on the top left corner of the viz. Drill Throughs are also available within the visualizations. By clicking the drill through icon on a viz you can create drill through to an existing report. This makes a dashboard useful for clients that want to be able to see the summarized information alongside the more detailed report, if desired.

Cognos dashboard vs active reports image

 

Overall, dashboards are useful if your analysis is visualization heavy. The interactivity and drill through capabilities make it user friendly while the Assistant tab makes it developer friendly. Unlike Active Reports, Dashboards cannot be consumed offline.

What are the main differences?

Cognos dashboard vs active reports image

 

For more information, contact sales@capitalizeconsulting.com.

All Posts

Alteryx
Subscribe to our newsletter

Sign up for the very best tutorials and the latest news.

* indicates required

We care about your data in our privacy policy.

Related blog posts

Alteryx, Business Intelligence & Analytics
Q&A: What is Alteryx Server?
Alteryx Server is a software offering that allows Alteryx Designer workflows to be published, scheduled, administered, secured, and monitored. It also provides a way for users to run and interact with workflows built by other users.
Business Intelligence & Analytics, Power BI, Tableau
Power BI vs Tableau: Which One is Right for Your Business?
Compare Power BI vs Tableau to find the best BI tool for your needs. Explore key features, integrations, scalability, and costs to make an informed decision.
Business Intelligence
Alteryx, Business Intelligence & Analytics, Customer Stories, Tableau
Streamlining Internal HR Processes for Splunk
Streamline internal HR processes with insights from Splunk’s success! Learn how to use Alteryx & Tableau to automate reporting and deliver results.
Customer Stories

Contact Us

Interested in learning more? Contact info@capitalizeconsulting.com.