Teradata BI Model Repository Limitations - 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 Teradata BI Model Repository has the following size limitations:

  • Schemas in a repository: 231 -1
  • Cubes in a schema: 128
  • Dimensions in a cube: 1024
  • Hierarchies in a dimension: 1024
  • Levels in a cube: 1024
  • No limit for the number of levels in a hierarchy or dimension
  • Measures in a cube: 1024
  • Calculated measures in a cube: 1024
  • Length of OLAP object names and identifiers (such as schemas, cubes, dimensions, etc.) and their captions: 100 characters