Connecting to SQL Server Analysis Services (SSAS) Multidimensional

1. Open BiG EVAL and open the navigation menu “System” > “Datasources”.
   
2. Add a new datasource and give it a name.
   
3. Choose “OLEDB” as the type of the datasource.
   
4. Use the following connection-string and ensure that the placeholder-values are replaced correctly.
   Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase; 
   
5. Choose “Multidimensional Expressions (MDX)” as the dialect.
   
6. Save the datasource.