I know this functionality only exists for certain types of data sources. I am not familiar with working with cubes, but if you can extract your data inside Tableau, you should gain access to this feature.
You may want to read through this: http://kb.tableausoftware.com/articles/knowledgebase/functional-differences-olap-relational
Cubes can’t be extracted… ☹
I believe the answer to your original question is 'no', the In/Out functionality does not work with Cubes.
Here's another article you might find helpful: http://kb.tableausoftware.com/articles/knowledgebase/dynamic-ranked-set-analysis-services
Thanks. That’s what I feared. Tableau doesn’t play well with cubes.
I did see that before posting and that’s essentially what I already have. “Top” sets that the DBA created within the cube. However they act as filters not with the In/Out functionality which what I ultimately need.
Thanks for your insight,
Sorry its a pain. You might be able to create your own quasi-sets using calculated fields, etc. in Tableau. But I'm not sure what you are trying to do exactly, and again, I have no experience working with Cubes.
We can do some operations with Sets in Analysis services cube, but I am not sure of your requirements. As Mathew mentioned, can you explain what you are trying to achieve using set?
I’d like to be able to use the In/Out functionality of sets. I have a list of say 1,000 clients. I’d like to create a set which indicates if they do business with a certain distributor. So essentially all clients would be able to be marked as In this set or Out of this set. I need to do an analysis with different measures sliced by In/Out of this set.
Does this make sense?
I’d start with a view just like the one in the attached workbook.
Is this possible with cubes? I’ve tried writing MDX to create a new calculated member but didn’t have any luck. The sets that have been created in the cube act as filters instead of this functionality. My data architect is also willing to edit the cube to help get this to work if starting at the source is the best way to go.
Thanks for the detailed info.
Unfortunately cube Sets will not work in this case.
A complex option is create a Boolean column in the DSV (cube source), If the client dimension and distributor dimension has relationship to the same Fact table.
For an example if your Fact Table
ClientKey DistributorKey Sales C1 D1 10 C2 D2 10 C1 D2 10 CustomerMaster C1 C2 DistributorMaster D1 D2 ClientKey DistributorKey Sales New Dimension Existing Fact table C1 D1 10 IN C2 D2 10 IN C1 D2 10 IN Union All Missing Customer & Distributor combinations with 0 sales C1 D1 0 OUT
Once you have added the new dimension in to the cube then place it on column, customer on rows, distributor on filter and Sales in the text.
Thanks! I appreciate it. We’ve added the new dimension and it works, but had hoped this set functionality could be created “on the fly” by the end users as the relationships to create sets could then be dynamic. We’ll run with what we have, which is more than before!
Glad to know the solution has worked, can you please mark the solution as answered, It will help to make the forum clean.
You can post "Set in/out functionality for analysis services cubes" in the Idea's section then Tableau may consider it in the future releases.