Creating, Changing, and Assigning Roles to InfoSets (SAP Library

Creating, Changing, and Assigning Roles to InfoSets

Use

Before you are able to work with the InfoSet Query, there must be InfoSets already available that are assigned to particular roles.

Procedure

There are various ways of getting to the InfoSet maintenance screen:

Choose Business Explorer ® InfoSet Query ® Maintain InfoSets (RSQ02) from the SAP Easy Access SAP Business Information Warehouse Menu.

Or call the InfoSet maintenance function from the Administrator Workbench context-dependently for ODS objects and InfoObjects.

The following deals primarily with BW-specific enhancements. The Basis documentation contains more detailed explanations on the more general InfoSet functions.

Define InfoSet

In the Administrator Workbench – Modeling, choose the InfoSets function from the context menu belonging to the object that requires an InfoSet. The InfoSets that use this particular object are displayed in the right half of the screen. The most important functions (Change, Display, Delete, and so on) from the basis transaction (RSQ02) are accessible via the InfoSet menu in the InfoSet Overview. To see if any queries already exist for an InfoSet, choose the Query Directory function. This lists all the queries that have already been created for an InfoSet. The InfoSet Maintenance entry takes you to the initial screen of the InfoSet maintenance where all the available InfoSets are listed.

Choose one of the following functions to create a new InfoSet for a particular object:

Regenerate Standard InfoSets.

An InfoSet containing all attributes is created for InfoObjects.

With ODS objects, the system generates an InfoSet from the table containing active data and an InfoSet "new and active data combined". If there is a more up-to-date record in the table containing the new data, this record is used in reporting instead of the active record. You are able to modify the standard InfoSet. Bear in mind that only the generated version can be used for the InfoSet Query.

You have to define an InfoSet manually, if you want to use joins. Specify a name in the Technical Name field, and choose Create New InfoSet.

This brings you to the InfoSet Maintenance screen. The InfoSet: Title and Data Source screen appears. Notice that the system has already identified the appropriate basic master data table or ODS table as the data source.

If you want to use an InfoSet for queries in a Web environment, you have to assign the InfoSet to a user group. Do this in the InfoSet: Title and Data Source screen. To call this screen in the future, choose the Global Properties function from the Goto menu in the InfoSet Maintenance screen.

After you confirm you entries, you get to the Join Definition. Determine the join conditions.

In the main screen of the InfoSet Maintenance, you:

choose all the attributes you require,

arrange these attributes into field groups,

determine the fields that are going to contain extra information (characteristics and key figures, for example) that was not contained originally in the InfoObjects or ODS objects.

Save your entries.

The Settings function in the InfoSet Maintenance screen allows you to switch to using DDIC names. You use this option when you are writing coding, defining upper and lower limits for an InfoSet, or connecting additional tables, for example, and you have to give the DDIC names rather than the technical names used in BW.

Assign InfoSet to a Role

Once you have saved and generated the InfoSet, you assign it to one or more roles. To do this, choose the Role Assignment function in the InfoSet overview. All the roles that have been set up for working with the InfoSet Query are displayed in a dialog box.

The roles that the InfoSet is already assigned to are flagged in the checkbox in the first column. Use the corresponding checkbox to:

assign the InfoSet to another one of the roles
remove an existing assignment. Before you unassign the InfoSet to a role, make sure that there are no queries left for the InfoSet within this particular role.

Result

It is now possible to use the InfoSet in the Query Builder within the context of the role assigned to the InfoSet.

See also:

Creating and Changing InfoSets

Creating InfoSet Queries

SAPNet - BW ® Documentation ® Documentation Enhancements ® BW 2.0B InfoSet Query - Step-by-Step (Step 2).