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

The cube schema repository, known as the Teradata BI Model Repository, is a solution-maintained database used to manage the OLAP metadata of the Teradata solution. It can be installed and configured on your database using the Workbench Toolbox described in Schema Workbench Toolbox.

The Teradata solution stores cube schema data and associated metadata in a database named BIM_REPOSITORY. The Teradata BI Model Repository has the following characteristics:
  • Is self-managed by Teradata Schema Workbench. Do not add or subtract records manually.
  • Does not take a lot of space because it does not store cube aggregation data. It only stores cube schema information you have entered using Teradata Schema Workbench.
  • Does not need tuning or other optimizations. Do not adjust, compress, or add an index to the Teradata BI Model Repository.

The Teradata BI Model Repository contains tables, with views and macros, that do not relate to other tables on your server outside of the BIM_REPOSITORY database. The Teradata OLAP Connector, used by BI client applications, only reads from this information, with the exception of creating a few small volatile tables of coalesced metadata for the duration of an Excel session.

Repository creation includes the following three mandatory roles:
  • TBI_USER
  • TBI_WORKBENCH
  • TBI_SERVICE

See Mandatory Security Roles.

In addition to the three mandatory roles, additional roles need to be created for BI Excel users in order to specify their access to certain cube schema definition elements different from other groups of users. See Security Settings.