Independent data drop down connections

[nancysinghal]

Hi All,

Dashboard Requirement:
3 drop downs:
1) Region
2)Program
3) Office Type: A and B

All three are totally independent of each other.
Default selection:Chart should display two bars with Office type A and B, with all regions and program counts.

But on user selection of Region, Program or Office, my chart should change data as selected.

How canI achieve this. Any suggestions please.

Regards,
Nancy

[MFGF]

Hi All,

Dashboard Requirement:
3 drop downs:
1) Region
2)Program
3) Office Type: A and B

All three are totally independent of each other.
Default selection:Chart should display two bars with Office type A and B, with all regions and program counts.

But on user selection of Region, Program or Office, my chart should change data as selected.

How canI achieve this. Any suggestions please.

Regards,
Nancy

My advice is to use a visualization rather than a chart, and have each Drop-Down List set an active report variable which filters the visualization.

MF.

[nancysinghal]

Thanks for the reply MFGF.

Can you please tell where do we get the visualisation option in Active reports. I could not see anything in toolbar with that name.



Regards,
Nancy

[MFGF]

Thanks for the reply MFGF.

Can you please tell where do we get the visualisation option in Active reports. I could not see anything in toolbar with that name.



Regards,
Nancy

Hi,

Instead of dragging in a Chart object from the toolbox, drag in a Visualization object instead.

MF.

[nancysinghal]

Thanks MFGF.

But I dont see any visualization object in my toolbox. Do we have to install something for that?
Please suggest.

Thanks & Regards,
Nancy

[Lynn]

What version of Cognos do you have? I think visualisations in active reports came about in 10.2.1.

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/crn_nf.pdf

[nancysinghal]

Hi MFGF,

We are using Cognos 10.2, so can you suggest some other wayout to implement this.

Thanks & Regards,
Nancy