KNOWLEDGE BASE

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


Published: 05 Jan 2016
Last Modified Date: 02 Jan 2018

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

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?