1 of 1 people found this helpful
This post was from over a month ago and went without an answer. Did you find a workable solution? There are not a lot of Tableau users with SSAS / OLAP data sources so there are only a few helpful hands out there. While sharing a SSAS packaged workbook will not likely work, is it possible to share images of the workbook if this is still an ongoing wish to be resolved. I'm not sure if there is a method but bringing pictures into the question usually helps the community to engage and better understand.
Thanks for the reply! There really is a shortage of solid resources when it comes to Tableau and SSAS/OLAP data sources and I figured posting here was a shot in the dark. I never did find a workable solution unfortunately, but I took your advice and tried to condense my issue into the simplest image possible:
I have a single measure that is simply a count of events and my FactEvent object is related to two Location Dimension objects (one is related to the current location and the other is related to the event location). Both location dimensions are identical. I would like to improve the user experience by having a single drop down filter that is just "Location" that, when filtered, applies the same filter selection to both dimensions. Hopefully this clarifies things a bit... a picture is worth a thousand words.
If the value is always the same between the 2 dimensions (locations) why not use a parameter and then filter each dimension based on the single parameter value - it provides the user experience you are looking for
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
That was my initial plan of attack, and I touched on it briefly in my initial post, but you can not reference a dimension in a calculated field when you are using an SSAS data source which I believe is necessary for the parameter solution to work. If there is another way to set my dimension values equal to the parameter values without using a calculated field then that would be perfect, but that is where I ran into the wall.
My initial thoughts are I'm not sure if your logic around not being able to reference the dimension is correct - if Tableau can see it then it doesn't stand up that Tableau can't use it.
Can you show an image of your desktop environment where you have the data loaded and the dimension dragged out onto the canvas ?