BI Metadata Search 

Use

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

Integration

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

Data Warehousing Workbench

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

The BI metadata search is also integrated into some object editors.

Prerequisites

...

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

If the search engine has not been fully installed, the system generates the appropriate message after you enter a search term.

If the search engine is not fully installed, you can still use the simple search, but the system performs the search on the database. This means that the search is slower, the system distinguishes between upper and lower case letters, and a search in the attributes is not supported.

Make sure that you have performed the following steps:

¡        Installed the TREX search engine

¡        Created an RFC destination in the BI system for the TREX search engine

¡        Entered the RFC destination in table RSODADMIN_INT

For more information, see SAP Reference IMG  ® SAP Customizing Implementation Guides ® SAP NetWeaver ® SAP Business Intelligence ® Connection of TREX:

       2.      The metadata has to be indexed.

                            a.      The object types that are relevant for the BI metadata search have to be determined and the metadata has to be indexed initially.

                            b.      You have to schedule (delta) indexing of metadata as a regular job (transaction RSODADMIN).

You make the required settings in the Administrationfunctional area of the Data Warehousing Workbench. For more information about managing the BI metadata search, see Tab Page: Indexing Metadata.

Features

With the simple and advanced search, the system provides the following options:

Simple Search

With the simple search, the system searches for one or all object types in the technical name and description of the text you have entered. The system does not differentiate between lower case and upper case letters; it will find the object, even if the capitalization in the text 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: By default, the search is performed in the delivered A Version. You can choose to search in the D Version instead.

·        Search method: By default, the Normal setting is applied. You can choose the inexact Fuzzy search instead.

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

Furthermore, you can limit the search for all object types to the attributes last changed by and changed at or to changes made within a specific period of time.

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

Activities

...

       1.      Choose one of the methods described in the integration section and navigate to the BI metadata search.

       2.      Choose either the simple or advanced search and, as described in the features section, enter the required search terms, attributes and restrictions.

       3.      Choose Start Search.

You get a list of the activated and Business Content objects, sorted by object type (as long as you have not restricted object types) and object name (technical name).