KNOWLEDGE BASE

Internal Error on Advanced Table Calculation with Action Filter On Cube Data Source


Published: 18 Sep 2017
Last Modified Date: 19 Oct 2017

Issue

When connected to MSAS and setting the advanced table calculation settings for INDEX() to include multiple dimensions and a custom sort, and the view is also filtered by an Action Filter, then Tableau Desktop returns an internal error.

Environment

  • Tableau Desktop 10.1.0-10.1.11, 10.2.0-10.2.5, 10.3.0-10.3.4 and earlier versions
  • Microsoft SQL Analysis Services (MSAS)

Resolution

Option 1

Upgrade to Tableau Desktop 10.3.4 or 10.2.6. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

If you are unable to upgrade, please try using RANK() instead of INDEX().

Cause

This behavior is related to a known issue (ID: 675088) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?