How to add an OLAP DataSource
Environment
Product Version | 6.2.20.916 |
Product | Progress® Telerik® Report Server |
Description
This document describes how to configure the Report Server and Report Designer so you can add an OLAP Data Source (Cube Data Source).
Prerequisites
The suggested solution requires the following:
- Telerik Report Server
- Telerik Reporting
-
Telerik.ReportDesigner.exe
andTelerik.ReportDesigner.exe.config
(located in_InstallationPath_\Progress\Telerik Reporting {Version}\Report Designer
)
Solution
The following steps describe how to implement the required configuration:
Locate the
Telerik.ReportDesigner.exe
file in the Telerik Reporting installation folder and open the exe file.Create a new report or open an existing one in Telerik Report Designer. For more information on how to create or open a report, see Working with Report Server Reports.
Perform step 1 described in Configuring your project for using Microsoft Analysis Services.
-
Apply step 2 and step 3 described in Configuring your project for using Microsoft Analysis Services to the
Telerik.ReportDesigner.exe.config
file. The article Extending Report Designer explains how to add the required assembly references to the designer's config file.Telerik Reporting is built with ADOMD.NET for SQL Server 2008 R2, which means that the engine will expect to work with
Microsoft.AnalysisServices.AdomdClient
assembly version10.0.0.0
. When you use a more recent SQL Server version, you also have a more recent version of theMicrosoft.AnalysisServices.AdomdClient
assembly. That's why you need to add the binding redirect for this assembly as demonstrated in step 3. Verify that the Microsoft ADOMD.NET client data provider is installed on both Dev and Server machines.
Once the report is published, apply the same settings in the
_TelerikReportServerInstallationFolder_\Telerik.ReportServer.Web\TelerikReporting.config
file.-
Copy
Microsoft.AnalysisServices.AdomdClient.dll
andTelerik.Reporting.Adomd.dll
into theTelerik.ReportServer.Web\bin
andTelerik Reporting {Version}\Report Designer
folders.The
Telerik.Reporting.Adomd.dll
assembly is distributed with the Telerik Reporting installation. It is located by default in_InstallationPath_\Progress\Telerik Reporting {Version}\Bin)
.