COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: aolevano on 04 Aug 2010 11:10:35 AM

Title: Global Filters in Multi-Tab Dashboard
Post by: aolevano on 04 Aug 2010 11:10:35 AM
I am creating a page that uses a multi-tab dashboard object.  Every Cognos document I come across says that it is possible to use a global filter to filter across all the tabs.   However, I cannot find a way to get this to work.  My global filter is working fine if I use a Viewer rather than the multi-tab, but I'd like to keep the multi-tab in place.

I'm beginning to think that all the documentation is wrong.
Anyone have experience with this?
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: proud2bloud on 20 Jan 2011 11:26:17 PM
Hi
Just clarifying, you are using a multipage object. I doubt very much that the filter will work across tabs. For the filter to work across tabs, the reports will need to be run at the same time. In my experience, the reports are not rendered till the tab is activated.

There is actually a few articles in the KB that refer to global filters. There are also videos on youtube that talk about it but nothing along the lines of filtering reports that run across tabs.

Cheers
Proud
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: RobsWalker68 on 27 Jan 2011 10:02:11 AM
Hi,

http://www.ibm.com/developerworks/data/library/cognos/reporting/dashboarding/page531.html

Here is a relatively recent proven practice document that details how to make global filters work in a multi-page dashboard.  I wasn't aware of this either so always good to learn something new.

Cheers

Rob 
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: david.stachon on 27 Jan 2011 11:46:50 AM
that's a fantastic article! ....great post RobsWalker68
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: david.stachon on 27 Jan 2011 11:51:50 AM
I haven't tried this yet...

but do you know if all the reports on the tabs refresh after refreshing the prompts, or the reports refresh as you click the tab?
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: RobsWalker68 on 27 Jan 2011 12:04:09 PM
Hi David,

I haven't tried it myself yet as only came across it today.  If I have time I'll run through it tonight and let you know otherwise if you get there first post an update.

Cheers

Rob
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: PRIT AMRIT on 27 Jan 2011 11:24:48 PM
Great finding Rob, it's working absolutely fine.
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: RobsWalker68 on 28 Jan 2011 05:53:51 AM
Hi Prit,

I haven't had time to try it yet myself.

QuoteDo you know if all the reports on the tabs refresh after refreshing the prompts, or the reports refresh as you click the tab?

As you have tried it out would you be able to answer David's query.

Cheers

Rob
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: PRIT AMRIT on 27 Feb 2011 10:09:02 PM
When you make you prompt selection and hit on FINISH button, the default page would start refreshing though, however, other reports will only refresh when you would click on the respective TAB.

Prit
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: RobsWalker68 on 28 Feb 2011 07:14:34 AM
Thanks Prit for updating.

Good to know

Cheers

Rob
Title: Re: Global Filters in Multi-Tab Dashboard
Post by: dana180 on 09 Mar 2011 03:51:17 AM
Good Morning
did someone tried it on different cubes ?
since the article only talks about  navigate between reports
from the same package.
i got an error tring 2 different packages.

thanks Ayelet.