COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: CogDeveloper on 15 Jun 2016 01:42:18 PM

Title: Cognos Active Reports - Cascading prompts with a single Object
Post by: CogDeveloper on 15 Jun 2016 01:42:18 PM
Hello All,

I have a requirement in Active reports to cascade Region, County, Office prompts and display a chart based on user selection. When the report first opens it should show 'Statewide' Chart. When a selection is made in the Region prompt. It should display Region Chart and filter values(Cascade) in the county prompt. Similarly if a county prompt is selected, it should display County Chart and filter values(Cascade) in the office prompt.

I was able to accomplish cascading prompts with 3 Data Drop-Down lists. I created 3 Chart objects RegionChart(No data tab shows Statewide Chart), CountyChart and OfficeChart. However, the requirement is to show a single chart, not 3 charts. A single chart should show Statewide Chart by default and display Region chart when Region is selected, County Chart when Region and County is selected. Office Chart when Region, County and Office are selected. It would be okay if I hide the other 2 Charts. At any point of time only one chart should be shown.

I have attached the report specification. Can someone please help!
Title: conditional show and hide of bar charts in active report
Post by: nancysinghal on 17 Jun 2016 07:10:23 AM
Hi,

I have 3 variables: pRegion, pCounty and pOffice, and three coressponding cascading data dropdowns. again 3 charts , one displaying data by region, second by county and third by office.
Requirement: If user does not select any dropdown option, statewide data should be displayed.
When any region is selected, chart should be displayed with that particular region data only.
If then any county is selected(in second dropdown), chart should display data specific to that region and county combination.
If then any office is selected(in third dropdown), chart should display data specific to that region, county and office combination.

I want to conditionally show and hide charts according to user selection of dropdown prompts.

Can anyone please suggest.

Regards,
Nancy
Title: Re: Cognos Active Reports - Cascading prompts with a single Object
Post by: nancysinghal on 17 Jun 2016 07:16:32 AM
I have a similar requirement. But my chart is getting filtered for one region, instead of giving Statewide view.
Can you please suggest what I am missing here.

Regards,
Nancy
Title: Re: Cognos Active Reports - Cascading prompts with a single Object
Post by: MFGF on 20 Jun 2016 04:28:33 AM
Quote from: nancysinghal on 17 Jun 2016 07:16:32 AM
I have a similar requirement. But my chart is getting filtered for one region, instead of giving Statewide view.
Can you please suggest what I am missing here.

Regards,
Nancy

I suspect you need to add a default card to your data deck, and create another version of the chart on the default card (with no connection to the region/county/office varaibles). The default card will display when no variable values are selected. As soon as you select a region, the corresponding region card of the data deck will be displayed.

Cheers!

MF.
Title: Re: Cognos Active Reports - Cascading prompts with a single Object
Post by: nancysinghal on 22 Jun 2016 01:38:52 AM
Thanks MFGF. It worked :)

Regards,
Nancy