MDX is a language for querying and manipulating multidimensional data in OLAP cubes, analogous to SQL for relational databases. Teradata Schema Workbench uses MDX to define calculations. During pivot table operations, MS Excel sends MDX to Teradata OLAP Connector, which uses cube metadata to interpret MDX and generate SQL.
To take full advantage of Teradata Schema Workbench, familiarize yourself with MDX before proceeding. For an excellent introduction to the language, we recommend Fast Track to MDX (Whitehorn, Zare, and Pasumansky 2006).
Additionally, the Microsoft Developer Network Library provides an MDX reference. Links to these references are accessible from the Teradata Schema Workbench Help menu. For more information, see Main Window and Schema Editor.