Creation of ODS view and uses SAP BW on HANA tool Eclipse

OPEN ODS VIEW

Open ODS views enable you to define BW data models for objects like database tables, views or BW DataSources (for direct access) without the need to create InfoObjects. Open ODS views can be created in transaction RSA1 and in the BW Modeling Tools of the HANA Studio. The Open ODS view is a view on the source object, it does not contain any data persistence. The required data is then retrieved during query runtime.

Types and Settings

Semantics
  • Facts
  • Master Data
  • Texts
Source Type
  • BW DataSource for direct access
    • ODP context: ABAP Core Data Service
  • DataStore Object (Advanced)
  • Database table or view
  • Virtual table using HANA Smart Data Access
  • Transformation

Step 1: Go to Modelling tool Ecllipse

Step 2: Go to your BW project.

Step 3: Go to InfoArea: Right click --> New--> Open ODS View





Step 4:  Enter Technical name and Description , Copy from, Semantics and Source type:

  • Semantics type: 

1. Facts: 
2. Master Data
3. Texts

  • Sources for Open ODS views:


 1. Datasources (BW)—A datasource on a table helps expose an external table in a database to SAP BW’s Open ODS view. Datasources can be created via RSO2. If data needs to be extracted from a table, expose the table via a datasource. Some of the supported source system types are BW, SAP, ODP extraction technique, and DBCONNECT. 

2. Database table or view—Data in tables or views in any schema within SAP HANA can be viewed using this option. 

3. Advanced Data Store Object (ADSO)—Usually aDSOs can be exposed directly to SAP BW queries. The advantage of having an aDSO as a source to Open ODS views is to use a transaction datasource as master data or the other way around. All reporting takes place using the active table of the Advanced DSO.

 4. Transformation—A source table is usually interfaced directly to an Open ODS view, but in some situations, it might be required that some fields undergo some transformations before being exposed to the Open ODS view. In that case, it might be required that the source for an Open ODS view be a transformation attached to the datasource.





Technical Name: Your new technical name
Description : Your description
Semantics: Facts
Source type: Datasource



After click on Finish:





,nvgcgcjg





hvgjfj

Comments

Post a Comment