If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Synchronizing two crosstabs with 2 queries

Started by kutrikb, 19 Nov 2007 09:48:54 AM

Previous topic - Next topic

kutrikb

Hi again,

I have two crosstabs that filter each other's context. (So it's not a master detail relationship since both can be masters).
Let's say the first has Revenue / Productline
the other REvenue / OrderMethod
if I drill down on the Ordemethod then not only the second crosstabs gets drilled down but the first one will show REvenue / Product line for the given Order methods (result set of drilling down on the sencond Xtab.)
and vice versa.
I can do it if I use one query, but now I have two different datasource I have to use two queries.

What's the solution? I tried with Union, doesn't work. I defined the member sets but no impact.

Thanks

Bence