Devart Forums

Jac

Thank you very much for the prompt replies. It is working now.

Jac

Nope it is not there either. (My VS is also installed on the d drive btw).

I have searched the entire c and d drives, but the file is not there. And I have tried to reinstall MySqlDirect, but it does not show up. Is it not included in the trial version?

/Jacob

Jac

I dont have the .xsl file nor can I find it anywhere, and I have installed MySQLDirect on the same machine (I only have the same).

My SQL server path is
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\Cartridges\

but %ProgramFiles% is c:\program files could this be confusing the installer?

Could you mail the file to me?

/Jacob

Jac

I have sent you the project, but as I have written in the mail, the SQL is not pregenerated but will be generated at runtime by SASS.

Jac

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:

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.

The query being issued is the following:

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 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

Devart Forums

Search found 5 matches

Using MySql as source for cube in Analysis Services (SSAS)