Show TOC

BEx Queries Based on InfoSetsLocate this document in the navigation structure

Use

The BEx Query Designer supports a tabular (flat) display of queries. Use the Table Display pushbutton to activate this function.

In the BEx Query Designer, each InfoProvider in the join of type DataStore object or characteristic bearing master data displays two separate dimensions (key and attribute). The dimensions of the InfoCube are mapped for InfoCubes. These dimensions contain the fields and attributes for the selected InfoSet.

Note

If the InfoProvider is an InfoObject of the type Characteristic, all the characteristics listed in the attribute definition and all the display attributes are assigned to the characteristic (and to the existing compound characteristics) in the Key dimension:

  • The display attributes are only listed in the Key dimension.

  • The independent characteristics are listed in both the Key and the Attribute dimensions.

    If the InfoProvider is a DataStore object or an InfoCube, no field objects with the Exclusive Attribute property are listed in the directory tree of the InfoProvider.

    If the join is a temporal join, there is also a separate Valid Time Interval dimension in the BEx Query Designer.

More information: Temporal Join

InfoSets offer you the most recent reporting for characteristics that bear master data; in reporting and analysis, the newest records are displayed, even if they are not activated yet.

More information: Most Recent Reporting for InfoObjects

More information about the technical details and examples of queries that use InfoSets: Interpreting Queries Using InfoSets.

More information about defining queries: BEx Query Designer.