KNOWLEDGE BASE

Cube Filter not Behaving as Expected When a Filter is Created Using a Calculated Member


Published: 05 Jan 2016
Last Modified Date: 11 Jul 2017

Question

When adding a new attribute/dimension value to an existing attribute using Multidimensional Expressions (MDX), and then filtering on the new MDX value, the view many not appear to be filtered at all unless the original attribute is somewhere in the view.

Environment

  • Tableau Desktop 9.1 and later
  • Microsoft Analysis Services
  • Multidimensional Expressions (MDX)

Answer

Option 1

You can enable the filter to work as expected by downloading a third party application, however please note that using such an application will require some editing of the feature flags for Tableau. 
  1. Download "Default Programs Editor": http://defaultprogramseditor.com/ . Double click on the .exe application and click Run.
  2. Click File Type Settings > Click Context Menu > Search for .twb
  3. Select .twb and click Next.
  4. Select the Open command (top row) and click Edit Selected Command.
  5. Add the flag to the file path. The path should now appear similar to the following:
    • "C:\Program Files\Tableau\Tableau 9.1\bin\tableau.exe" -DEnableMDXCalcSliceFiltering "%1"
  6. Click Next.
  7. Click Save Context Menu.
  8. Click OK.
  9. Repeat the above steps for the .twbx file extension.

Option 2

If you do not wish (or if you cannot) use the third party application (Option 1), you can apply this behavior on Tableau Server and Tableau Desktop by using the following solutions.

For Tableau Desktop:
  1. Open a CMD window.
  2. Cd to c:\program files\tableau\tableau 10.3\bin
  3. Run tableau.exe “-DEnableMDXCalcSliceFiltering”

For Tableau Server, please run:
tabadmin stop 
tabadmin set vizqlserver.EnableMDXCalcSliceFiltering true 
tabadmin config 
tabadmin start 

Note: To disable this feature flag from Tableau Server, please use the following command: tabadmin set vizqlserver.EnableMDXCalcSliceFiltering -d
 
Did this article resolve the issue?