COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: a.info on 08 Jan 2013 08:30:09 AM

Title: Crosstab report : DMR
Post by: a.info on 08 Jan 2013 08:30:09 AM
Hello,

Is that possible on a crosstab to retrieve the item that is clicked when the drill down?

Thank you very much for your help.
Title: Re: Crosstab report : DMR
Post by: Greg on 13 Jan 2013 06:58:19 AM
What do you mean by retrieve the item?  What do you want to do with it?
Title: Re: Crosstab report : DMR
Post by: a.info on 15 Jan 2013 05:34:32 AM
I want to use to filter the data.
Thank's
Title: Re: Crosstab report : DMR
Post by: MFGF on 16 Jan 2013 04:40:01 AM
I'm still not sure what you mean? Drilling down effectively filters based on the selected drill member, and expands to the next level of the hierarchy. Can you describe exactly what you are trying to do?

MF.
Title: Re: Crosstab report : DMR
Post by: a.info on 17 Jan 2013 03:17:34 AM
I created a crosstab in report studio (cognos 8.2) (screenshot attached)
based on DMR.
My problem is that when I do a drill down for example on Site1 the level of
the axis Pages does not filter.
if I click on site1 I want to filter the data for report by site1
Is it possible to link axes to filter the data on other axes when the drill
down?

Thank you very much for your help.
Title: Re: Crosstab report : DMR
Post by: MFGF on 18 Jan 2013 07:32:37 AM
Why not just nest Pages alongside Site - that way, when you drill down on your site, the numbers for pages will inherit that context too.

Regards,

MF.
Title: Re: Crosstab report : DMR
Post by: a.info on 18 Jan 2013 07:57:09 AM
Yes.
But the user wants to have this report format.

Thank you for your help.
Title: Re: Crosstab report : DMR
Post by: blom0344 on 18 Jan 2013 09:34:34 AM
Quote from: a.info on 18 Jan 2013 07:57:09 AM
But the user wants to have this report format.

One of the limitations of using a TOOL. Like most things in life it is ultimately a compromise.  One of the nasty aspects is clarifying why the next best solution is supported and the best not   ;)
Title: Re: Crosstab report : DMR
Post by: a.info on 21 Jan 2013 02:24:29 AM
So, no Soulutions!!!!
Title: Re: Crosstab report : DMR
Post by: blom0344 on 21 Jan 2013 02:31:44 AM
Your user wants something the tool may not support. You conclude that THE solution does not exist. Cognoise tries to offer alternative approaches. That's about it   ???
Title: Re: Crosstab report : DMR
Post by: a.info on 21 Jan 2013 03:18:19 AM
I would to have a solution alternative. That's about it .
I'm stuck :(

Thank you and good day