KNOWLEDGE BASE

Error: "An error occurred... Undefined binding. Unable to create extract" When Pivoting a Boolean Field in Anaplan and Creating an Extract


Published: 27 Sep 2017
Last Modified Date: 28 Sep 2017

Issue

After connecting to Anaplan, you are unable to pivot a boolean field and convert it to 'Number (decimal)', the following error might occur when creating an extract:

"An error occurred while communicating with data source '<data source name>'./undefined binding/Unable to create extract"

Environment

  • Tableau Desktop 10.3.2
  • Windows 8
  • Anaplan

Resolution

Convert the string 'true'/'false' to 1/0 in Anaplan or in Tableau Desktop before converting the entire pivoted string dimension to 'Number (decimal)'.

Cause

All dimensions come in as 'String' data type from Anaplan. The booleans come in as 'true'/'false', the numbers as '1.322', etc. Therefore, when converting to number, Tableau knows how to handle the '1.322', but not the 'true'/'false'.
Did this article resolve the issue?