Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

hr

Former Member
0 Likes
784

Hi,

wht is meant by infoset?

regards,

kb

6 REPLIES 6
Read only

former_member188829
Active Contributor
Read only

Former Member
0 Likes
722

InfoSet

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.

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.

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

Read only

Former Member
Read only

Former Member
0 Likes
722

Hi,

Few notes are below:

InfoSets in the HR Application

You can use SAP Query in HR to report on HR data. Queries are maintained as described in Creating Queries. The special features of queries created for HR are described in Maintaining Queries in the Human Resources Application. The maintenance procedure for HR InfoSets differs from the described procedure inasmuch as HR data fields are grouped together in infotypes.

InfoSet management in SAP Query is also used for InfoSet Query. For further information, see Functions for Managing InfoSets.

If you want to create InfoSets for HR, you can use logical databases PNP, PNPCE, PAP, and PCH (see HR Logical Databases). The database you must use to create your InfoSet depends on the component in which the data you want to report on is stored.

The reports you can execute using InfoSets based on logical databases PNP (or PNPCE) or PCH are similar, but differ in that they can select different objects. The following table describes the connection between the logical database, and the infotypes you can include in an InfoSet. It also provides you with one or two examples of reports that you can execute using the appropriate InfoSets.

Logical database PNP/PNPCE* PCH PAP

Selection of Persons Objects from Personnel Planning Applicants

Infotypes that can be included in the InfoSet Infotypes for· Personnel Administration (0000-0999) · Time Management (2000-2999) · Payroll infotypes · Infotypes for Personnel Planning objects that can be related to persons If the object type is specified:· Infotypes for the object type · Infotypes for objects that can be related to the specified object typeIf the object type is not specified:· All infotypes · Infotypes for Recruitment (4000-4999)· Some infotypes for Personnel Administration (such as 0001 and 0002)

· Customer infotypes

Reporting examples · Selection of all persons who participated in a specific business event, output of prices for reserved business events · Selection of all persons assigned to a specific personnel area, output of qualifications held by these persons · Selection of all business events held in London in March, output of all persons who participated in these business events · Selection of all positions assigned to a specific organizational unit, output of all persons assigned to the positions · Selection of all applicants hired last year to work on special projects, output of addresses for the applicants selected

  • Logical database PNPCE (PNP Concurrent Employment) functions just like logical database PNP. The procedure for creating InfoSets is also the same. It only becomes significant if you work with Concurrent Employment.

Creating InfoSets

The maintenance procedure for HR InfoSets differs from the procedure described so far in this section inasmuch as HR data fields are grouped together in infotypes. To set up an InfoSet for the HR application, proceed as follows:

1. On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose Create.

2. On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements.

Customer infotypes can be created on all HR logical databases. In each individual case, therefore, you must decide which database to select so that you can report on customer infotypes.

This screen enables you to enter an authorization group. All of the queries that are subsequently created using this InfoSet can only be executed by persons who have this authorization group.

3. Choose .

This takes you to the Infotype Selection for InfoSet screen. You now have the option of creating field groups and assigning fields as required for non-HR InfoSets. Field groups that correspond to infotypes and already contain fields, however, are always created for HR InfoSets. The field groups are displayed in an overview tree in the top right section of the screen.

The infotypes that you included in the InfoSet are displayed in an overview tree on the left of the screen. The infotype fields that are already included in field groups are displayed in a different color, and the corresponding field group ID is displayed.

In the standard system, a field group is created automatically for each infotype that you included in the InfoSet (a field group corresponds to an infotype).

In the standard system, each field group contains the infotype-specific fields. To ensure that working with the InfoSet is as easy as possible, you are advised to restrict your use of fields in each field group to those you really require. This means you should remove fields that are not required.

An infotype's fields must only be assigned to the pertinent field group. Make sure this assignment is correct. If the assignment is incorrect, the InfoSet could be rendered unusable.

When an InfoSet is created, the following fields are transferred automatically to the first field group:

§ Logical database PNPCE or PNP Personnel number

§ Logical database PAP Applicant number

§ Logical database PCH Object ID, plan version, and object type

6. Determine the fields that must be included in the field groups of your InfoSet. If you require further information, see Assigning Fields to a Field Group.

If you want, you can change the default sequence of field groups and fields as required using Drag&Drop.

7. To save the InfoSet, choose .

8. To generate the InfoSet, choose .

On the Change InfoSet (InfoSet name) screen, you can choose Edit ® Change infotype selection to add more infotypes to the InfoSet, or to remove infotypes from the InfoSet. Remember to regenerate the InfoSet afterwards.

This screen also enables you to update InfoSets if, for example, the system contains new additional fields for specific key values. To do so, choose InfoSet ® Additional functions ® Update additional HR fields.

9. Go back to the initial screen for InfoSet maintenance.

10. Choose User group assignment.

11. Select a user group, and save your entry.

Hope it is useful.

Thanks,

Sandeep.

Read only

Former Member
0 Likes
722

thanks

Read only

0 Likes
722

Did anyone see any of Subject More than 13 words?