Initializing help system before first use

Developing Workbooks for the FICO Analytic Cloud

When developing a workbook that will be deployed into the FICO Analytic Cloud the view developer must be aware that the mirror database on the cloud is a MySQL database and not a PostgreSQL database, as supplied in the on premise version of Xpress Insight.
When the workbook is published to the Tableau server through Xpress Insight, the Xpress Insight server will perform some simple transformations on the workbook data sources. Due to feature differences between PostgreSQL and MySQL and also differences in the definition of Tableau data sources between Tableau versions, workbooks will be rejected by Xpress Insight if one or more of the following conditions occur:
  • The Tableau workbook was created using Tableau 8.1.x or earlier.
  • One or more of the data sources in the workbook contains a FULL OUTER join.
Warnings will also be displayed if one or more of the following conditions occur:
  • One or more of the data sources in the workbook uses custom SQL. Xpress Insight cannot guarantee that this SQL will run correctly against a MySQL database.
  • The workbook uses RAWSQL_ or RAWSQLAGG_ Tableau functions. These can contain SQL. Xpress Insight cannot guarantee that the SQL contained in these will run correctly against a MySQL database.

It is advised that custom SQL data sources, RAWSQL_ and RAWSQLAGG_ Tableau functions are not used in workbooks that are to be published to the cloud.

Parent Topic Authoring Custom Views with Tableau for FICO

© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.