The Teradata Schema Workbench provides the following features:
- Schema Editor Titlebar – View the open schema name and location.
- Teradata Schema Workbench Menu and Toolbar – Use the menus to create, open, save, delete, validate, and publish schemas, and connect to or disconnect from a database. Use the toolbar to create, open, and save schemas.
- Schema Editor Toolbar – Use the toolbar to create or delete a cube, dimension, hierarchy, level, property, fact table, measure group, measure, calculated measure, calculated member, or named set.
- Schema Elements – View the elements within your schema.
- Localization Element – Access the pane to localize member captions and formats.
- Schema Tree View – View the schema elements that you build and define.
- Business Intelligence Data View – Manage data tables, fact tables, and cube security.
- Schema Element Properties View – View the properties of a schema element chosen from the Schema Tree View.
- Schema Status Bar – Displays the status of the current schema.
- Database Connection Status Bar – Displays the status of the database connection.
-
Validation Error Log – View error logs after schemas have completed validation.This view only displays if errors occur during schema validation.
The following figure shows the main window with one open schema.
Teradata Schema Workbench Main Window and Schema Editor
