Open ODS Layer – Immediate Query and Early Integration

For data that has been loaded or replicated to BW in DataStore objects (advanced), BW services can be offered straight away, without the need for any further transformations.

This allows for early integration, together with quick and agile provision of information. This is achieved thanks to the following features:

• The definition of reusable BW semantics on the field-based DataStore objects (advanced) of the Open ODS layer using virtual Open ODS views:
  • The role of the DataStore object (advanced) (facts, master data, texts)
  • The significance of the fields (characteristic, key figure, currency and so on)
  • The definition of associations between Open ODS view (facts and dimensions: star schema, master data and texts)
  • The definition of associations between Open ODS view and InfoObjects (see below)
• The combination of Open ODS views with other InfoProviders from the propagation or Architected Data Mart layer via CompositeProviders
• Immediate querying on the Open ODS layer via Open ODS views and CompositeProviders

These new services in the initial layer of BW are useful primarily for the integration of non-SAP data, as they obviate the need for time-consuming creation of InfoObjects for the fields if all that is required is to execute a query straight on the data for example.

The Open ODS layer also offers other virtual services that go far beyond the classic Data Warehousing services.