BW Metadata Search Without SAP HANA Database

Use

Note that the BW metadata search described below is only applicable if you do not use the SAP HANA database to persist your data in the BW system.

Note On account of performance and the better range of features offered, we recommend performing the BW search on the SAP HANA database.

You can use the TREX search engine to search for BW metadata (such as InfoCubes, InfoObjects, queries or Web templates) in various modes. The simple search is a pure text search; while the advanced search provides a function for searching by attribute and a function for searching according to specific restrictions, as well as a full-text search.

Integration

The BW metadata search is integrated into the functional areas of the Data Warehousing Workbench:

Data Warehousing Workbench

Functional Area	BW Metadata Search
Modeling	Data Warehousing Workbench Search
Administration	Simple and advanced search using BW metadata search/BW document administration (see Tab Page: Metadata Indexing)
Transport Connection	Simple and advanced search by choosing Search in the top toolbar
Documents	Simple and advanced search using BW metadata search/BW document administration (see Tab Page: Metadata Indexing)
Business Content	Simple and advanced search by choosing Search in the top toolbar
Translation	Simple and advanced search by choosing Search in the top toolbar

The BW metadata search is also integrated into some object editors and the BEx open dialog.

Prerequisites

The search engine must be fully installed for you to use the full functions for searching in metadata.

Caution
If the search engine is not fully installed, you can still use the simple search, which the system then performs in the database. The search is then slower and case-sensitive, and does not support a search in the attributes.

Make sure that you have performed the following steps:
- Install the TREX search engine
- Createan RFC destination in the BW system for the TREX search engine
- Enter the RFC destination in table RSODADMIN_INT
For more information, see SAP Reference IMG SAP Customizing Implementation Guide SAP NetWeaver Business Warehouse Connectivity of TREX .
The metadata has to be indexed.
1. The object types relevant for the BW metadata search have to be specified and the metadata has to be indexed initially.
2. You have to schedule the (delta) indexing of metadata as a regular job (transaction RSODADMIN).
You make the required settings under Administration in the Data Warehousing Workbench. For more information about managing the BW metadata search, see Tab Page: Metadata Indexing..

Features

The system provides the following options as part of the simple and advanced search functions:

Simple Search

With the simple search, the system searches in one or all object types for the text entered in the technical name and description. The search is not case-sensitive It finds objects, even if the capitalization in the text entered is different from the capitalization in the search term.

Advanced Search

With the advanced text search, you can enter more than one search term. You have the following options:

with exact wording
with all search terms
with at least one of the search terms
without search terms

You can choose from the following search options:

Language: You can choose from all installed languages.
Version: In the default setting, the search is performed in the delivered A Version. You also have the option of perfoming the search in the D Version instead.
Search method: The default setting is Normal. You can choose the Fuzzy search instead.

In addition, you can search in the attributes specific to each object type. First select the Object Type. (Input help is provided). The system displays the relevant attributes in the table. Enter the required values.

You can also restrict the search for all object types to last changed by and changed at or to changes made within a specific period of time.

Example

For example, you can search for all queries that were changed in the last month and that contain the term "overview" in the text and the characteristic "customer" in the definition.

Activities

Use one of the methods described in the integration section to navigate to the BW metadata search.
Choose either the simple or advanced search and, as described in the features section, enter the required search terms, attributes, or restrictions.
Choose Start Search.

The system displays a list of the activated and BI Content objects sorted by object type (if you did not restrict them) and object name (technical name).