416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Data Source Limitations

Hide navigation
RSS
Modified on Mon, 03 Mar 2014 05:50 PM Categorized as Administration, Data, Data Connectors, Data Preparation, Troubleshooting
Click here to return to the Documentation index.


Data source limitations

This article describes limitations to be aware of regarding support for certain types of data sources.

Microsoft Access

  • The 64-bit driver cannot be installed on a computer that has 32-bit Office applications (or the 32-bit driver). You can download the driver: www.microsoft.com
  • Using “Unknown Members Included” and “Calculate empty data points” in the same KPI fails because the Access provider doesn't support FULL OUTER JOIN.
  • Using more than one full dimension in the same KPI fails with a “JOIN expression not supported” error.
  • Crosstab queries and linked tables are not discovered. The crosstab queries and linked tables are available if using manual queries. Another option is to create parameterless SELECT queries to the crosstab queries or linked tables (which will be discovered in &dw; as Views). (Ref. #5534)
  • The TRANSFORM clause is not recognized in manual queries. (Ref. #5673)
  • Microsoft Access does not support the temporary table option when configuring a time dimension.
  • Does not support the COUNT_BIG or COUNT_BIG DISTINCT aggregator options at the virtual table, KPI, and dataset stages.

Microsoft Dynamics CRM

  • Dynamics CRM 4.0 is not directly supported. However, you can use the SQL Server data provider as a workaround to connect to database filtered views. See Data Provider - Microsoft Dynamics CRM for details.

Microsoft SQL Server

  • Discovery of servers hosted on Amazon AWS is not supported. You can manually enter the server name of the cloud-hosted server in this case.

Microsoft SQL Server Analysis Services (SSAS)

  • In order to define calculated measures for a virtual cube, your SSAS instance must support and have enabled default properties for calculated members.
  • Discovery of servers hosted on Amazon AWS is not supported. You can manually enter the server name of the cloud-hosted server in this case.

Microsoft Visual FoxPro

  • A 64-bit driver is not available. The 32-bit driver can be downloaded from here: www.microsoft.com
  • If you try to create a permanent time dimension table and the connection was set up to a folder, the table creation will fail with a “Feature is not supported for non-.DBC tables.” error. If the connection is to a .DBC file, the permanent time dimension table can be created as expected.
  • If you use one of the DateTrim functions when creating a virtual table, the generated query cannot be used. The error displayed is “SQL: Column '' is not found.”. The workaround is to create a manual query using “Manual Override” and remove the whole GROUP BY clause.
  • If the precision of a numeric value in the .DBF file is more than the precision specified in the field definition, you will receive an error message. You can use a manual query to cast the fields to a different data type with higher precision. (Ref. #5976)
  • Microsoft Visual FoxPro does not support the temporary table option when configuring a time dimension.
  • Does not support the COUNT_BIG or COUNT_BIG DISTINCT aggregator options at the virtual table, KPI, and dataset stages.

MySQL

  • Using “Unknown Members Included” and “Calculate empty data points” in the same KPI fails because the MySQL provider doesn't support FULL OUTER JOIN.

ODBC


Oracle

  • To discover Oracle stored procedures or functions, they must be adhere to certain conditions. See Data Provider - Oracle for details.

Oracle Essbase (OLAP)

  • The manual subcube query option in the Virtual Cube Designer is not available for Oracle Essbase. The corresponding check box option will be greyed out.

Salesforce


SAP MaxDB


Teradata

  • No known issues.

Other data sources


Installing drivers

When installing a driver, ensure that it is installed for all users on the system, rather than just your own user account. This is because the account that IIS runs under will need to have access to the drivers in order for the corresponding data connectors to work.

Related topics

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.