Processing Classic InfoSet and Assigning Roles

Use

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

Procedure

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

•    Call up transaction RSQ02 InfoSet: Entry. 
•   Call up using the context menu for ODS objects or InfoObjects from      the Modeling view of the Administrator Workbench

The following deals primarily with BW-specific enhancements. You can find extensive notes for the InfoSet functions that are generally available in Basis in the SAP documentation for a SAP query. These notes also cover the BW Classic InfoSets.

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

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

•         Regenerate Standard InfoSets.

A Classic InfoSet containing all attributes is created for InfoObjects.

With ODS objects, the system generates a Classic InfoSet from the table containing active data and a “new and active data combined” Classic InfoSet. 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 Classic InfoSet. Bear in mind that only the generated version can be used for the InfoSet Query.

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

The Classic InfoSet Maintenance screen appears The Classic 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 a Classic InfoSet for queries in a Web environment, you have to assign the InfoSet to a user group. Do this in the Classic InfoSet: Title and Data Source screen. To call this screen in the future, choose the Global Properties function from the Goto menu in the Classic InfoSet Maintenance screen.

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

In the main screen of the Classc 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 Classic 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 a Classic InfoSet, or connecting additional tables, for example, and you have to give the DDIC names rather than the technical names used in BW.

Assigning Classic InfoSet to a Role

•  Once you have saved and generated the Classic InfoSet, you assign it to one or more roles. To do this, choose the Role Assignment function in the Classic 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 Classic InfoSet is already assigned to are flagged in the checkbox in the first column. Use the corresponding checkbox to:

-         assign the Classic InfoSet to another one of the roles
-         remove an existing assignment. Before you do this, 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 Classic InfoSet.