Hi,
Creating InfoSets
Prerequisites
Make sure that the objects for which you want to define the InfoSet are active. Create any required InfoObjects that do not exist already and activate them.
Instead of creating a new InfoSet, you can transfer one of the InfoSets that are delivered with SAP Business Content.
Procedure
...
1. You are in the InfoProvider tree of the Modeling function area in the Administrator Workbench.
Choose the Create InfoSet function from the context menu (right mouse-click) of the InfoArea in which you want to create an InfoSet. You get to the Create InfoSet dialog box.
2. Type in the following information for your new InfoSet:
¡ technical name
¡ long description
¡ short description
3. In the Start with InfoProvider section, you determine which InfoProvider you want to use to start defining the InfoSet.
¡ Select one of the object types that the system offers you:
ODS Object
InfoObject
Choose an object.
If you want to choose an InfoObject, it must be a characteristic with master data. The system provides you with the corresponding input help.
4. Choose Continue. You get to the Change InfoSet screen. For more information on editing InfoSets see Editing InfoSets.
When you create an InfoSet, the system generates a corresponding entry for this InfoSet in the subtree of the InfoArea. The following functions are available from the context menu (right mouse-click) of this entry:
• Change
• Delete
• Object overview
Editing InfoSets
Prerequisites
Before you can get to the screen where you edit InfoSets, the following prerequisites have to be met:
• You have created a new InfoSet.
• You have selected the Change function from the context menu of an InfoSet entry in the InfoProvider tree of the Modeling function area in the Administrator Workbench.
• You have called the InfoSet Builder transaction, and selected the Change function. You can find additional information under Additional Functions in the InfoSet Builder .
Procedure
...
1. You are in the Change InfoSet screen.
Choose a layout for the InfoProvider tree:
InfoArea
InfoProviders Used
All ODS Objects
All InfoObjects
For more information on the screen layout, particularly the layout of the InfoProvider tree, see Screen Layout: Changing InfoSets.
2. Use the function Where-Used List via AWB to determine which BW objects use the InfoSet that you have selected. You get to the Administrator Workbench: Where-Used List screen. You are able to work out what would happen in the system if you made changes to the InfoSet. This helps you to decide whether or not it is sensible to make these changes at this particular point in time.
3. You define the InfoSet by inserting one or more InfoProviders into the join.
There are several ways of inserting an InfoProvider into the join control:
¡ From the InfoProvider tree:
§ In the InfoProvider tree, double-click on the entry that corresponds to the InfoProvider that you want to add to the join control.
§ Use the drag-and-drop function to move the InfoProvider into position.
¡ Choose the Add InfoProvider function, to add a particular ODS object or a particular InfoObject independently of the current layout of the InfoProvider tree. You get to the dialog box of the same name. Enter the data that the system asks you for.
If you know the technical name of the InfoProvider that you want to add, this method is quicker than switching the layout of the InfoProvider tree.
When this function is complete, the InfoProvider that you selected is displayed in the join control. For more information on the structure of the join control, see Join Control.
4. Define the join conditions. For more information see Defining Join Conditions.
5. You can get general information such as object version, date created and date changed via Goto ® Global Settings. You can also set the indicator Most recent Reporting for InfoObjects from here. You can find additional information under Most recent Reporting for InfoObjects.
6. Via the button Documents, which appears on the pushbutton bar, you can access document editing for this InfoSet.
7. You can use Check to check the correctness of the InfoSet definition. The log display is shown in the screen area under the join control.
8. Save the InfoSet. The log display is shown in the screen area under the join control.
9. Activate the InfoSet. After activation, the system executes the checks. The result of the activation is displayed in the log in the screen area under the join control.
Additional Functions in the InfoSet Builder
You can also use transaction RSISET to call up the InfoSet Builder when you want to edit an InfoSet. Select the InfoSet that you want to edit. Value help is available for this. Additional functions are also available to help you edit and manage your InfoSet.
Compare
You use this function from the main menu to check if the InfoProviders used in the InfoSet have been changed and the InfoSet needs to be adjusted as a result. For more information, see Matching InfoSets.
Jump to object maintenance
You use the InfoObjects and ODS Objects functions to jump to the maintenance screen for the InfoProviders included in the InfoSet definition.
Info functions
There are various info functions on the status of the InfoSets:
• The Object Catalog Entry
• The log display for the save, activate, and delete runs of the InfoSet.
Display in tree
You use this function to display in a tree structure all the properties of the A version (active) of the selected InfoSet.
• Header data
• InfoProvider and its fields
• On condition
• Wherecondition
The display is empty, if no active version is available.
Version comparison
You use this function to compare the following InfoSet versions:
• The active (A version) and modified (M version) versions of an InfoSet
• The active (A version) and content (D version) versions of an InfoSet
• The modified (M version) and content (D version) versions of an InfoSet
The Display InfoSet screen appears. Depending on which option you choose, the system displays either all of the differences between the two versions of the selected InfoSet or all of the properties of both versions in a tree structure.
Transport connection using AWB
You use this function to transport an InfoSet into another system.
The Administrator Workbench: Transport Connection screen appears.
The system has already collected all the BW objects that are needed to guarantee the consistency of the target system.
InfoSet data display
You use this function to access the data target browser. If you have already loaded data into the InfoProviders included in the InfoSet, you can display this data.
Delete
You use this function to delete an existing InfoSet.
Copy
You use this function to copy an existing InfoSet and, if necessary, edit it further.
Show/hide technical names
You can use this function to show alias names for fields. These alias names are necessary in InfoSets, for example to be able to map self joins. Field alias names start with F, followed by a five-digit number.
Defining Join Conditions
Use
A join condition determines the combination of records from the individual objects that are included in the resulting set.
Before an InfoSet can be activated, the join conditions have to be defined in such a way (as equal join condition) that all the available objects are connected to one another either directly or indirectly.
Usually, however, only rows containing a common InfoObject or rows containing InfoObjects that share the same basic characteristic are connected to one another.
Connect tables T1 and T2 using a join and set as a join condition that the F1 field from T1 must have the same value as F2 from T2. For a record from table T1, the system determines all records from T2 for which F2(T2) = F1(T1) is true. In principle, as many records from T2 can be found as required. If one or more records are found, the corresponding number of records is included in the result set, whereby the fields from T1 contain the values from the record from T1 under consideration, and the fields from T2 contain the values of the records found from T2.
Procedure
There are various ways of defining join conditions:
Using a mouse-click
Position the cursor over a row in an InfoObject. Press the left mouse-button and, keeping the left mouse-button pressed down, trace a line between this row and a row in another object. Providing that the join condition between the two rows that you have indicated is a valid join condition, the system confirms the join condition by displaying a connecting line between the two rows.
Using the Link Maintenance pushbutton
You get to the Link Maintenance dialog box.
In a tree structure on the left-hand side of the screen, all of the InfoProviders that are already included in the join are displayed along with their fields or attributes. If you double-click on one of these fields or attributes, the system displays on the right-hand side of the screen all of the fields or attributes with which you are able to create a join condition.
In the Selection column, set one or more of the indicators for the fields or attributes for which you want to create a join condition. The system generates valid join conditions between the fields or attributes that you specify.
You use the Delete Links pushbutton to undo all of the join conditions.
You use the All Characteristics or the Basic Characteristics Only pushbutton to choose between the corresponding display variants.
We recommend that you use the Basic Characteristics Only option. The All Characteristics setting displays all of the technical options involved in a join. If you are not able to find a join condition on the basic characteristic level, then the All Characteristics setting is useful, but this is an exceptional case.
When you have finished making your settings, click on the Continue icon.
We recommend this method, because the system searches for all the possible join conditions for any field or attribute that the user specifies, ensuring that the join conditions are defined without errors.
Using the Context Menu Left Outer Join – Inner Join
Usually inner-join operators connect all the objects in a join to one another. You can also connect each object with any of the many other objects by using a left outer join operator.
You can find additional information about usage and special features under Left Outer Join.
If you want to use a left-outer join operator to connect an object, select the object and choose the corresponding function from the context menu.
The system displays all of the valid join conditions that originate from this object. The connecting lines that represent these join conditions are labeled as Left Outer Join . InfoProviders, on which a left outer join condition is affixed, are differentiated by color from the InfoProviders that are connected using an inner join operator.
If you used a left outer join operator to connect two objects, you have to make sure that all on conditions are linked except for these two objects with the formulation of join conditions.
Note that you cannot add an object, which you have already connected by using the left outer join operator, to another object.
If you want to use an inner-join operator instead of the left-outer join operator, select the object that you want to connect, and choose the Inner Join option from the context menu. Again the system displays all the valid join conditions that originate from this object, and labels the connecting lines accordingly.
Result
Once the join conditions have been defined in such a way as to connect all the available objects to one another, either directly or indirectly, the InfoSet is ready to be activated.
You click on the Check pushbutton in the pushbutton toolbar to find out if these preconditions for the activation have been met.
For objects that are joined by a left-outer join operator, there is one extra condition that has to be met, namely that all the other objects have to be connected to one another either directly or indirectly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.