for previous versions at the Internet Archive. Yahoo! is not affiliated with the authors of this page or responsible for its content.
Business Metadata Repository Web Interface Users Manual Updated: January 10, 2002





Business Metadata Repository
Web Interface
Users Manual
Updated: January 10, 2002
Page 1 of 26




The main menu screen provides a listing of available categories to choose from. Each category then
presents the user with additional options and functions.
A description for each button is provided to help explain what each category provides.

Table Info
This category gives the user the option to view and update information about
a selected table, view and update field information, and view Fact/Dimension
table usage.
Presentation Groups
This category gives the user the option to view and update information about
Presentation Groups, or the tables associated with those groups.
Stewards
This category provides information about each Data Steward, allowing the
user to update, delete or add steward information.
Security
This category provides information about each Security Level, allowing the
user to update, delete or add security level information.
Query Catalog
This button takes the user to a screen showing the information associated with
the selected query. Report Types and Report Categories can be updated from
subsequent screens.
Import New Table
This feature provides a means to take work that was done in Designer, and
allow the program to automatically update the database with this information.

Page 2 of 26


The Select Table Screen offers the user a choice of various options related to the available tables.

Table Information
This button takes the user to a screen that displays information about the table
that was selected in the listbox.
Field Information
This button takes the user to a screen that displays information about the
fields associated with the table selected in the listbox. The first field available
is loaded automatically when this screen is called.
Return to Main Menu
This button takes the user back to the Main Menu Screen

Page 3 of 26

The List Table Information Screen provides information about the specified table name.

The table being viewed can be changed by selecting the drop down menu to the right of the Table Name tag.
Selecting the desired table name will automatically cause the screen to refresh, displaying the correct
information.
Some fields that have a drop down menu can also be entered manually. Manual information can be entered
into the textbox directly below a heading that begins with the word "Alternatively". This information will be
entered into the database and will be available for selection from the drop down menu after the data has
been submitted. If the selection is deleted and does not appear anywhere else in the database, the selection
will no longer be available from the drop down box.
Certain fields, like the Database Name are required, and therefore changing the input to a blank or NULL
value is not permissible. An Error message box will popup in this instance.

Show Fields
This button takes the user to a screen listing all of the fields associated with
that particular table.
Show Related Tables
This button takes the user to a screen showing Fact and Dimension table
relationships.
Print Report
This button produces a report that shows all of the available tables and their
most significant information.
Enter New Table
Information
This button allows the user to enter a completely new table
Delete Table
This button deletes the currently selected table.
Return to Select New
Table Screen
This button takes the user back to the screen to select a new table
Return to Main Menu
This button takes the user back to the Main Menu Screen


Page 4 of 26




Provides a report of all the tables listed within the metadata database, sorted by the common name of the
table. Items listed are the Database name, table ID and the short description of the table.

Page 5 of 26

The Field List Screen provides information about the fields associated with the specified table.
The Field being viewed can be changed by selecting the drop down menu to the right of the Field Name tag.
Selecting the desired field name will automatically cause the screen to refresh, displaying the correct information.
The Table being viewed can be changed by selecting the drop down menu to the right of the Table Name tag.
Selecting the desired table name will automatically cause the screen to refresh, displaying the correct information for
that table and producing a new Field Name drop down menu.
Some fields that have a drop down menu can also be entered manually. Manual information can be entered into the
textbox directly below a heading that begins with the word "Alternatively". This information will be entered into the
database and will be available for selection from the drop down menu after the data has been submitted. If the
selection is deleted and does not appear anywhere else in the database, the selection will no longer be available from
the drop down box.
Certain fields, like the Database Name are required, and therefore changing the input to a blank or NULL value is
not permissible. An Error message box will popup in this instance.

Print Full Report
This button produces a report that shows all of the available tables and their most
significant information.
Print Field Report
This button produces a report of only the selected field.
Return to Select New Table
Screen
This button takes the user back to the screen to select a new table to be displayed.
Return to Table Information This button takes the user back to the table information screen.
Enter New Field
This button takes the user to a screen where information can be entered to create a
new field.
Delete Field
This button deletes the currently selected field.
Return to Main Menu
This button takes the user back to the Main Menu Screen

Page 6 of 26



Provides a report listing the selected table and a number of its characteristics. Depending on the option
chosen, below the table information will be either a complete listing of all of the fields associated with the
table, or just the field that was selected on the previous screen.



Page 7 of 26

The New Field Entry Screen allows the user to create a new field based on information entered into this
screen.
Information that is required is marked with an asterisk. If this information is not entered before submittal,
an error message will be displayed, and the submission will not be allowed until the missing field is filled
out.

Generate Print Text
This button takes the information entered for Field Type, Length, Number of
Decimals and Century to generate text for the "Print" field.
Submit New Attribute
Information
Submits the information entered for entry into the database.
Return to List of Fields
This button takes the user back to the Field Information Screen
Return to Main Menu
This button takes the user back to the Main Menu Screen


Page 8 of 26


The View Related Tables Screen displays to the user the Dimension or Fact Tables that are associated with
the table.
Comment text for the Fact/Dimension association is displayed below the Dimension Table listing. The
comments can be modified as necessary.

Submit Comment Change Once changes are made to the comment text, this button submits the
information for entry into the database.
Create Relationship
Between Tables
After selecting the Dimension Table and the Fact Table, pressing this button
creates a relationship between the two.
Return to View Table
Information
This button takes the user back to the View Table Information screen.
Return to Main Menu
This button takes the user back to the Main Menu Screen


Page 9 of 26
Screen 14
The Presentation Groups Screen provides a menu that allows the user to modify Presentation Groups.

Remove Table or Query
From Presentation Group
This button takes the user to a screen where a table or query can be removed
from the currently selected presentation group.
Add Table or Query to
Presentation Group
This button takes the user to a screen where a table or a query can be added to
the currently selected presentation group.
Add Presentation Group This button takes the user to a screen where a new presentation group can be
created.
Delete Selected Group
This button deletes the currently selected presentation group. A warning
message is displayed before deletion is initiated.
Table Information
This button takes the user to the Table Information screen, but shows only
those tables associated with the selected presentation group.
Return to Main Menu
This button takes the user back to the Main Menu Screen


Page 10 of 26

The Presenta