KNOWLEDGE BASE

MSAS Error When Using 'Keep Only' on Hierarchy Members


Published: 19 Oct 2017
Last Modified Date: 17 Nov 2017

Issue

In a view with an MSAS Cube data source, when the customer adds "Grand Totals" to each level in the heirarchy and selects "Keep Only" at any level lower than the highest level, the following error occurs:
 
Analysis Services database error 0x80004005: Query (51, 5) The ANCESTOR function expects a member expression for the 1 argument. A tuple set expression was used.

Environment

  • Tableau Desktop 9.1 - 10.0, 10.1.0 - 10.1.10, 10.2.0 - 10.2.4, and 10.3.0 - 10.3.2 
  • Microsoft Analysis Services (MSAS)

Resolution

Upgrade to Tableau Desktop 10.1.11, 10.2.5, 10.3.3, 10.4.0 or a newer version. 

 

Cause

This behavior is related to a known issue with ID 678523 which has been corrected in more recent versions.
The way Tableau Desktop serialized MSAS member sets did not properly account for members that had only one element, leading to a syntax error.
Did this article resolve the issue?