Teradata Schema Workbench is part of a solution providing customers with an enterprise-class, general purpose MDX/OLAP solution for Teradata Relational Online Analytical Processing (ROLAP) architecture. Teradata Aggregate Join Indexes (AJIs), created using Teradata Aggregate Designer, improve performance.
The Teradata OLAP solution consists of a set of software components that work together to specify the multidimensional model for your ROLAP system, and handle MDX queries from various BI clients.
- Teradata OLAP Connector
- Teradata Aggregate Designer
- Teradata Schema Workbench
- Teradata OLAP Server
An OLAP cube administrator starts by using the Teradata Schema Workbench to indicate how a star or snowflake schema and fact table in your relational database should be mapped to OLAP cubes, dimensions, hierarchies, levels, and measures. The resulting cube schema is published by Teradata Schema Workbench directly to the Teradata Database system for later use by BI run-time client applications.
The cube schema can also be sent via a BI Schema file to the Teradata Aggregate Designer. Teradata Aggregate Designer utilizes the schema definition to assist the DBA to design Aggregate Join Indexes (AJIs) that support high performance ROLAP queries.
The Teradata OLAP Connector functions as an OLE DB for OLAP (ODBO) provider data source for BI client applications which communicate via MDX, such as MS Excel or Tableau. This allows business analysts to perform real-time OLAP queries directly on the Teradata Database System.
The Teradata OLAP Server provides direct access to the Teradata Database from any BI server applications that communicate via XMLA, such as SAP BO.