BEx Queries Based on InfoSets

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.

• 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.