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.
- 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.
- TBI_USER
- TBI_WORKBENCH
- TBI_SERVICE
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.