Like you said it had to do with configuration, but I am hitting a died end. It seems the problem is related to giving privileges to SSAS from windows....

sorry I didn't make it clear from the beginning I am working with sql server not mysql.

I have data on a named sql server, last year i always referred to...