Cube administrators must install Teradata OLAP Connector to test ROLAP cubes. Refer to the Teradata OLAP Connector User Guide (B035-4105) for assistance. See Additional Information to locate this resource. If errors occur while testing cubes, refer to Troubleshooting and Known Issues.
The following lists the basic strategy to develop a high performing cube schema and cubes:
- Map a single fact table and a few dimension tables in the Business Intelligence Data View, and define the relationships between them.
- Define a simple dimension, hierarchy, and level first.
- Define a single measure group to contain a small number of measures and dimensions.
- Define a simple cube.
- Validate and publish the cube schema to the Teradata BI Model Repository.
- Use Teradata OLAP Connector to test the cube schema to ensure it works with Microsoft Excel.
- Use your chosen Teradata Database tool to run the SQL Explain feature to verify you are hitting the AJIs.
- Gradually add more features and MDX calculations, verifying at each step that you are not missing AJIs.
For more information on developing, testing, and confirming AJI-accelerated performance of simple and complex MDX calculation-containing cubes, see Best Practices.