2 Replies Latest reply on Jun 18, 2018 3:52 AM by onur.kocyigit

    Region Hierarchy OLAP (SSAS) use as filter in dashboard

    onur.kocyigit

      Dear Members,

       

      i´ve created 3 sets "Region", "Country" and "Locations" out of "Company" Hierarchy in Cube. In the attached image you can see that the hierarchies are reacting correct to the selection of Region. But now I want to put Region and Country as a filter within the dashboard. But when I pull "Country1" as a filter into the dashboard and select a Region, the filter is showing all values instead of the associated countries. The option "Only relevant values" is also not working. How can I manage this?

       

      Hierarchy.jpg

       

      Thanks!