Start of Content Area

Object documentation InfoSet  Locate the document in its SAP Library structure

Definition

Name for a particular type of InfoProvider: An InfoSet describes data sources that are usually defined as joins for ODS objects or InfoObjects (characteristics with master data). A time-dependent join or temporal join is a join that contains an InfoObject that is a time-dependent characteristic.

An InfoSet is a semantic layer over the data sources and is not itself a data target.

Unlike the classic InfoSet, and InfoSet is a BW-specific view of data.

For more information see the following documentation: InfoProviders, Classic InfoSets.

Use

In the BEx Query Designer you compile reports (queries) about activated InfoSets.

InfoSets allow you to report on several InfoProviders by using combinations of master data-bearing characteristics and ODS objects. The information is collected from the tables of the relevant InfoProviders. When an InfoSet is made up of several characteristics, you are able to map transitive attributes and report on this master data.

Example

You create an InfoSet using the characteristics Business Partner (0BPARTNER) – Vendor (0VENDOR) – Business Name (0DBBUSNAME), and can then use the master data for reporting.

You can create time runs with an InfoSet by means of a temporal join (for this, see Temporal Joins). With all other types of BW object, the data is determined for the query key date, but with a temporal join in an InfoSet, you can specify a particular point in time at which you want the data to be evaluated.

Structure

Every ODS object and every InfoObject that is a characteristic with master data can be included in a join. A join can contain objects of the same object type, or objects of different object types. The individual objects can appear in a join any number of times. Join conditions connect the objects in a join to one another (equal join-condition). A join condition determines the combination of records from the individual objects that are included in the resulting set.

Integration

InfoSet Maintenance in the Administrator Workbench

You create and edit InfoSets in the InfoSet Builder. See Creating InfoSets and Editing InfoSets.

Reports using InfoSets

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

For every InfoProvider that is included in a join there are two dimensions (key and attribute) in the BEx Query Designer. These dimensions contain the fields and attributes for the selected InfoSet.

Note

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

         The display attributes are listed exclusively in the Key dimension.

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

If the InfoProvider is an ODS object, a field object with the property “exclusive attribute” is not listed in the directory tree of the InfoProvider.

If the join is temporal, there is also a separate dimension, Valid Time Interval, in the query designer. See Temporal Joins.

InfoSets offer you the most recent reporting for master data-carrying characteristics, so that in reporting, the newest records are displayed, even if they are not yet activated.

You can find additional information about the technical details of queries using InfoSets and examples under Interpretation of Reports Using InfoSets.

You can find additional information about defining queries under Query Design: BEx Query Designer

Transport Connection

As a TLOGO object, an InfoSet is connected to the transport system for the Business Information Warehouse. You can find additional information under Transport Systems.

Definition and delivery of Content

Business Content is defined and delivered in the usual way in the Business Information Warehouse. InfoSets are delivered in a D-version, and have to be activated by the customer (see Business Content (Versions)).

 

 

End of Content Area