BW Search on the SAP HANA Database (New)

If you use the SAP HANA database to persist data from your BW system, you can use the new BW search. For the 20 most important TLOGO objects, this allows you to perform a search in the metadata of the objects and a search for connections between these objects in the where-used list.

Search in the Metadata

In BW search (transaction RSOS_SEARCH), you can either search for the metadata of a particular object or view the metadata of all objects in your system. Under Advanced Options, you can further define which metadata of the TLOGO object to search through (technical name, description, used objects). Under Technical Settings, you can restrict the result set, select a search method of your choosing, and define an activity for how the object should be treated.

Search in the Where-Used List

Every TLOGO object contains information about which other TLOGO object it uses. In BW search (transaction RSOS_SEARCH), you can search for the corresponding TLOGO object and/or the dependent TLOGO object. You can also further define the search and the results for this search under Avanced Options.

Overview of Supported TLOGO Objects

  • ADSO - (Advanced) DataStore object
  • AINX - Analytic index
  • ALVL - Aggregation level
  • AREA - InfoArea
  • COPR - Local CompositeProvider
  • CUBE - InfoCube
  • DEST - Open hub destination
  • ELEM - Query
  • FBPA - Open ODS view
  • HAAP - SAP HANA analysis process
  • HCPR - CompositeProvider
  • HYBR - HybridProvider
  • IOBJ - InfoObject
  • ISET - InfoSet
  • UPOA - Semantically partitioned object
  • MPRO - MultiProvider
  • ODSO - DataStore object
  • TRCS - InfoSource
  • TRFN - Transformation
  • UPDR

Objects Created in the SAP HANA Database

The metadata of a TLOGO object is searched for via attribute views in the SAP HANA database. The system generates these attribute views in accordance with the settings in BW search maintenance (transaction RSOSM). In the standard setting, the views are stored in object-specific sub-packages of package system-local.bw.bwsearch.

Each of these sub-packages contains the sub-packages METADATA, containing all views required for a metadata search, and WHEREUSED, containing all views required for a search in the where-used list.

BW Search Administration

In BW search maintenance (transaction RSOSM), you can make the following settings:

  • You can activate or deactivate BW search, and change expert settings (the package to use and the timing of the buffer check for example).
  • You can edit the TLOGO objects in terms of their metadata and the associated SAP HANA views. You can thus cause the current attribute views in the SAP HANA database to be made available or deleted.
  • You can edit association types.