Dimensional Model Maximums
This table shows the dimensional model maximum values:
|
Database |
Maximum |
|---|---|
|
# Dimensions that measures are dimensioned by in a view |
You cannot have more than 22 unique dimensions that the measures in the view are dimensioned by. |
|
# Dimensions per model |
32 |
|
# Dimension members per dimension |
500,000 |
|
# Levels per dimension |
256 |
|
# Hierarchies per dimension |
256 |
|
# Attributes/dimensions in dimensional model |
50 |
|
# Attribute dimension members |
100,000 |
|
# Bytes in a dimension member label |
128 |
|
# Bytes in a measure label |
128 |
|
# Cases in a security procedure |
100 |
|
# Characters in a text variable cell |
20 (Excel Add-In) |
|
# Measures in a dimensional model |
10,000 |
|
# KPIs per dimensional model |
400 standard and indexed KPIs combined |
|
Report width |
255 columns and up to 32,000 bytes per row |
|
Report length |
64,000 rows in conjunction with 100 columns |
|
# dimensions per measure |
12, plus Time |