SAP Knowledge Base Article - Public

3427487 - Preview function not working when joining two import sql queries in modeler in SAP Analytics Cloud.

Symptom

  • Preview option is throwing error when joining two tables from SQL.
  • Error: cannot read properties of undefined(reading 'FlatTableDataSet')..

Environment

Product version: SAP Analytics Cloud 2.0


Database: Import SQL. 

Reproducing the Issue

  1. Log in to SAC.
  2. Go to modeler.

  3. Click on Select a data source.

  4. Choose from a SQL datasource.

  5. Select location

  6. Choose Connection type

  7. Choose connection

  8. Create a new query

  9. Click on Next.

  10. Build a Query tab appears.

  11. From Data Tables search for specific query and drag to right side.

  12. Search for another query and drag to the right side.

  13. Link the two tables based on ID.

  14. click on left outer join and select All primary data.

  15. Click on preview

  16. Gets the error message: cannot read properties of undefined(reading 'FlatTableDataSet')..

Cause

The issue is under investigation by the Development team.

Resolution

The issue is under investigation by the Development team.

See Also

Keywords

SAC, SQL, import connection, merge table. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0