In a previous post, I bragged on one of Alan Smithee’s articles and extended it the tiniest bit.
A couple people have since asked if one can use his technique when dealing with a SQL Server Analysis Services cube. The challenge, of course is that you can’t easily add a new calculated field to SSAS with an expression like the one below:
[myParameter] = “someValue” // viz name
We need this ability to drive the filtering behavior which shows and hides a worksheet inside the dashboard.
Your sneaky workaround of the day: drop an arbitrary (cube) dimension attribute into Level of Detail, then filter it.
In the screencap below, I’ve dropped the [Calendar Year] attribute from the AdventureWorks sample cube’s [Order Date] dimension on LOD,
We have now something to filter on, even if it’s not exactly the right thing:
Next, choose the Condition tab and add your filter expression to the By Formula text box. This is how you’ll filter on the right thing:
[Viz Selector] represents the parameter being used to show / hide stuff. “Area” is the name of current sheet. Viz “Area” will be displayed when the expression evaluates to True.
You’ll essentially repeat the same process of each of the worksheets you want to show/hide in your dashboard and you’ll be ready for some hot cube-based fun with Tableau.
