Hyperion Essbase 连接类型 (SSRS)Hyperion Essbase Connection Type (SSRS)

若要在报表中包含来自 Hyperion EssbaseHyperion Essbase 外部数据源的数据,您必须拥有一个基于 Hyperion EssbaseHyperion Essbase类型的报表数据源的数据集。To include data from a Hyperion EssbaseHyperion Essbase external data source in your report, you must have a dataset that is based on a report data source of type Hyperion EssbaseHyperion Essbase. 此内置数据源类型基于 Hyperion EssbaseHyperion Essbase的数据扩展插件,让你可以从 Hyperion EssbaseHyperion Essbase 外部数据源检索多维数据。This built-in data source type is based on the data extension for Hyperion EssbaseHyperion Essbase, which enables you to retrieve multidimensional data from a Hyperion EssbaseHyperion Essbase external data source.

使用本主题中的信息来生成一个数据源。Use the information in this topic to build a data source. 有关分步说明,请参阅 添加和验证数据连接(报表生成器和 SSRS)For step-by-step instructions, see Add and Verify a Data Connection (Report Builder and SSRS).

连接字符串Connection String

下面的连接字符串示例指定使用端口 13080 的服务器上的 Hyperion EssbaseHyperion Essbase 数据源以及使用 SOAP 的 Internet 上的 XML for Analysis ServicesAnalysis Services (XMLA),并连接到示例目录:The following connection string example specifies a Hyperion EssbaseHyperion Essbase data source on a server that uses port 13080 and XML for Analysis ServicesAnalysis Services (XMLA) over the Internet using SOAP, connecting to a sample catalog:

Data Source=https://localhost:13080/aps/XMLA; Initial Catalog=Sample  

有关连接字符串示例的更多信息,请参阅创建数据连接字符串 - 报表生成器和 SSRSFor more information about connection string examples, see Create data connection strings - Report Builder & SSRS.

凭据Credentials

执行以下操作时需要提供凭据:运行查询、本地预览报表以及从报表服务器预览报表。Credentials are required to run queries, to preview the report locally, and to preview the report from the report server.

报表发布后,您可能需要更改数据源的凭据,以使报表在报表服务器上运行时,用于检索数据的权限有效。After you publish your report, you may need to change the credentials for the data source so that when the report runs on the report server, the permissions to retrieve the data are valid.

有关详细信息,请参阅为报表数据源指定凭据和连接信息For more information, see Specify Credential and Connection Information for Report Data Sources.

查询Queries

可以通过下列方式指定查询:You can specify a query in the following ways:

  • 以交互方式生成查询。Build a query interactively. 在设计模式或查询模式下使用图形查询设计器,可浏览外部数据源中的元数据和生成采用多维表达式 (MDX) 语法的查询。Use the graphical query designer in Design or Query mode to browse the metadata on the external data source and generate a query in Multidimensional Expression (MDX) syntax.

    • 设计视图 将维度、成员、成员属性、度量值和 KPI 从元数据浏览器拖至 “数据” 窗格,以生成 MDX 查询。Design View Drag dimensions, members, member properties, measures, and KPIs from the metadata browser to the Data pane to build an MDX query. 将计算成员从“计算成员”窗格拖至“数据”窗格,以定义附加数据集字段。Drag calculated members from the CalculatedMembers pane to the Data pane to define additional dataset fields.

    • 查询视图 将维度、成员、成员属性、度量值和 KPI 从元数据浏览器拖至“查询”窗格,以生成 MDX 查询。Query View Drag dimensions, members, member properties, measures, and KPIs from the metadata browser to the Query pane to build an MDX query. 在“查询”窗格中可以直接编辑 MDX 文本。You can edit MDX text directly in the Query pane. 将计算成员从“计算成员”窗格拖至“查询”窗格,以定义附加数据集字段。Drag calculated members from the CalculatedMembers pane to the Query pane to define additional dataset fields.

    有关详细信息,请参阅 Hyperion Essbase 查询设计器用户界面(报表生成器)For more information, see Hyperion Essbase Query Designer User Interface (Report Builder).

  • 从报表导入现有 MDX 查询。Import an existing MDX query from a report. 使用 “导入” 查询按钮浏览到 .rdl 文件并导入查询。Use the Import query button to browse to an .rdl file and import a query. 对于包含基于 Hyperion EssbaseHyperion Essbase 数据源的嵌入数据集的报表,可以从中导入查询。You can import a query from a report that contains an embedded dataset that is based on a Hyperion EssbaseHyperion Essbase data source. 不支持直接从 .mdx 文件导入 MDX 查询。Importing an MDX query directly from an .mdx file is not supported.

在设计时,运行查询以查看结果集。At design time, run the query to view a result set. 生成查询后,在“报表数据”窗格中查看从元数据生成的数据集字段集合。After you build the query, view the dataset field collection that is generated from the metadata in the Report Data pane. 报告运行时,将从外部数据源返回实际数据。When the report runs, the actual data is returned from the external data source.

