Creating ODS Objects 

Prerequisites

All the InfoObjects that you want to transfer into the ODS object are active.

Procedure

...

       1.      Select the InfoArea to which the new ODS object is to be assigned, or create a new InfoArea. Choose Modeling ® InfoProvider ® Create InfoArea.

       2.      Choose Create ODS Object in the context menu for the InfoArea.

       3.      Specify 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.

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

On the right side of the screen you define the ODS object. Using the Drag&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 are also able to insert InfoObjects without selecting a template in the left half of the screen. This is useful if you know exactly which InfoObjects you want to include in the ODS object. To do this, choose InfoObjects to Insert in the context menu for the node for key fields or data fields. In the dialog box that appears, you can enter and transfer up to ten InfoObjects directly or you can select them using input help. You can still reassign these by using Drag&Drop.

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

Additional restrictions:

-         You can create a maximum of 16 key fields (if you have more key fields, you can combine fields using a routine for a key field (concatenate).)

-         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

       5.      Using Settings, you can make various settings and define the properties of the ODS object. See Settings for ODS Objects.

       6.      Under Indexes, you can create secondary indexes by using the context menu in order to improve the load and query performance of the ODS object. Primary indexes are created automatically by the system.

If the values in the index fields 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 required key fields into the index folder using Drag&Drop.

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

For more information, see Indexes

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

       8.      Save the ODS object, and activate it. Upon activation, an export DataSource is also created that can be used to further update the ODS object data to further data targets.

Next Step:

Creating Update Rules for Data Targets