Extended Field Properties for a SAP NetWeaver BI Connection Type (SSRS)

SQL Server 2008 R2

The SAP NetWeaver Business Intelligence data source supports extended field properties. 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. 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. For example, if the field name Calendar Year/Month Level 01 is created in an MDX query designer by dropping a level from the Metadata pane onto the Query pane, you would refer to the custom extended property Long Name in an expression using the following syntax:

=Fields!Calendar_Year_Month_Level_01("Long Name")

The name for an extended field property appears in the ToolTip when you hover over a field in the Metadata pane. For more information about the query designers you can use to explore the underlying data, see SAP NetWeaver BI Query Designer User Interface.

For more information about using fields and field properties in an expression, see Using Built-in Collections in Expressions (Report Builder 3.0 and SSRS).

Note   Values exist for extended field properties only if the data source provides these values when your report runs and retrieves the data for its datasets. You can then refer to those Field property values from any expression using the syntax described below. 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.

Use either of the following syntaxes to refer to predefined extended properties in an expression:

  • Fields!FieldName.PropertyName


Use the following syntax to refer to custom extended properties in an expression:


The following table provides a list of predefined field properties that you can use for an SAP NetWeaver Business Intelligence data source.



Description or expected value



Specifies the data value of the field.



Indicates whether the field was found in the resulting data set.



Returns a formatted value for a key figure.



Returns the background color defined in the database for the field.



Returns the foreground color defined in the database for the item.



Returns the key for a level.



For parent-child hierarchies, returns the level or dimension number.



For parent-child hierarchies, returns a fully qualified name of the parent level.



Returns the fully qualified name of a level. For example, the UniqueName value for an employee might be [0D_Company].[10D_Department].[11].

Community Additions