SAC BW Live Connectivity Search is based on the BW BICS Object Service, that provides a fast, lean and simple way to select BW Metadata. Besides a logic of interpreting the search string, the new service is mainly a dispatcher between a couple of "BW Entities" and a HANA-based so called "TRex Search for BW Repository Objects". This fast search (aka "BW Search", transaction "RSOSM") is also used e.g. in the BW Modeling Tools and is now available in ABAP BICS. However the "BW Search" framework cannot handle Transient CDS Queries and InfoProviders, therefore an additional interface is being developed. Introduction
As a matter of fact to be able to search for BW Queries as a base Object for SAC Models, "BW Search" is needed to be activated as it is described in NOTE 2243132-No queries are found using the INA catalog service.
To be able to search CDS Queries and InfoProviders, The following NOTE is needed to be implemented 2839014-BW HANA based Fast Search
|AO and SAC BW Object Types||Available TLOGO objects for "BW Search"|
The INA HTTP calls related to the search functionality trigger the SICF service /sap/bw/ina/GetCatalog, so this service is also needed to be active.
The DataSource in this case a technical object "$$DataSource$$" (Cube.DataSource.ObjectName.$$DataSource$$) with type "CatalogView2" (Cube.DataSource.Type.CatalogView2). There is a list of technical dimensions (Cube.Dimensions.Name.["SchemaName", "ObjectName", "BaseDataSource", "Type", "InfoArea", "QueryAlias"]) returned for the Metadata Response that are partially always, partially optionally filled by the Search Result Set response later on.
The list of technical dimensions that are returned by the metadata response, is now requested to be filled in the result set request (Analytics.Definition.Dimensions.Name.["SchemaName", "ObjectName", "BaseDataSource", "Type"]). If we filtered a search in SAC, it is also presented in the Request (Analytics.Definition.Filter). The search, as well as the Filtering always happen on Internal Key (.KEY) and Long Text (.LONG_TEXT).
In the ResultSet Response, the technical dimensions are actually being filled strictly, or optionally (Grids.Axes.Dimensions.Name.["SchemaName", "ObjectName", "BaseDataSource", "Type"]). Type is Query, while the ObjectName holds the list of Queries in the search result and BaseDataSource holds the underlying InfoProviders.
Transaction RSOSM shall be used to maintain the whole BW Search on SAP HANA framework. Here you are able to (de-)activate BW Search, maintain available TLOGO objects, maintain required SAP HANA artifacts like Attribute Views and use the different search types.
The meta data shall be retrieved directly from the specific TLOGO tables. Hence, the information per TLOGO object about required database tables, their relationship, main table, required database columns for search and for output of search results need to be maintained by each TLOGO object owner. Therefore a framework is needed which enables the TLOGO object owner to provide the BW Search framework with all the required information to generate a proper Attribute View, which can later be used during BW Search. The header meta data as well as the body meta data shall be combined into one great Attribute View per TLOGO object.
The meta data of a TLOGO object can be searched in via a set of generated Attribute Views in SAP HANA. The views are generated based on the provided information in transaction RSOSM. The views by default are put into subpackages of package system-local.bw.bwsearch. For each TLOGO object there's an own package, i.e. system-local.bw.bwsearch.ELEM with two subpackages METADATA and WHEREUSED. Package METADATA contains all views required to run a meta data search, the package WHEREUSED contains all views required to do a Where-Used search.
Each metadata package contains at least a view called PRIMARY which contains the primary table of the TLOGO object plus the TADIR table optionally, based on whether the TLOGO object retrieves its owner and creation date from the TADIR table. In addition the meta data package contains all views required to display the usage of other objects as maintained in transaction RSOSM.
When doing a Where-Used or Meta Data search, a SQL statement is generated which contains all views and i.e. joins the primary and Usage views based on the user's input.
The search for a base Query of a Model in SAC with BW Live Connectivity is expected to deliver the same result as the Test Framework for "BW Search ". It can be called with program RSOSN_SEARCH. The result in SAC is filtered for Repository types (REP) and for TLOGO object ELEM, while only Queries in A version shown.
|Search result in SAC Modeler||Search Result in RSOSN_SEARCH|
To sum it up, in order to be able to search for BW Queries in SAC with BW Live Connectivity, it is needed to have BW search Active and TLOGO ELEM (Query Element) is needed to be configured and set.
Transient Object search
As "BW Search" does not support transient objects, a new service is used to extend the existing functionality. CDS View RSRTS_QF4_QueryProvider provides a list with all queries and there potential providers. One query might have multiple entries (dimensions used in associations are also included!) RSRTS_QF4_QueryProvider contains only released queries and is filtered by authorization. The View is also deployed by NOTE 2839014-BW HANA based Fast Search. Therefore it is also needed to make sure that the object is released as it is described in the following wiki page.
|RSRTS_QF4_QueryProvider Data Preview|
It is very important to follow Note 2541557-SAP Analytics Cloud with BW live connection below NW BW 7.50 SP16, BW/4 2.0 SP4 or S/4 1909 and run the attached report to implement the notes in the sequence from top to down. It is needed to make sure that all the NOTES are implemented and also the manual implementation steps are performed. This is the safest way to implement also the NOTEs stated below.
- 2841867 - Unable to access Change API State Functionality
- 2243132-No queries are found using the INA catalog service
- 2839014-BW HANA based Fast Search
- 2563362-BICS Catalogue Service: Fast Search DefaultQueries
- 2873531-Old Search Converst to Upper Case
- 2406423-Query Catalog Improvements
- 2769631-BW Faster Catalog Services