Manually Creating the Cube Schema Repository - Teradata Schema Workbench

Teradata Schema Workbench User Guide
Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
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.

  1. 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

  2. Execute BIM Repository DDL.sql.
  3. 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.