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