Drill through from all levels?

[James111]

Hi there,
I have a cube which contains a time dimension with three levels - Year, Month, Day.
My chart displays a bar for each value in a level, first you see a bar for each year, then you can drill down to months and so on..

I want to be able to drill through on one of the bars and see a list of whatever I'm counting in the current bar, but to do that I need to send the drill through report the year/month/day I want to see.
How do I do that?

Hope this makes any sense..
Thanks!

[MFGF]

Hi,

Question - is the detail report you are drilling to based on the same package as the source report (ie the dimensional package) or is it based on a different relational package?

If it's the former, add a Query Calculation called Date to the target report with the following expression:

[Your time hierarchy from the time dimension] -> ?Dateparam?

If it's the latter, add a detail filter to the target report as follows:

[Date-time column from your database] in_range ?Dateparam?

Once the target report has been written and saved, you can now add the drill-through definition in Cognos Connection.

MF.

[James111]

I've saved the target report, but what do I send to it as a parameter from the initial report?

[MFGF]

Hi,

Try defining three drill-through definitions - one for each level.  For the Year drill-through, make sure only the Year level is in scope, and pass the Year level as the parameter.  For Month, set the Month level in scope and pass the month level etc.

Regards,

MF.