Using MySql as source for cube in Analysis Services (SSAS)
Posted: Tue 24 Jul 2007 07:08
I am trying to build a cube in Business Intelligence Studio, based on a MySql database.
It works ok, untill I try to do a process dimension (which is to actually read the data from the DB).
The error I get is the following:
The query being issued is the following:
The culprit is of course the square brackets around the table and field names.
The problem is that the SQL is auto generated by SSAS, so I cannot manually remove the brackets, as it is otherwise suggested in this forum.
Do you have any solution for this problem?
I am using CoreLab.MySql.dll Version 4.0.13.0
/Jacob
It works ok, untill I try to do a process dimension (which is to actually read the data from the DB).
The error I get is the following:
Code: Select all
Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[kvhxservices_development_municipalities].[kommune_nr] AS [kvhxservices_developm' at line 3.
Code: Select all
SELECT
DISTINCT
[kvhxservices_development_municipalities].[kommune_nr] AS [kvhxservices_development_municipalitieskommune_nr0_0]
FROM [kvhxservices_development].[municipalities] AS [kvhxservices_development_municipalities]
The problem is that the SQL is auto generated by SSAS, so I cannot manually remove the brackets, as it is otherwise suggested in this forum.
Do you have any solution for this problem?
I am using CoreLab.MySql.dll Version 4.0.13.0
/Jacob