Creating an ODS Object

First, let's create an ODS object.

Work Instructions

Step 1. Right-click InfoArea – demo, and then select Create ODS object….

SCREEN 9.1

Step 2. Enter a name and a description, and then click to create the named ODS object.

SCREEN 9.2

Step 3. Select the BEx Reporting option, allowing us to create queries on the ODS object from BEx Analyzer.

Note

We leave other options open so we have opportunities later to manually complete these tasks. It helps us to understand the data load process.

Next, click to get the necessary InfoObjects.

SCREEN 9.3

Step 4. Select IOC_DEMO_CH, which was created in Section 2.2. Click to continue.

SCREEN 9.4

Step 5. Drag IO_ORD (Order number), IO_CUST (Customer ID), IO_SREG (Sales region), IO_SOFF (Sales office), IO_SREPN2 (Sales representative ID new 2), and IO_MAT (Material number) from the left panel into the right panel and place them under the Key fields folder. Here IO_ORD is a newly created characteristic for sales orders.

SCREEN 9.5

Step 6. Repeat Steps 35 to add IO_QUAN and IO_PRC to the ODS object. Be sure to add them to the Data fields folder.

SCREEN 9.6

Step 7. Repeat Steps 35 to add 0CALDAY (Calendar day) to the ODS object. Be sure to add it to the Key fields folder.

SCREEN 9.7

Step 8. Click. A new InfoObject, 0RECORDMODE, is added. In Section 9.5, we will learn how to use it in delta data loads.

Click to activate the ODS object.

SCREEN 9.8

Result

You have created an ODS object that includes a new InfoObject, IO_ORD, for sales orders.