Creating an Open ODS View (field based modeling), for source of type “database table or view”:
There are two ways of creating an Open ODS view in the Data Warehousing Workbench in the BW system and you also have the option of creating Open ODS views in the BW Modeling tools in Eclipse.
Create in the InfoProvider Tree:
In the InfoProvider tree in the Data Warehousing Workbench, select the InfoArea that you want to assign the new Open ODS view to and choose Create Open ODS View in the InfoArea’s context menu. The dialog box for creating Open ODS views appears.
Under View Name, enter a technical name for the Open ODS view.
Enter a description for the Open ODS view under Long Description.
Select the semantics (facts, master data, and texts).
Select the type (DataSource (BW), database table or view, Virtual Table Using HANA Smart Data Access).
For sources of type database table or view:
- a. Under DB Object Schema, select the
schema where the table or view is located, which you want to use as the source object for the Open ODS view. You can choose from the schemas of the SAP HANA database, which the BW system runs on.
- b. A DB Connect source system is used to access the data in the source. The schema is specified in the configuration of the DB Connect source system. If a source system has already been defined for the DB object schema, this system is displayed in the Source System field. If there is no source system for the schema, it is created when the Open ODS view is created. In this case, the source system field displays a suggested name that you can overwrite. The proposal is derived from the schema name.
- c. In the DB Object Name field, select a table or view as the source object of the Open ODS view.
In the Open ODS view maintenance screen, you can generate 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).
To perform an automatic assignment of source fields to field categories of the Open ODS view, select the Create Proposal button. The system generates the proposal based on the source type. Alternatively, you can drag source fields into the field categories of the Open ODS view.
General Field Properties:
Field Name, Source Field, Long Description and Global Name.
The global field name is the name used as the InfoObject name in the InfoProvider of the Open ODS view. The global name is initially determined from the ODP name and the name of the Open ODS view field.
Properties for Fields of Type “Characteristic” :
Authorization Relevance, Display, Query Exec-Filter Val and 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 global 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.
Properties for Fields of Type “Key Figure”:
Aggregation, Currency/Unit, Reporting Properties.
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.
Open ODS view can be used in EDW modeling. Click on generate dataflow icon, it will create standard DSO, transformations and DTP.