Connecting to SQL Server Analysis Services (SSAS) Multidimensional

Last Updated On
Table of Contents
  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.