Before utilizing the CubeDataSource component in your reports you need to configure your report class library for using Microsoft Analysis Services first:
Install the Microsoft ADOMD.NET client data provider : The CubeDataSource component requires the Microsoft ADOMD.NET client data provider to be installed on your machine. The present version of Telerik Reporting is compiled against the ADOMD.NET provider for SQL Server 2008 R2.
You need to use Microsoft.AnalysisServices.AdomdClient with version 12 or lower. In AdomdClient version 13.0 the security configuration has changed and it cannot be used by our runtime. The reason is that the security policy changed and the assembly methods can no longer be accessed from assemblies that have AllowPartiallyTrustedCallers set to true, like ours.
Add the required assembly references to your project: You need to add the following assembly references to your report class library:
Microsoft.AnalysisServices.AdomdClient - this is the ADOMD.NET client data provider assembly which is normally located in the following directory after installation:
<Program Files>is the directory with your program files, and
<Product Version>is the version of the installed product (this should be 100 for ADOMD.NET for SQL Server 2008 R2).
Telerik.Reporting.Adomd - this is the Telerik Reporting provider assembly for ADOMD.NET which is located in the "Bin" subdirectory of your Telerik Reporting installation.
Add an assembly binding redirect if necessary: The current version of Telerik Reporting uses ADOMD.NET for SQL Server 2008 R2. Please, verify that the version of the Microsoft.AnalysisServices.AdomdClient assembly is "10.0.0.0". If you have a greater version of that assembly you need to add an appropriate assembly binding redirect in the configuration file of the start application as illustrated below:
<configuration> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="<Your Version>" /> </dependentAssembly> </assemblyBinding> </runtime> </configuration>
<Your Version>is the actual version of your Microsoft.AnalysisServices.AdomdClient assembly. It should be either 12 or lower due to the security policy introduced with version 13. In the case of a ClassLibrary project containing report definitions, the binding redirects should be applied in Visual Studio configuration file (devenv.exe.config).