multiple connexions between filters

  • laurentfalcoz

    SSC Journeyman

    Points: 87

    Hi,

    I have the following issue:

    I display 3 filters: country, brand and presentation.

    I would like that once the user selected country and brand, Presentation filter contains only presentations for the country and brand selected.

    I have a measure in the cube which makes a link between theses 3 dimensions.

    For presentation filter I declared this measure as filter measure.

    I can make a connexion between country filter and presentation filter: it displays only presentations of the country but no restriction on the brand

    I can make a connexion between brand filter and presentation filter: it displays only presentations of the country but no restriction on the country.

    Do you know if it's possible to link my filter to both filters ?

    Or is it possible in mdx ?

    If anybody can help it would be great...

    Thanks in advance

  • nett-ulf

    Old Hand

    Points: 361

    Hi,

    I have the same problem. I have three filters and I want all of them to influence each other, just like an Excel-list (If you Select one, the other filters have only the actual visual options selectable).

    I have also been searching for pps custom parts to buy for this problem, but have not found any yet.

    Please post if you find a solution to Your problem.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply