Share via


Defining Report Datasets for Multidimensional Data from a Hyperion Essbase Database

New: 12 December 2006

Reporting Services provides a data processing extension that supports multidimensional data retrieval from a Hyperion Essbase data source. This data processing extension provides a graphical query designer to help you explore data on the underlying data source and select the data to use in your dataset.

After you connect to a Hyperion Essbase data source, you can define a dataset that specifies the data to retrieve during report processing. For more information, see How to: Create a Dataset (Report Designer).

Query Designer Modes

You can use the graphical query designer in Design or Query mode to build a Multidimensional Expression (MDX) query by browsing the underlying data structures on the data source. At design time, you can interactively run a query from the query designer to see the results. The query you build defines fields in the dataset. At run time, the actual data is returned from the data source. Use the graphical query designer to perform the following actions:

  • In Design mode, drag dimensions, hierarchies, members, and member properties from the data source onto a Data pane to build a Multidimensional Expression (MDX) query. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using Hyperion Essbase MDX Query Designer in Design Mode.
  • In Query mode, drag dimensions, hierarchies, members, and member properties onto the Query pane or type MDX text directly into the Query pane. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using Hyperion Essbase MDX Query Designer in Query Mode.

For more information about the graphical query designer interface, see Hyperion Essbase Query Designer User Interface.

To Create a Dataset
  1. On the Data tab, from the Dataset drop-down list, select New Dataset.

  2. In the Dataset dialog box, from the Data source drop-down list, select New Data Source. In the Data Source dialog box, from the Type drop-down list, select Hyperion Essbase.

    Note

    If you do not see Hyperion Essbase as choice for data source type, you may need to configure Reporting Services to recognize this data processing extension. For more information, see Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider for Hyperion Essbase.

  3. Specify a connection string that works with your Hyperion Essbase data source. Contact your database administrator for connection information. The following connection string example specifies a Hyperion Essbase data source on a server using port 13080 and XML for Analysis Services (XMLA) over the Internet using SOAP, connecting to a sample catalog:

    Data Source=https://localhost:13080/aps/XMLA; Initial Catalog=Sample
    
  4. Set the database credentials in the Data Source dialog box on the Credentials tab. For more information, see Connecting to a Data Source.

Report Delivery Modes

Not all report delivery modes are supported by this data provider. Delivering reports through data-driven subscriptions is not supported for this data processing extension. For more information, see Using an External Data Source for Subscriber Data.

External Resources

Using SQL Server 2005 Reporting Services with Hyperion Essbase

See Also

Concepts

Defining Report Datasets
Report Data How-to Topics (Report Designer)
Connecting to a Data Source

Help and Information

Getting SQL Server 2005 Assistance