Before creating the cube schema repository, you should install Teradata Schema Workbench. For more information, see the Teradata Schema Workbench Release Definition (B035-4108).
To create a cube schema repository using the Workbench Toolbox, see Setting Up the Schema Workbench Repository. To manually create a cube schema repository, use the following procedure.
-
Using Windows Explorer, find the repository directory.
The default location for this directory is:
- 32-bit:
C:\Program Files\Teradata\Client\15.10\Teradata Schema Workbench\Scripts\repository
- 64-bit:
C:\Program Files (x86)\Teradata\Client\15.10\Teradata Schema Workbench\Scripts\repository
- 32-bit:
- Execute BIM Repository DDL.sql.
- Execute BIM Repository Grants.sql to set up access using Teradata roles for basic solution operation. If the scripts run without errors, the Teradata BI Model Repository is installed correctly.