Forum Discussion

Sasha's avatar
Sasha
Icon for Helper III rankHelper III
6 years ago

Slicers syncing filters

Hi, I have a slicer of country which I want to be a slicer and not a filter as it's an important dimension the user will work with and I want it to be visible and trivial. On the filter pane I've a...
Need Help
eisenhower's avatar
eisenhower
Frequent Visitor
6 years ago

Sasha We tried to achieve this same behavior between our City and State dimension filters and found that we needed to create an SSAS relationship in the Dimension Usage tab of the Cube. Secondly, there needs to be a foreign key relationship between the two dimensions, so the cube knows which Cities related to which State.