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