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

Drill thru in the same report

Started by S_N_Solution, 08 Sep 2009 06:42:42 AM

Previous topic - Next topic

S_N_Solution

Hi All,

Please let me know how i can do the drill thru in the Same report.
I want to take two list besides of each other.Both the list wold contain the following data item.
List 1: Retailer Name,Revenue.
List 2: Order Number,Order date,Product Type,Quantity.

Want to do Drill thru on Retailer name.When i will click on Retailer name should display all the order detail in the 2nd list.Also on each run the 2nd list should alter with the Retailer name selected in the 1st list.

Thanks in advance..............

billylodz

I will give you start point.

1. reate analysis in analisys Studio, with your Retailer Name in Rows  and REvenue in colums,
2. open it in Report Studion

3. add new list and use existing query, next add what you need to nw list.

4. go to query, add your "Retailer Name (Total)"  Item to Slicer

now you will have what you need, will work fron RS 8.3 i think.

next you can change what you need it's just start point.
can be some easer way, I haven't looked for.

Naven

Hi,

Take two list items associated to two different query items.

Drag and drop Retailer Name,Revenue into List1.

Drag and drop Order Number,Order date,Product Type,Quantity into List2 and include Retailer Name in List2 query.

Create a value Prompt (hide it later) for List 2 on column Retailer Name on the report page itself.

Save the report.

After saving the report apply drill through for List 1 on Cloumn Retailer Name and select the same report to pass the parameter, here the parameter would be 'p_Retailer_Name' of List2.

Set necessary default value required for value prompt.