Creating ODS Objects (SAP Library - Administrator Workbench)

Creating ODS Objects

Prerequisites

Make sure that all the InfoObjects that you want to transfer into the ODS object are active. Create any required InfoObjects that do not exist already and activate them.

As an alternative to creating a new ODS object, it is also possible to transfer an ODS object from SAP delivered Business Content.

Procedure

Select the InfoArea that you want to assign the ODS object to, or create a new InfoArea. Choose Modeling ® Info Provider ® Create InfoArea.

From the context menu for the InfoArea, choose Create ODS Object.

Give a name and a description for the ODS object, and choose Create.

If you want to create a copy of an existing ODS object, specify the ODS object that you want to use as a template.

You get to the ODS object maintenance screen.

Transferring InfoObjects:

On the left side of the screen, there are various templates to choose from, which allow you to get a better overview in relation to a particular task. For performance reasons, the default setting here is an empty template. Using the pushbuttons, select an InfoSource (only the InfoObjects for the communication structure of the InfoSource are displayed), an InfoCube, an ODS object, or an InfoObject catalog.

Define the ODS object in the right half of the screen. Using the drag and drop function, assign the InfoObjects in the key fields and in the data fields. It is possible to select several InfoObjects at once. The system assigns navigation attributes automatically. These navigation attributes can be switched on for reporting in BEx.

Or:

You can also insert InfoObjects without selecting a template in the left half of the screen. This enables you to know exactly which InfoObjects you want to include in the ODS object. For this you simply choose the nodes for key fields or data fields Add InfoObjects by using the context menu. In the dialog box that subsequently appears, you can directly enter the InfoObjects (up to ten) and transfer, or select by using input help. You can still reassign these by using Drag&Drop.

Note

There has to be at least one key field and one data field. Additional restrictions:

You can create a maximum of 16 key fields
You can create a maximum of 749 fields
You can use 1962 bytes (minus 44 bytes for the change log)
You cannot include key figures as key fields

Under Settings, you can:

make the ODS object available for use in BEx reporting. It is possible to use an ODS object in a BEx query only if you have set this option.

select the ODS object type. You can choose between standard and transactional, whereby standard is pre-installed and transactional is only meant for special cases. See also Transactional ODS Objects. You can switch the type as long as there is still no data in the ODS object.

set the key figure Unique Data Records. You use this indicator to determine whether the system is ONLY to update unique data records into the ODS object. This means that you cannot load a data record into the ODS object, whose key combination already exists in the system. Only use this setting when you are sure that only unique data records are to be loaded into the ODS object (for example, single documents). A typical application of this is in the loading of mass data. It improves the load performance.

Note

You can also deselect this indicator again (even if data has already been loaded into the ODS object). This can be necessary if you want to re-post deleted data records using a repair request (see: Tab Page: Update). In this case, you need to deselect the Unique Data Records indicator before posting the repair request, following which you can then reset the Unique Data Records indicator once more. The regeneration of metadata of the Export DataSource, which takes place when the ODS object is reactivated, has no effect on the existing data mart delta method.

look at the name of the InfoObject for which the ODS object is the check table, if necessary. This can be specified when creating an InfoObject. See also InfoObject Maintenance.

determine that the system automatically sets the quality status to OK after loading data into the ODS object. As a rule, this function must be selected. Only deselect this indicator if you want to check the data after it has been loaded.

activate the ODS data automatically. Data that has been given the quality status OK is transferred from the Activation Queue into the Active data table, and the change log is updated accordingly. Activation is carried out by a new job that is started after loading into an ODS object is complete. If the activation process terminates, there can be no automatic update.

update the ODS data automatically. Once it has been activated, the data is updated in the data targets. An init. update is carried out automatically with the first update. If the activation process terminates, there can be no automatic update. The update is carried out by a new job that is started once activation is complete.

Note

Only activate automatic activation and updating if you can ensure that these processes do not overlap. Here, we recommend using process chains.

You can create secondary indexes by using the context menu under Indexes in order to improve the loading and query performance of the ODS object. Primary indexes are created automatically by the system.

If the values in the index uniquely identify each record in the table, select Unique Index from the dialog box. The description of the indexes is specified by the system. To create a folder for the indexes, choose Continue from the dialog box. Now you can transfer the key fields that you want into the index folder by using Drag & Drop.

You can create a maximum of 16 secondary indexes. These are also automatically transported.

For more information, see Indexes

Additional functions:

Using the InfoObject context menu, it is possible to set ODS object-specific properties for BEx reporting, such a text display and decimal points.

Use Check to make sure that the ODS object is consistent.

In the main menu, using the DB Storage Parameters function, you can change the database settings. See DB Storage Parameters.

Save the ODS object, and activate it. Upon activation, an export InfoSource is also created, which can be used to further update the ODS object data.

Next Step:

Creating Update Rules