Hyperion EssbaseHyperion Essbase 数据处理扩展插件支持扩展数据集字段属性。The Hyperion EssbaseHyperion Essbase data processing extension supports extended dataset field properties. 这些值可从外部数据源获得,但在“报表数据”窗格中不显示。These are values that are available from the external data source but that do not appear in the Report Data pane. 有关详细信息,请参阅本主题后面的 扩展字段属性For more information, see Extended Field Properties later in this topic.

查询参数Query Parameters

若要包括查询参数,请在查询设计器的筛选区域创建一个筛选器,并将该筛选器标记为参数。To include query parameters, create a filter in the filter area in the query designer, and mark the filter as a parameter. 系统将为每个筛选器自动创建一个数据集以提供可用值。For each filter, a dataset is automatically created to provide the available values. 默认情况下,这些数据集不显示在“报表数据”窗格中。By default, these datasets do not appear in the Report Data pane. 有关详细信息,请参阅为多维数据的参数值显示隐藏的数据集(报表生成器和 SSRS)For more information, see Show Hidden Datasets for Parameter Values for Multidimensional Data (Report Builder and SSRS).

默认情况下,每个报表参数的数据类型均为 TextBy default, each report parameter has data type Text. 创建报表参数后,您可能需要更改默认值。After the report parameters are created, you might have to change default values. 有关详细信息,请参阅 报表参数(报表生成器和报表设计器)的详细信息。For more information, see Report Parameters (Report Builder and Report Designer).

扩展字段属性Extended Field Properties

Hyperion EssbaseHyperion Essbase 数据处理扩展插件支持扩展字段属性。The Hyperion EssbaseHyperion Essbase data processing extension supports extended field properties. 扩展字段属性是除了通过数据处理扩展插件为数据集字段定义的 ValueIsMissing 之外的其他属性。Extended field properties are properties in addition to Value and IsMissing that are defined for a dataset field by the data processing extension. 扩展属性包括预定义属性和自定义属性。Extended properties include predefined properties and custom properties. 预定义属性是对多个数据源通用的属性。Predefined properties are properties common to multiple data sources. 自定义属性对于每个数据源都是唯一的。Custom properties are unique to each data source.

扩展字段属性不作为可拖至报表布局的项出现在“报表数据”窗格中。Extended field properties do not appear in the Report Data pane as items that you can drag onto your report layout. 不过,您可以将该属性的父字段拖至报表中,然后将默认属性由 Value 更改为要使用的属性。Instead, you drag the parent field of the property onto the report and then change the default property from Value to the property you want to use.

当您将鼠标光标停在查询设计器“元数据”窗格中的某个字段上时,扩展字段属性的名称便会显示在工具提示中。The name for an extended field property appears in the ToolTip when you rest the mouse on a field in the Metadata pane in the query designer. 有关可用于浏览基础数据的查询设计器的详细信息,请参阅 Hyperion Essbase Query Designer User InterfaceFor more information about the query designer you can use to explore the underlying data, see Hyperion Essbase Query Designer User Interface.

备注

仅当扩展字段属性包含在 MDX 表达式中,且数据源在报表运行和为其数据集检索数据的情况下提供扩展字段属性的值时,这些值才存在。Values exist for extended field properties only if they are included in the MDX expression and the data source provides these values when your report runs and retrieves the data for its datasets. 然后,您就可以使用下面一节所述的语法从任意表达式引用这些 Field 属性值。You can then refer to those Field property values from any expression using the syntax described in the following section. 但是,由于这些字段特定于此数据访问接口,而不是报表定义语言的一部分,因此,对这些值所做的更改不会随报表定义一同保存。However, because these fields are specific to this data provider and not part of the report definition language, changes that you make to these values are not saved with the report definition.

预定义的字段属性Predefined Field Properties

通常受多个数据访问接口支持并出现在报表数据集的基础 MDX 查询中的预定义字段属性。Predefined field properties that are typically supported by multiple data providers and that appear in the underlying MDX query for a report dataset. 例如,MDX 维度属性 MEMBER_UNIQUE_NAME 映射到预定义报表数据集字段属性 UniqueNameFor example, the MDX dimension property MEMBER_UNIQUE_NAME is mapped to the predefined report dataset field property UniqueName. 若要在文本框中包含唯一名称值,请使用表达式 =Fields!<FieldName>.UniqueNameTo include the unique name value in a text box, use the expression =Fields!<FieldName>.UniqueName.

下表提供了可以用于 Hyperion EssbaseHyperion Essbase 数据源的预定义字段属性的列表。The following table provides a list of predefined field properties that you can use for a Hyperion EssbaseHyperion Essbase data source.

PropertyProperty TypeType 说明或所需的值Description or expected value
Value ObjectObject 指定字段的数据值。Specifies the data value of the field.

对于维度属性,它映射到 MEMBER_CAPTION。For a dimension property, this is mapped to MEMBER_CAPTION. 对于度量值,它映射到数据值。For a measure, this is mapped to the data value.
IsMissingIsMissing 布尔值Boolean 指示是否在结果数据集中找到了该字段。Indicates whether the field was found in the resulting data set.
FormattedValueFormattedValue 字符串String 返回关键数字的格式值。Returns a formatted value for a key figure.

