Managing ODS Objects 

Use

Choose the Manage function to display technical information on the contents of the ODS object. This gives you information on the requests that are already in the ODS object, and allows you to reconstruct ODS objects.

Prerequisites

The ODS object is active.

Functions

The ODS object is displayed in the top table. If you got to the administration screen from the Scheduler or the Monitor, you only have to make one selection from the several ODS objects on display.

From the top toolbar, choose Contents to display the contents of the table for the active data in the ODS object you have selected. Change Update Rules brings you to the maintenance screen for the update rules. Delete Contents removes the contents of the ODS object. There is also the option of displaying an application log and a process overview.

Tabstrip: Contents

You get a list containing the InfoObjects for the ODS object. Use this to check whether the data that you loaded into the ODS object is free of technical errors. If the table contains more than 40 fields suitable for selection, you have to select the fields first. You are able to change this selection again in the main menu under Settings ® Fields for Selection. Choose Settings ® User Parameters to set-up the table display so that all ODS object columns are shown and nothing is missing.

Choose Logs to view the logs for requests that have been deleted, activated, reconstructed, or added.

Choose New Data to view the contents of the table containing the recently loaded data (M table). If this new data is activated, the system deletes the table, and moves the data to the table containing activated data.

Choose Active Data to view the contents of the table containing active data (A table).

Choose Change Log to display the change log table. This table contains the change log requests that are created every time you activate data.

Tabstrip: Requests

This tabstrip gives you information on all the requests that have been run in the ODS object. You can also delete requests here if you need to.

It is only possible to delete requests that have not yet been activated.

The traffic light status "red" means that there are problems uploading data, and that these problems are preventing a secure upload. These problems might be caused, for example, by errors in the definition of the transfer structure. Use the pushbutton in the Display Request column to jump to the Monitor, and locate the error.

Data packets with traffic light status "red" or "yellow" cannot be taken into consideration when executing a BEx query. In this case, subsequent data packets with the traffic light status "green" are also not used in the query, because the consistency of the data in a query can no longer be guaranteed.

You reset the original request status in the Monitor by clicking on the request status symbol in the column QM Request Status after Update, and selecting Delete status, return to request status.

If the ODS object is used as a data source in data marts, that is in other BW systems or the Myself system, the data mart status for the ODS object is displayed. Use the corresponding pushbutton to manage the distribution of a request.

You are able to call application logs for the requests in the ODS objects. To call the application logs, select the request you want to analyze from the Requests tabstrip, and choose Environment ® Application Log.

Choose Selection to schedule the update of requests individually or as an event chain in the background. The Subsequent Processing function allows you to specify the events that you want to carry out once the process is complete. Choose Delete to trigger the background job, or to delete it directly.

Tabstrip: Reconstruction

Use this function to fill an ODS object with requests that have already been loaded into a BW system, or into another ODS object.

Choose Selection to restrict the display of the request for an ODS object, an InfoCube, an InfoSource, or a source system. All the requests that have already been loaded for your selection are displayed here. You are able to select individual requests, and use them to reconstruct the ODS object. To do this, choose Reconstruct/Add.

Start loading the ODS object immediately, or schedule the load as a background job / to be triggered by an event.

In Subsequent Processing, specify the events that you want to carry out once the process is complete.

If you select more than one request for reconstruction, you must deactivate the functions for automatic activation and automatic update.

Automatic Further Processing

If you want to use an ODS object as a data source for another ODS object or InfoCube, the data must be of a reliable quality, and be set to active.

If you choose the main menu path Environment ® Automatic Request Processing, the system automatically sets the quality status to OK after the data has been loaded into the ODS object. This option must be switched on. There is also the option of activating and updating ODS data automatically. Data that has been given the quality status OK, is transferred from the New data table into the Active data table, and the change log is updated accordingly. The data is updated in the data targets. If this is the first time the data has been updated, an init. update is carried out automatically.

Locks in the system ensure that the first request has been activated completely before the activation of the next request begins. This is also true for the update process.

These settings are also available when you are creating ODS objects. See Creating ODS Objects.

Activities

Choose Modeling ® Data Targets ® Your ODS object ® Context menu (right mouse-click) ® Manage. This takes you to the ODS object administration screen.