In my scenario I have a line chart which shows different results based on which customers I choose to include via a filter. There is a natural progression of this which came up, and I'd like to know how to implement it optimally. How do I implement a second filter, that affects the list of customers that appear in the first filter? For example, I want to use the field member "Type= active customer" via the second filter, and have the first filter only allow me to select members that are active customers.
What's the best way to get one filter to affect the available members of another filter?
Very simple! try the beta version of Dundas BI 5, which will be released shortly.
It is possible to acheive this before version 5, but in a rather convoluted way. I highly recommend just waiting for the beta :)
If you're interested in participating in the Dundas BI 5 Beta (held within The Cube), you can sign up here: https://dundas.influitive.com/connect/0a2363
It can be achieved by using scripts to manually add/remove items from a dropdown or parameter selector. You may need to use an off canvas datagrid to match up which customers are in which type. It is a bit of a kludge but we have done it many times.
It may also be possible to use a 'level' filter control if it is set up as a hierarchy.
Sorry, but I don't have enough information to give a more specific solution.
Is there an approximate release date available for the final version of Dundas BI 5 (ie. the version after the beta release)?
We are projecting the Beta to run for approximately a month and a half (or so), with the release coming shortly thereafter.
From what ive seen this is a feature coming in Dundas 5 and isnt available in any of 4.
I have used it in 5 and seems to work well there. Very easy to implement.