Show TOC

Creating an Open ODS View Using the Wizard (Defining Semantics and Source)Locate this document in the navigation structure

There is a wizard to guide you through the process of creating an open ODS view. In the wizard, you make general entries for the technical name and description, InfoArea and favorites assignments, and specify whether a proposal should be made for the assignment of the fields in the source object to field categories of the Open ODS view when this is created. During the creation process in the wizard, you select the semantics and the source of the Open ODS view. You also have the option of creating an Open ODS view as a copy of an existing Open ODS view.

Prerequisites

  • For transformations as sources of Open ODS views:

    You can use a transformation as the source for the Open ODS view provided that you have created the corresponding data flow:

  • For DataStore objects (advanced) as sources of Open ODS views:

    DataStore objects for which all reporting takes place on the active table are supported.

Procedure

In the Project Explorer view, you have chosen Start of the navigation path New Next navigation step Open ODS View End of the navigation path in the context menu of your BW project or the context menu of an InfoArea or the semantic folder You are in the wizard for creating the Open ODS view in the first wizard step Open ODS View.

  1. Select an InfoArea.
    The InfoArea that you selected the last time you opened the dialog box is displayed as the default entry.
    Tip You can access the content assist function by pressing Ctrl + Space.
  2. To access the Open ODS faster next time you are here, we recommend setting the Add to Favorites flag.
  3. Enter a technical name for the Open ODS view under Name. A maximum of 12 characters can be entered for the name.
  4. Enter a description for the Open ODS view under Description.
  5. The Create with proposal flag is selected by default. This means that the Open ODS view is created with automatic assignment of the source fields to the field categories of the Open ODS view (characteristic or key figure for example). If you deselect this, the system does not generate a proposal during the creation process. In this case, you set the assignment in the editor of the Open ODS view.
  6. Under Semantics, specify whether you want to create an Open ODS view for facts, master data or texts.
  7. Under Source Type, select which type of source object should be used as the basis for the Open ODS view.
  8. For the source types Database Table or View and Virtual table using SAP HANA Smart Data Access, specify whether an existing SAP HANA or DB connect source system, or a new SAP HANA source system, should be used to access the source object of the Open ODS view.
  9. Choose Next.

    The following wizard steps depend on which source type you have selected and - for the source types Database Table or View and Virtual table using SAP HANA Smart Data Access - whether you use an existing source system or create a new one.

    More information:

Results

Once you have completed all wizard steps, the Open ODS View editor opens.