ODS Views allow to consume external data sources in BW without staging, combine data sources with BW models and physically integrate (load) external data sources by creating DataSources.
Open ODS view allows data sources to be virtually consumed without the need for a separate BW persistence for the data. These data models can be located in a database schema (of the SAP HANA database in BW), which is not managed by BW. Alternatively, the models can be located in other databases, which can be connected to the SAP HANA database in BW using SAP HANA Smart Data Access.
Benefits of Open ODS View:
Creation of Open ODS View:
Open ODS views enable you to define BW data models for objects like database tables, database views or BW DataSources (for direct access). These data models allow flexible integration without the need to create InfoObjects.
Go to SAP HANA studio → BW Modeling Tools.
To create an Open ODS, right-click on your InfoArea and choose Open ODS view.
Provide the following details such as technical name of the DataSource, Descripation and select Semantics and Source type and click on finish.
Now click on the Facts and look into the details of the source.
Next is to check and activate BW object.
You can also analyze the result in the Problems log of this perspective.