COGNOiSe.com - The IBM Cognos Community

Hello,

I have two crosstab reports, one a list of sales for channels and the other a list of sales for product groups.  They both drill down perfectly and both are created from the same TM1 cube.  If I put them in either a Cognos Connection Page or a Cognos Workspace and enable listening, then drill down on one of the channels, the product group report does not update to be filtered on that channel as expected.

Any ideas please anyone?

Thanks

John

Quote from: jv_oz on 22 Oct 2015 01:26:16 PM
Hello,

I have two crosstab reports, one a list of sales for channels and the other a list of sales for product groups.  They both drill down perfectly and both are created from the same TM1 cube.  If I put them in either a Cognos Connection Page or a Cognos Workspace and enable listening, then drill down on one of the channels, the product group report does not update to be filtered on that channel as expected.

Any ideas please anyone?

Thanks

John

Hi,

To get them to drill in sync as you desire, you need to have both the channels dimension and the product groups dimension in each crosstab. It also helps to have them based off the same query if you can.

Try adding a query calculation nested above your sales in each crosstab:

for the Channels crosstab the expression would be parent(item([your set of product groups],0))

for the Product Groups crosstab the expression would be parent(item([your set of channels],0))

Cheers!

MF.