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.