- Open the MDX Sample application. The Connect dialog box appears.
- In the Server box, type a DSN name that contains a saved Teradata username and password.
- In the Provider box, type TeradataMDXProvider.
- Click OK.
- From the DB menu, select a schema.
- Type a SELECT query using your hierarchy default member MDX on one of the axes.
- [Optional] If necessary, wrap your formula with curly brackets, such as { and }, to satisfy the requirement for a set expression on an axis.
If the query runs successfully, the MDX expression is correct and valid.
Example - MDX Sample Application
The following figure shows how to use MDX Sample to validate MDX formulas. Use the Cube box to get the exact names for the schema elements, as they vary depending on the MDX provider. If you click and drag an element from the Cube box and drop it in the Sample Query box, a qualified name generates for the element. If the formula is correct, the resulting row for your default member displays in the Query Results pane.