COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kris123 on 27 Sep 2012 06:49:56 AM

Title: Drill down example report
Post by: kris123 on 27 Sep 2012 06:49:56 AM
Hello,
I want to create the report (see link below)
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.wig_cr.8.4.0.doc/wig_cr_id1315gtstd_ex_edit_rpt_qs.html
(http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.wig_cr.8.4.0.doc/wig_cr_id1315gtstd_ex_edit_rpt_qs.html)
I created pie 3d chart with return quantity and product line.

Now I want to set up drill down (when clicked on a slice)....do i need a new report to be created and set in drill down definition(?)
what are the configuration steps

Please help
Title: Re: Drill down example report
Post by: RKMI on 27 Sep 2012 11:09:55 AM
Hi Kris,

I'm guess this is based on DMR, if so you don't need to recreate the report again.

While in Report Studio on toolbar: click Data - Drill Behavior and check the box which says Allow Drill-up and Drill-down. If you need to disable any of the drill downs you can do it at the same Drill Behaviour Screen.

Thanks,
RK
Title: Re: Drill down example report
Post by: kris123 on 27 Sep 2012 11:43:10 AM
thanks RKMI...I was looking at drill down definition in properties...
Data (menu)>Drill Behaviour works.