Help for SAP Data Hub Cockpit

Search Metadata

Search metadata to find fact tables and dimension tables that contain the search term and metapedia terms.

Context

When you want to look for a table or dimension, or even a column or file name, you can search for it in the Metadata Catalog.

Procedure

  1. Click Metadata Catalog icon Start of the navigation pathMetadata Catalog Next navigation step Metadata SearchEnd of the navigation path.
  2. Enter a search term, and then press Enter.
    Any table or dimension that includes those characters are returned in the list. Click Load More Search Results when there is a long list of results.

Example

You can refine your searches by adding certain modifiers.
  • To search for metapedia terms, preface the terms with Thesauri.metapedia. For example, Thesauri.metapedia: "cost analytics".
  • To search for an entire string in the specified order, surround the text with double quotes. For example, "cost analytics". If you were to enter these two words without the quotes, the results include objects that contain one or both of the words.
  • To search on a single connection, preface the terms with connection:<connection_name>. For example, connection:HanaConnection1 "cost analysis".
  • To use wildcard searches, enter the wildcard with the search terms. For example, admin* returns entries with "administrator" or "administration", whereas "customer * address" returns entries with "customer shipping address" or "customer billing address".
  • To ensure that one word in a phrase is returned, use the + character. For example, +customer shipping address returns only objects that have "customer" in the results.
  • To ensure that one word in a phrase is excluded, use the - character. For example, -customer shipping address returns only objects that do not have "customer" in the results.