Cognos Analytics

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

If you want something that works using the interactive viewer, then the attached report will do so.

You can also replicate this technique within a data module that will give you the same functionality within a dashboard.

I can't upload a report spec, but the basics is:

Query that looks like:

Each of the measure queries looks like:  

With the Measure data item being the literal string for the measure, such as 'Revenue'.

The union query looks like:

It's this that you would put into a data module to replicate in a dashboard.

And the report graph looks like:  

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

Hi Marc,

Thanks for the suggestion. I haven't seen that type of prompt before. Is it a newer version of Cognos? We're on 11.2.2.

If you want something that works using the interactive viewer, then the attached report will do so.

You can also replicate this technique within a data module that will give you the same functionality within a dashboard.

I can't upload a report spec, but the basics is:

Query that looks like:

Each of the measure queries looks like:  

With the Measure data item being the literal string for the measure, such as 'Revenue'.

The union query looks like:

It's this that you would put into a data module to replicate in a dashboard.

And the report graph looks like:  

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

This is a feature of the 11.1 visualisations

A client side chart rendering engine. Which means you can do client side filtering on charts.

The advantage of this method is all the data is on the client side. Changing what measures you show would be instantaneous for the user - and probably with some nice animation too. You can add more data to them, giving the user the ability to filter on things that are not shown in the chart. (I think this is what 12's new client side dashboard cache is all about).

They do have some limitations though - limited formatting, no master detail, limited PDF printing (improving in 12), different charts dont have a common filter box... But in some circumstances they might be useful.

Hi Marc,

Thanks for the suggestion. I haven't seen that type of prompt before. Is it a newer version of Cognos? We're on 11.2.2.

If you want something that works using the interactive viewer, then the attached report will do so.

You can also replicate this technique within a data module that will give you the same functionality within a dashboard.

I can't upload a report spec, but the basics is:

Query that looks like:

Each of the measure queries looks like:  

With the Measure data item being the literal string for the measure, such as 'Revenue'.

The union query looks like:

It's this that you would put into a data module to replicate in a dashboard.

And the report graph looks like:  

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

Hi Marc, Thanks for sharing. I haven't been aware of the fact that these filters are working only locally. Going the same way (On-Demand-Toolbar > Filter) for (e.g.) report lists is applying filters to the underlying query and is so affecting other data containers (including visualizations) using the same query as well. It woul be great if this would work for visualizations the same way. Alternatively or supplementary it would transfer a strong feature from dashboards to reports if the "click-filters" from the dashboard "widget connections" would also be available for report. Does someone know if one of these or both are on the IBM roadmap?

------------------------------
Philipp Hornung
Business Intelligence Manager
Techniker Krankenkasse
Hamburg Germany
#IBMChampion

Original Message:
Sent: Tue June 27, 2023 02:42 AM
From: Marc Reed
Subject: Dynamic Display Different Measures on Line Chart

This is a feature of the 11.1 visualisations

A client side chart rendering engine. Which means you can do client side filtering on charts.

The advantage of this method is all the data is on the client side. Changing what measures you show would be instantaneous for the user - and probably with some nice animation too. You can add more data to them, giving the user the ability to filter on things that are not shown in the chart. (I think this is what 12's new client side dashboard cache is all about).

They do have some limitations though - limited formatting, no master detail, limited PDF printing (improving in 12), different charts dont have a common filter box... But in some circumstances they might be useful.

------------------------------
Marc Reed

Original Message:
Sent: Mon June 26, 2023 01:41 PM
From: Jeremy Aude
Subject: Dynamic Display Different Measures on Line Chart

Hi Marc,

Thanks for the suggestion. I haven't seen that type of prompt before. Is it a newer version of Cognos? We're on 11.2.2.

------------------------------
Jeremy Aude

Original Message:
Sent: Thu June 22, 2023 03:00 AM
From: Marc Reed
Subject: Dynamic Display Different Measures on Line Chart

If you want something that works using the interactive viewer, then the attached report will do so.

You can also replicate this technique within a data module that will give you the same functionality within a dashboard.

I can't upload a report spec, but the basics is:

Query that looks like:

Each of the measure queries looks like:  

With the Measure data item being the literal string for the measure, such as 'Revenue'.

The union query looks like:

It's this that you would put into a data module to replicate in a dashboard.

And the report graph looks like:  

------------------------------
Marc Reed

Original Message:
Sent: Tue June 20, 2023 01:44 PM
From: Jeremy Aude
Subject: Dynamic Display Different Measures on Line Chart

Hello,

I'd like to have a report or dashboard where users can select one or more measures to display on a chart without going into edit mode and without using javascript. 

In my case I'm using a line chart to view measures over time. I have four measures I want to be able to display on the line and for the user to choose to show all four or a combination of the available measures on the chart. I was thinking some series of drop down or a check box prompts but I'm not sure. I'm attaching a screenshot as a mockup where I've chosen two out of four measures to display.

Does anyone have thoughts on how I might do this? Again, it can be in a dashboard or report if one is easier to do than another. We are using Cognos 11.2.2.

Thanks,
Jeremy

------------------------------
Jeremy Aude
------------------------------