Using MySQL with Microsoft Analysis Services for OLAP

I’ve always wanted to use MySQL as my fact, dimensions, etc tables to use for Analysis Services for OLAP cubes. When using Visual Studio to create the Analysis Services database, I’ve always stumbled upon some kind of issue where processing the cube would produce a query that only MSSQL server would understand.
Well, I’ve finally created the cube that has all the data stored in MySQL database(es).


| Read more …