SAP BW Metadata Search Page
Use this page to perform
these tasks.
-
Find the search results that contain a specified search string. You can use the find-text features to locate the search results that contain a specified text string.
-
Review the results of your search for a given text string. The SAP BW Metadata Search page displays the results that match the search criteria that you specified in the Search Metadata for String dialog box. The search results are grouped according to the search options that you specified.
-
Modify or refine your metadata search. You can either revise your metadata search criteria or refine your search by searching within the returned search results.
-
Display the metadata and data contents of a selected table. You can select a table that is listed in the search results and view both the metadata for that table and the data in that table.
-
select the ODS Objects or InfoCubes that you want to identify as data sources. You can select objects that you want to identify as data sources in SAS Data Integration Studio. Metadata for the selected objects is written to the metadata repository and to the data stores that correlate to the tables in the data warehouse.
The page contains these
items.
text string box
lets you specify a
text string that you want to search for. After you enter the text
string, click the Find Text button to search
all returned search results to locate the results that contain the
specified text string.
Search Results list
displays a tree view
of the results of your search and lets you select the tables that
you want to specify as data sources. Results are grouped according
to the search criteria that you specified in the Search Metadata for String dialog
box. You can expand and collapse the folders in the Source Node tree
view to view your search results. Here are the search results groups.
InfoCubes
displays all InfoCubes
that met the search criteria that you specified. The search results
for InfoCubes display when you select the InfoCubes check
box in the Search Metadata for String dialog
box.
ODS Objects
displays all ODS Objects
that met the search criteria that you specified. The search results
for ODS Objects are displayed when you select the ODS
Objects check box in the Search Metadata
for String dialog box.
InfoObjects
displays all InfoObjects
that met the search criteria that you specified. The search results
are grouped by InfoObjects when you select the InfoObjects check
box in the Search Metadata for String dialog
box. You can expand and collapse the InfoObjects in the tree view
as needed to locate the desired InfoCubes and ODS tables that use
those InfoObjects.
To select an InfoCube
or ODS Object, highlight the object that you want from the Search
Results list and click 
to move it to the Selected Sources list.
You can also move the object to the Selected Sources list
by double-clicking it.
to move it to the Selected Sources list.
You can also move the object to the Selected Sources list
by double-clicking it.
Selected Sources tree
lists all tables that
you have selected from the Search Results group
box. To remove an ODS Object or InfoCube from the Selected
Sources list, highlight the object that you want from
the Selected Sources list and click 
. You can also double-click an InfoCube or ODS Object
to remove it from the list.
. You can also double-click an InfoCube or ODS Object
to remove it from the list.
The page contains these
buttons.
Find text
searches all returned
search results to locate the results that contain the text string
that you entered in the Text String box.
Expand
lets you expand all
subnodes within a selected node in the Search Results group
box or Selected Sources list.
SAP Metadata Search
displays the Metadata for String dialog
box. You can search the pre-extracted SAP BW metadata for a given
text string. You can also limit the search to tables, entities, data
models, and other filtering choices. You can use this button to perform
multiple searches without removing any tables from the Selected
Sources list.
Refine Search
displays the Search Metadata for String dialog
box so that you can refine your search by searching within the already
returned search results.
Delete Node
lets you delete the
selected node from the list of search results.
Display data model
displays the ODS/InfoCube - Data Model dialog
box. You can use this feature to view the dimensions and analysis
variables that comprise the selected ODS or InfoCube object and also
detailed information about the dimensions.
Display tables
displays the Tables for InfoCube dialog
box. You can use this feature to view all tables that are associated
with the InfoCube that you selected.
Display info objects
displays the ODS/InfoCube - InfoObjects dialog
box. You can use this feature to view all InfoObjects for the selected
ODS or InfoCube object and also metadata about those InfoObjects.
Display table metadata
displays the Displaying Metadata for SAP Table dialog
box. You can use this feature to view such metadata as the field name,
field text, and field format for a selected table.
Display table contents
displays the Selected SAP Table dialog
box. You can use this feature to view the data in the selected table.
Undo Last Move
lets you undo your
last action. For example, if you accidentally deleted a node, you
can click this button to restore that node to the list of search results.
You can undo only the last action that you performed, however.
Copyright © SAS Institute Inc. All Rights Reserved.