Show TOC

Specifying the Structure of the Open ODS ViewLocate this document in the navigation structure

In the Open ODS view editor, you can specify the structure of the Open ODS view on the semantics tab, by assigning the fields of the source object to field categories (example: for facts, assign to the categories characteristic key, characteristic, key figure and others).

Procedure

  1. Go to the Semantics tab.
    In the middle screen area, you see the automatic assignment of source fields to field categories of the Open ODS view. A proposal is generated based on the source type.
  2. Change the system proposal as required. Various options are available here.
    Option Description
    Drag and Drop You can drag source fields into the field categories of the Open ODS view or move Open ODS view fields from one field category to another.
    Add in the context menu of a source field In the Add Source Fields dialog box , choose Field Type and select the category that you want the field to be assigned to. Confirm your selection by pressing OK.
    Move in the context menu of an Open ODS view field. In the Move Fields dialog box, choose Field Type and select the category that you want to assign the field to. Confirm your selection by pressing OK.
    Remove in the context menu of an Open ODS view field. The field is removed from the structure of the Open ODS view and is colored gray in the list of source fields, if it is not assigned to any field categories.
    Note
    • Unassigned source fields are colored gray (in the left screen area of the tab).
    • You can move a source field multiple times in the structure of the Open ODS view, in order to assign it to different field categories. Source fields assigned multiple times are colored blue (in the left screen area of the tab).
    • If multiple key fields exist for attributes or texts, drag the key field that defines or represents the Open ODS view to field category Representative Key Field.

Results

In the middle screen area of the tab, you see the structure of the Open ODS view.

The names of the Open ODS view fields are copied from the source fields. The names of the view fields are limited to 12 characters. The description of the view fields is copied from the description of the source fields. If the source does not have a description, the field names are used for the description of the view fields.

You can now display the properties of the Open ODS view fields and change the predefined properties.