RSOSN_SEARCH: Metadata Search

Search Query

Depending on the selected search method (see section Wildcards & Special Characters), the behavior of the BW Search on SAP HANA framework and the retrieved results can differ for the same search query.

Advanced Options

• Hide Advanced Options After Search:
  • The Advanced Options box is hidden when the search results are displayed.
• TLOGO Object
  • Search in Technical Name:
    • The system searches the technical name fields of all available TLOGO objects for the entered search query.
  • Search in Description:
    • The system searches the descriptions of all available TLOGO objects for the entered search query.
  • Search in Used Objects:
    • The system searches all objects used by a TLOGO object for the entered search query. For example, all InfoObjects contained in a specific InfoCube are searched as well as the InfoCube itself.
  • Search in TLOGO Objects:
    • If this field is empty, the system searches all TLOGO objects configured and activated for BW Search on SAP HANA for the entered search query. If TLOGO objects are specified here, these objects are searched for the specified search query.
  • Search in Object Attributes:
    • Besides the attributes Technical Name and Description, you can also select TLOGO-object-specific attributes to be included in the search for the entered search query. The list of available object attributes depends on which TLOGO objects are specified for the search.
  • Object Version:
    • Restrict BW Search on SAP HANA to objects with a specific version.
  • Object Status:
    • Restrict BW Search on SAP HANA to objects with a specific status.
  • Association Type:
    • Certain TLOGO objects (all TLOGO objects which support the XREF setting), for example TLOGO HCPR or TLOGO COPR, use a generic cross reference framework to store the usage of other objects. This generic cross reference framework supports different types of associations: Objects Dependent, Objects Used, Receive Data From, Send Data To and Other. By Default the association type Objects Dependent is used.

Technical Settings

• Display Results From i to n:
  • Only show results which are within the specified limits (based on their sort order). If no limits are specified, all results are shown.
• Search Method:
  • Specify how the TLOGO objects are searched for the entered search query. See the section Wildcards & Special Characters below for more information on how to use wildcards and other search-method-specific options.
• Activity:
  • Specify the activity used for the authorization check – for each entry in the retrieved result set.
• Show SQL Statement:
  • Show the generated SQL statement before running the search query.
• Show Message Log:
  • Always show the message log, even if no warnings or errors occur during the search query.
• Regenerate Views on Errors:
  • If errors occur while retrieving the result set, do not terminate the process immediately. Instead, let the framework try to regenerate all required views in SAP HANA first, in order to run the entered search query a second time. If the results still cannot be retrieved after all required views have been regenerated, the process is terminated.
• Bypass Buffer:
  • If option is selected, the framework buffer is not used. The application stores data (such as generated SQL strings, processed and adjusted user input, and information about the required SAP HANA views) in the application buffer, in order to speed up search performance. Not using the framework buffer may lead to lower search performance.

Wildcards & Special Characters

Depending on the selected search method, the behavior of the BW Search on SAP HANA framework and the retrieved results can differ for the same search query. Wildcards (%, *, ?, _) can be used for all three search methods: Fuzzy Search, Exact Search and Pattern Search.

When using Fuzzy or Exact Search, you can also use certain special characters:

• OR:
  • A search such as sap OR hana searches for all records that contain sap or hana in the selected attributes. The OR keyword is case-sensitive, so sap or hana searches for records that contain sap and or and hana. NOTE: If your search input contains an or, make sure that it is not in uppercase characters, in order to avoid the OR semantics.
• Minus Sign (-):
  • A search such as sap -hana searches for all records that contain sap but not hana. If the seconds term is given as a phrase, as in sap “-hana”, the database searches for records that contain sap and -hana. In text columns, the – is removed from the second search term, since it is a delimiter symbol. NOTE: If your search input contains terms starting with a minus sign, make sure that these terms are enclosed in double quotes in order to avoid the NOT semantics.
• Double Quotes (“):
  • A search that is enclosed in double qoutes is searched for as a phrase. For example, “sap hana” searches for all records that contain sap hana as a phrase without any additional terms in between.
• Asterisk ():
  • The asterisk activates a wildcard search. In this case, no fuzzy search is performed. An exact search with wildcards is performed instead.
• Percent Sign (%):
  • The percentage sign is replaced with an asterisk (), and a wildcard search is performed.