Teradata Schema Workbench is a user-friendly GUI used by an OLAP DBA to specify and manage the multidimensional model for your BI client applications. The OLAP DBA can easily and quickly select aspects of the star or snowflake schema for use as dimensions, levels, hierarchies, measures, and calculated measures. You simply build the schema one element at a time as shown in the following example.
Teradata Schema Workbench is often used with a design-time connection to the Teradata Database. The DBA conveniently selects actual columns to use for ROLAP. All schemas are validated against the database before they are published and made available to business analysts. You can specify cube and dimensional security in terms of existing Teradata roles and can grant or deny access by database schema, cube, dimension, hierarchy, level, or member. For example, you can grant access to western sales information only to the Western Sales Manager role. Cube schemas can be published to a database for use with Excel and other MDX BI tools.
With Teradata Schema Workbench, an OLAP DBA can use MDX expressions to specify business-oriented calculated measures and named sets such as Top 10 Products by Sales.
Teradata Schema Workbench works in either connected mode or disconnected mode. Connected mode requires a live connection to the database and simplifies schema definition by fetching appropriate metadata, such as table and column names, to enable fast pick-and-choose cube model definition. Disconnected mode requires no connection to the database, but requires you to specify all metadata.
You can save cube schemas to a BI schema .biml file to work offline or as input to Teradata Aggregate Designer to create optimized AJIs.