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

List and chart filtering to cascading drop down lists

Started by sruthi, 18 Jun 2013 12:56:10 AM

Previous topic - Next topic

sruthi

Hi,

i created an active report that contain 3 cascading drop down list.:1 for vertical group 2:verticaL 3:account
i have an list and 2 charts that should filter with the drop down lists.
Requirement :when vertical group selected.the list n charts should show all values with that vertical group. when vertical selected, the list n chrt should show all values  with vertical in the selected vertical group.
when account selected ,the list n chrt should  show all values with account in the selected vertical in the selected vertical group.
But it is not filtering properly.Below are the steps i follwed to implement.
1) dragged 3 drop down list 2) i made them listen to a single query:query_filters that conatin vertical group,vertical,account as data items and created variables v_vertical group,v_vertical,v_account
3) i made them cascading using container filters using the above variables.
4) i dragged a data deck and made them listen to the same query of drop down list :query_filters
5) In the container select i gave : "verticalgroup in  v_vertical group OR vertical in v_vertical OR account in v_account "
6)i dragged a list and 2 chart into the data card. now i have two queries :query_list and query_charts
(LIST AND CHARTS are populatd with values from different namespace .hence made tw0 queries)
7) then using master detail relationship i created links between  vertical_group,vertical,account of  the master (query_filters) and detail (query_list for list and query_charts for chart)
Result :Filtering is not working properly.
please correct me if iam wrong.
thanks in advance

RKMI

Hi,

I can help but, most like need to see the report spec(xml). Since hard to understand which variables are being used. Send a PM, if you like to proceed.

Thanks,
RK

sruthi

HI,
I have attached the . xml file of the report made on  same scenario with  Go sales query.I made list to filter using the container filter.
chart will  filter with master detail relationship provided only single data item is passed. The filtering doesnot happen if 3 data items are passed at a time.
please help
thanks in advance

RKMI

Hi,

Here you go. Couple things you missed you got in the deck but didn't make any selections on the data deck and also you did a direct filter on the list and the chart which beats the point of having a data deck to control the data card. Anyways I think there are some good tutorials/ IBM active reort cookbook which will help explain futher how data decks work and how to set controls.

Thanks,
RK

sruthi

Hi,
Thank you soo much for correcting me.
As mentioned i included the container select and repositioned the list out of the deck.
But still iam facing issues for particular data sets .
For eg when i executed the report you shared with
Region : Northern Europe
Retailer country: not selected
Retailer city (multiscript):not selected
The chart doesnot show any values though the list shows the values
But If a Retailer country and Retailer city (multiscript) is selected under Region : Northern Europe
then the chart filters .
ie,the chart filters with the inner drop downs but not with Region.
similarly if
Region :NORTHERN EUROPE
Retailer country:Denmark
Retailer city (multiscript):not selected
im facing the same issue.The chart doesnot show any values though the list shows the values
But If a Retailer country and Retailer city (multiscript) is selected under Region : Northern Europe
Retailer country:Denmark
then the chart filters .


ThiS issue is only for THIS PARTICULAR COMBINATION OF DATA .It works well for other regions and countries .

please find the attched screen shot of the issue.

sruthi

Hey..
can anyone help me on this ??? :( :( :( :(

Satheesh

Hi,


Did u provide master detail relationship between Chart & Data Deck....


in Data Deck should have(Region, Retailer Country, Retailer City)


If the chart is in Data Deck give master detail relation of those three links...
(Chart Query also should have Region, Retailer Country, Retailer City)


It will work fine..


-Sateesh