Show TOC

Displaying Initial Properties for Open ODS View FieldsLocate this document in the navigation structure

In the right screen area of the semantics tab in the Open ODS View Editor, you can view and modify the properties of the Open ODS view fields. A field can have different properties, depending on the field type. The field properties are initially inherited from the source of the Open ODS view (whenever possible). A default is used for any properties that cannot be identified in the source.

The right screen area of the semantics tab shows the properties of the Open ODS view field, which is selected in the structure of the Open ODS view in the middle screen area.

General Field Properties

All types of fields have the following properties, which are displayed under General:

Property Description
Name

The field name is read from the source field. Lowercase letters in the source field are converted to uppercase letters, and the name length is limited to 12 letters.

Description

The description is read from the source field. If the source field does not have a description, the name of the source field is used as the description of the Open ODS view field.

InfoObject Name

A further property of an Open ODS view field is the InfoObject name. This is the name for the Open ODS view field used across the system, for example in the InfoProvider display of the Open ODS view or in a query on the Open ODS view. It is determined initially from the ODP name and the name of the Open ODS view field and is displayed in Association, under Usage of System-Wide Unique Name.

Further Properties for Fields of Type Characteristic

Fields of type "characteristic" have the following additional properties:

Property Description
Association

Using associations on fields of type "characteristic", you can link an Open ODS view to master data and texts of other Open ODS views or InfoObjects. This makes it possible to inherit properties - such as the InfoObject name, the authorization relevance or reporting properties of the associated object - and use texts and navigation attributes of the associated objects in the InfoProvider of the Open ODS view. Initially there are no associations.

Characteristic-Specific Properties Authorization Relevance

This property specifies whether analysis authorizations are checked at query runtime and which authorizations are checked (if the field is authorization-relevant). Initially the Open ODS view field is not authorization-relevant.

Referential integrity (I confirm the Referential Integrity)

This property is relevant only if the field of the Open ODS view has an association to an InfoObject. In this case, it defines how the data is handled at query runtime with respect to the referential integrity. In the initial setting, this flag is not selected.

Reporting Properties Display

This property specifies whether individual characteristic values in the query are displayed and how they are displayed. Initially the characteristic values are displayed with their keys.

Query Execution Filter

This property specifies how filter values are selected for query execution: Initially only posted values are displayed.

Properties for Fields of Type "Key Figure"

The fields of type key figure have the following properties:

Property Description
Association

Using associations on fields of type "key figure", you can link an Open ODS view with InfoObjects. This allows you for example to use formulas and variables (defined on the associated InfoObject) in queries on the Open ODS view and inherit properties (such as the InfoObject name, aggregation or reporting properties) from the associated InfoObject. Initially there are no associations.

Key Figure-Specific Properties Currency / Unit Element

This property specifies which field in the Open ODS view is used as the currency field or unit field for the key figure. Initially a unit field or currency field is not assigned.

Aggregation Behavior

This property specifies which rules are used for key figure aggregation. Initially the field has the aggregation behavior "summation".

Reporting Properties Decimal Places

This property specifies how many decimal places are used for the field in the query. Initially two decimal places are set.

Digits to Display

This property specifies the scaling factor that is used to display key figure values in the query. Initially scaling factor 1 is set.