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
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.


