D:\Work\Projects\Agile Design Company\Portal\Products\SsasEFProvider\Installation-Instructions.html

SSAS Entity Framework Provider (tm)
Installation Instructions


You need Microsoft .NET Framework 4.0-4.5 and ADO.NET Entity Framework 4.1 - 6.0 installed.

An access to SQL Server Analysis Services (SSAS) is not required, but strongly suggested if you deal with large data volumes. In that case you will need Microsoft SQL Server (r) 2005-2012 (Standard, Developer, Enterprise, Business Intelligence or Datacenter Edition) with SSAS installed. Both Multidimensional (UDM) and Tabular (BISM) SSAS models are supported, but this document uses Multidimensional model. Tabular model requires MS SQL Server 2012 Enterprise or Developer Edition.

(See http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx for information about MS SQL Server editions).

Installation steps:

  • Run SsasEntityFrameworkProviderSetup.msi and follow the wizard. (This will deploy documentation, code samples, sample SSAS database backup, local offline cube file and all needed .NET assemblies into "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider \" folder and GAC).If you already have NorhtwindEFOlap sample SSAS database installed on your SQL Server or if you do not need it, you can skip to Verification step.
  • If you would like to use SSAS rather than local offline cube file, and your MS SQL Server is not (local), modify connection string in "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider \UsageExample\Sample SSAS Database\RestoreNorhtwindEFSsasDatabase.cmd". You need to change yellow part:
    ascmd -i RestoreSsasDB.xmla -S (local)
  • If you would like to install NorthwindEFOlap sample SSAS database and verify installation run "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider\UsageExample\Sample SSAS Database\RestoreNorthwindEFSsasDatabase.cmd" and make sure there are no errors in the output.


  • If you do not have an access to SSAS or you would like to run from local offline cube file, skip to step 3.
  • If you would like to use SSAS rather than local offline cube file and if your MS SQL Server is not (local), modify connection string in "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider\UsageExample\Bin\Debug\UsageExample.exe.config" configuration file. You need to modify a connection string named NorthwindEFOlapOnlineServer:
    <add name="NorthwindEFOlapOnlineServer" connectionString="Provider=MSOLAP.4;Data Source=.;Initial Catalog=NorthwindEfOlap;Integrated Security=SSPI;Cube=NorthwindEF" providerName="AgileDesign.SsasEntityFrameworkProvider" />
    It is likely that you need to change DataSource part highlighted in yellow (or entire connectionString attribute in some cases) to point it to where your SQL Server is located. Delete NorthwindEFOlapOfflineCubeFile connection string from UsageExample.exe.config and rename NorthwindEFOlapOnlineServer connection string into NorthwindEFOlapOfflineCubeFile.
  • Run "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider\UsageExample\Bin\Debug\UsageExample.exe" and make sure it outputs sample MDX query and its results into console. It should not throw any exceptions.

Now you can reference and use SSAS Entity Framework Provider assemblies located in "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider\" folder or in Global Assembly Cache (GAC).

In order to understand how to use SSAS Entity Framework Provider, please see source code located in "%ProgramFiles%\Agile Design LLC\SSAS Entity Framework Provider\UsageExample\" folder, Getting Started Walkthrough , LINQ/SDX example and FAQ.