NIB Configuring Reporting Services to Use the Microsoft .NET Data Provider for Hyperion Essbase

[Cette rubrique est une documentation préliminaire susceptible d'être modifiée dans les versions ultérieures. Les rubriques vierges sont incluses comme espaces réservés.]

Reporting Services provides support for the Microsoft .NET Framework Data Provider for Hyperion Essbase so you can retrieve and use multidimensional business intelligence data from Hyperion Essbase databases in Reporting Services reports.

You must configure the data provider on the report server to publish reports or to use as a data source in the design view of Report Designer. To configure the data provider for use on a report server, first check the RSReportDesigner.config and RSReportServer.config files to verify this data provider is registered. If it is not registered, follow the steps below to register the data provider. Each of these configuration files identifies the data extensions that can be used in reports. By adding the specific registration information for a data extension, you enable its use by a report.

Modifying the RSReportDesigner.config File

Before you can build report definitions that retrieve data using the Microsoft .NET Framework Data Provider 1.0 for Hyperion Essbase, you must verify that the following two changes have been made to the RSReportDesigner.config file:

  1. Using a browser, locate <drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies on the client.

  2. Make a backup copy of RSReportDesigner.config.

  3. Using a text editor, and open the RSReportDesigner.config file.

  4. In the <Data> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.

    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
    

    This registers the data processing extension on the client that connects to a Hyperion Essbase system.

  5. In the <Designer> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.

    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.QueryDesigners.Essbase.EssbaseQueryDesigner,Microsoft.ReportingServices.QueryDesigners.Essbase"/>
    

    This registers the query designer for the Hyperion Essbase data source.

With these entries in the configuration file, the Hyperion Essbase data provider becomes available as a data source type that you can select in the Data Source dialog box in Report Designer. To learn more about specifying the connection string and queries that retrieve multidimensional business intelligence data, see Creating Report Datasets for Multidimensional Data from a Hyperion Essbase Data Source (Reporting Services).

Modifying the RSReportServer.config File

Before you can build report definitions that retrieve data using the Microsoft .NET Framework Data Provider 1.0 for Hyperion Essbase, you must verify that the following change has been made to the RSReportServer.config file:

  1. Using a browser, locate <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer on the report server.

  2. Make a backup copy of RSReportServer.config.

  3. Using a text editor, open the RSReportServer.config file.

  4. In the <Data> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.

    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
    

    This registers the report server on the server that connects to a Hyperion Essbase data source.

  5. Save the file.

Requirements

The Microsoft .NET Framework Data Provider 1.0 for Hyperion Essbase supports the following versions:

  • Hyperion System 9.3 Beta 2 BI+ Enterprise Analytics with Hyperion System 9 Enterprise Analytics Adapter

The following operating systems are supported:

  • Microsoft Windows Server 2003
  • Microsoft XP Professional
  • Microsoft Windows 2000 Professional

Voir aussi

Concepts

Fichiers de configuration (Reporting Services)
Fichier de configuration RSReportDesigner
Fichier de configuration RSReportServer

Autres ressources

Deploying a Data Processing Extension
Creating Report Datasets for Multidimensional Data from a Hyperion Essbase Data Source (Reporting Services)

Aide et informations

Assistance sur SQL Server 2008