映射自 MDX 表达式中的 FORMATTED_VALUE。Mapped from FORMATTED_VALUE in the MDX expression.
BackgroundColorBackgroundColor 字符串String 返回数据库中为该字段定义的背景颜色。Returns the background color defined in the database for the field.

映射自 MDX 表达式中的 BACK_COLOR。Mapped from BACK_COLOR in the MDX expression.
彩色Color 字符串String 返回数据库中为该项定义的前景色。Returns the foreground color defined in the database for the item.

映射自 MDX 表达式中的 FORE_COLOR。Mapped from FORE_COLOR in the MDX expression.
UniqueNameUniqueName 字符串String 返回级别的完全限定名称。Returns the fully qualified name of a level.

映射自 MDX 表达式中的 MEMBER_UNIQUE_NAME。Mapped from MEMBER_UNIQUE_NAME in the MDX expression.

有关如何在表达式中使用字段和字段属性的详细信息,请参阅表达式中的内置集合(报表生成器和 SSRS)For more information about how to use fields and field properties in an expression, see Built-in Collections in Expressions (Report Builder and SSRS).

自定义属性Custom Properties

为某个数据访问接口所支持并出现在报表数据集的基础 MDX 查询中的自定义字段属性,但这些属性不作为该数据集的字段出现在报表“数据集”窗格中。Custom field properties that are supported by a data provider and that appear in the underlying MDX query for a report dataset, but do not appear in the report Datasets pane as fields under that dataset. 例如, Long Names 是为某个维度级别定义的成员属性。For example, Long Names is a member property defined for a dimension level. 若要在文本框中包含该值,请使用表达式 =Fields!<FieldName>("Long Names")To include the value in a text box, you use the expression =Fields!<FieldName>("Long Names"). 表达式中的字段名区分大小写。Field names in the expression are case-sensitive.

可以使用以下语法在表达式中引用自定义扩展属性:Use the following syntax to refer to custom extended properties in an expression:

  • Fields!FieldName("PropertyName")Fields!FieldName("PropertyName")

下表显示了可用于 Hyperion EssbaseHyperion Essbase 数据源的自定义字段属性。The following table shows the custom field property that you can use for a Hyperion EssbaseHyperion Essbase data source.

PropertyProperty TypeType 说明或所需的值Description or expected value
FORMAT_STRINGFORMAT_STRING 字符串String 针对度量值定义,是可作为 String 类型的 FormattedValueDefined on a measure, this is the FormattedValue available as a String type.

注释Remarks

不是所有的报表传递模式都受到此数据访问接口的支持。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 Use an External Data Source for Subscriber Data (Data-Driven Subscription).

有关详细信息,请参阅 Using SQL Server 2005 Reporting Services with Hyperion Essbase(使用具有 Hyperion Essbase 的 SQL Server 2005 Reporting Services)。For more information, see Using SQL Server 2005 Reporting Services with Hyperion Essbase.

操作指南主题How-To Topics

本节包含使用数据连接、数据源和数据集的分步说明:This section contains step-by-step instructions for working with data connections, data sources, and datasets:

添加和验证数据连接(报表生成器和 SSRS)Add and Verify a Data Connection (Report Builder and SSRS)

创建共享数据集或嵌入数据集(报表生成器和 SSRS)Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS)

向数据集添加筛选器(报表生成器和 SSRS)Add a Filter to a Dataset (Report Builder and SSRS)

文档中的这些章节提供有关报表数据的深入概念性信息,以及有关如何定义、自定义和使用与数据相关的报表部件的步骤信息。These sections of the documentation provide in-depth conceptual information about report data, as well as procedural information about how to define, customize, and use parts of a report that are related to data.

报表数据集 (SSRS)Report Datasets (SSRS)
提供访问报表数据的概述。Provides an overview of accessing data for your report.

创建数据连接字符串 - 报表生成器和 SSRSCreate data connection strings - Report Builder & SSRS
提供有关数据连接和数据源的信息。Provides information about data connections and data sources.

报表的嵌入数据集和共享数据集(报表生成器和 SSRS)Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
提供有关嵌入数据集和共享数据集的信息。Provides information about embedded and shared datasets.

数据集字段集合(报表生成器和 SSRS)Dataset Fields Collection (Report Builder and SSRS)
提供有关数据集查询生成的字段集合的信息。Provides information about the field collection that is generated by the dataset query.

有关每个数据扩展插件的平台和版本支持的详细信息,请参阅 Reporting Services 支持的数据源 (SSRS)Data Sources Supported by Reporting Services (SSRS) Provides in-depth information about platform and version support for each data extension.

Using SQL Server 2005 Reporting Services with Hyperion EssbaseUsing SQL Server 2005 Reporting Services with Hyperion Essbase
提供有关使用此数据扩展插件的详细信息。Provides detailed information about working with this data extension.

另请参阅See Also

报表参数(报表生成器和报表设计器) Report Parameters (Report Builder and Report Designer)
对数据进行筛选、分组和排序(报表生成器和 SSRS) Filter, Group, and Sort Data (Report Builder and SSRS)
表达式(报表生成器和 SSRS)Expressions (Report Builder and SSRS)