Displaying Initial Properties for Open ODS View Fields

In the right screen area of the semantics tab in the Open ODS View maintenance screen, 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. By choosing Utilities, you can define how the field in the structure of the Open ODS view can be selected. With the Position by Single Click and Position by Double Click options, you can select the field in the Open ODS view structure by either single or double clicking on the source field or view field. With the Source Field by Double Click option, you can stipulate that a single click will change the view field, but that a double click is required in order to change the source field.

With the Previous value; Next entry and Next value; Previous entry arrow keys, above the field properties, you can switch to the field properties of the previous or following entry in the Open ODS view structure.

General Field Properties

All fields types have the following properties:

Property	Description
Field 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.
Source Field	-
Long Description	The field name 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. The global name is initially taken from the ODP name and the name of the ODS view field and is displayed under Global Name.

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 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.
Characteristic Properties	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.
Reporting Properties	Query Exec-Filter Val.	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 global name, aggregation or reporting properties) from the associated object. Initially there are no associations.
Key Figure Properties	Aggregation	This property specifies which rules are used for key figure aggregation. Initially the field has the aggregation behavior "summation".
Key Figure Properties	Currency/Unit	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.
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.
Reporting Properties	Layout	This property specifies the scaling factor that is used to display key figure values in the query. Initially scaling factor 1 is set.