Hi -
We have some reports where end users can select any ad-hoc measures (up to 4) in our SSAS tabular cube that they desire. Each have their own slicer. The four slicers point to four unrelated tables in the tabular cube that are just a selection of hard-coded measure names, for instance:
Select "measure name" AS [Ad Hoc 1]
UNION ALL
Select "another measure name" AS [Ad Hoc 1]
etc....
We've got a lot of cool dynamic charting and matrix visuals going on, but what's frustrating is that when end users select items from other slicers after having made selections in these four slicers, these four slicers revert to "All" in the display, even though their selection remains in the slicer. What's even more confusing is that the "Show All" Selection Control of these slicers is set to Off (with "Single Select" set to On) as we force them to select just one valid measure in each.
This is EXTREMELY confusing for our end users. When they go back to those slicers and hit the down arrow, it immediately pulls up and displays the selection they had already made, but they shouldn't have to do this.
Why does this behavior occur? Is it a bug? Is there a way to work around this?
Thanks!
-Phil (SQL McOLAP)
