Hi,
I'm working on making elements for use in Business Insight (Workspace) in 10.2.
I have a issue; I need to make it possible for the users to be able to filter hierarchical. Meaning they need something like a cascading filter or a filter that filters another filter.
The items are [chain] and [store], and I want to display the stores that are available according to selection in chain. Is it possible in any way? My observation is that a filter doesn't "listen" to other filters.
Only possibility I have found so far is to make the reports based on dimensional data, and make a tree prompt - but I don't want to make prompts
I have done some research, and it doesn't seem like it is posssible to filter a filter. The solution is to make the prompts in RS, and drag them into Insight (Workspace)
My Datasource is a Cognos Cube and I created Cascading Filters, from Year to Month. They work fine in Report Studio just do not work in Business Insight. So keep that in mind if you are going to make your own Filter widgets to pass a filter to a filter. Cascading using parameter does not work.
Thanks
Charlie
You can create a cascaded filter in report studio and drag the complete page into Business Insight.
Regards,
Rahul
Quote from: Deep750 on 12 Nov 2012 04:04:06 AM
I have done some research, and it doesn't seem like it is posssible to filter a filter. The solution is to make the prompts in RS, and drag them into Insight (Workspace)
Not sure what you meant by you did not want to make a tree prompt, cacade prompts are "Prompts" too.
IF you mean you do not want your report to "Prompt for filters" then make Filter Widgets like I did. Tree Prompt is the best Performing Filter for Dimensional Sources in Cognos.
Thanks
Charlie
Hi Rahul,
I am trying to bring a cascading prompts (report2) developed in report studio in to my workspace, Say I have Country and States as my prompts . Assume I have two tabs in my workspace and my report1 shows my sales on the country level and report2 shows the sales at Country-Sales level.
When I am using a global filter as country ,my report1 displays the contents and my prompts in report2 - country prompts resets to selected country as in global filter, but my cascaded prompt (state0 doesnt reflects.
Global filter tries to apply the country value to tab2 , but the cascaded prompt in my tab2 doesnt reflects according to the change.
So it means that cascaded prompt will not listen to global filter ?
Thanks,
Mani