MS SQL 2005 SSAS issue
Posted: Tue 15 Jun 2010 21:38
I have downloaded and installed dotConnect for MySql 5.80.140.0 trial version. We need to connect MS SQL 2005 SSAS cube with large MySql database. I was able to create Data Source and Data Source View and browse data. But when I create dimensions and measures and try to deploy project to Analysis Service Server I get this error:
I have read similar post about same error but it was from 2006 and in much older version http://www.devart.com/forums/viewtopic. ... 907fa90057 . Is the solution for this problem the same?
We really need some solution to connect SSAS and MySql because our customer required that we use MySql as Data Source for SSAS so we cannot use SSIS to import data in SQL 2005 database.
Code: Select all
Processing Dimension Attribute 'Title' failed.
SELECT
DISTINCT
[mydb_events].[title] AS [mydb_eventstitle0_0]
FROM
(
SELECT * FROM events
)
AS [mydb_events]
Error Messages 1
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 '[mydb_events].[title] AS [mydb_eventstitle0_0]
FROM
(
S' at line 3.
We really need some solution to connect SSAS and MySql because our customer required that we use MySql as Data Source for SSAS so we cannot use SSIS to import data in SQL 2005 database.