Limitations and restrictions
This topic details the limitations and restrictions of all aspects of each OLAP
object type.
General
| Item | Maximum value | Comment |
|---|---|---|
| Number of databases on one server | 128 | |
| Memory consumption for one database on a 64-bit Windows | 2 TB (due to Windows limits) | Depends on the hardware and the operating system. |
Cubes
| Item | Maximum value | Comment |
|---|---|---|
| Number of dimensions in a cube | 30 | |
| How often can a dimension be used in a cube | 1 | |
| Number of cell notes in a cube | > 10,000,000 | |
| Number of characters in cube name/description | 50/150 | |
| Number of characters in a text cell | 1,000,000 bytes | |
| Number of rules in a cube | 20 dims: ~
2,000 10 dims: ~ 4,000 5 dims: ~ 8,000 |
Varies by the complexity of the rules and the number of dimensions in the cube. |
| Number of accelerators in a cube | ~ 32,767 | |
| Length of a cube rule | 4-8 Kbyte Text | Depends on the complexity of the rule. |
| Length of a cube accelerator | 499 | |
| Rule iteration depth | 256 | |
| Number of characters in a cell note | 30,000 | |
| Number of values in a cube | 2,000,000,000 | Limited by available virtual memory. |
Dimensions
| Item | Maximum value | Comment |
|---|---|---|
| Number of elements in one dimension | 10,000,000 | This number includes all leaf members and the aggregated members of different hierarchies. |
| Number of parents for one base element inside one dimension | 65,000 | An element cannot have more than 65,000 parents in an entire dimension regardless of the hierarchies. |
| Number of consolidations in one dimension | ~ 1,000,000 | A dimension must have at least one base element. |
| Number of factors in a dimension | > 1,000,000 | |
| Number of dimensions | > 1,000 | |
| Number of characters in dimension name/description | 50/150 | |
| Number of characters in element name | 71 | |
| Sum of the length of element names for a cell address | 1,440 | |
| Number of rules in a dimension | Dimension rules are used like cube rules. |
Hierarchies
| Item | Maximum value | Comment |
|---|---|---|
| Number of hierarchies per dimension | 500 | The number of hierarchies you have may impact performance. |
| Number of characters in hierarchy name/description | 50/150 | |
| Allowed characters in hierarchy name | Same as in the dimension name | The name of a hierarchy must not start with a number. Exception: For backward compatibility implicit hierarchies (the hierarchy name is the same as the dimension name) can start with a number. |
| Number of elements in a hierarchy | 10,000,000 | |
| Number of children for one parent | 10,000,000 | |
| Number of factors in a consolidation | 65,530 | Different consolidation factors used by the children of a consolidated element |
| Number of parents for one element inside one hierarchy | 65,000 | An element cannot have more than 65,000 parents in an entire dimension regardless of the hierarchies. |
| Number of levels in a hierarchy | 127 |
Subsets
| Item | Maximum value | Comment |
|---|---|---|
| Number of elements in a subset | 1,000,000 | |
| Number of subsets (public and private) | > 100,000 | The operating system limit of number of files in a directory can lower this limit. |
| Number of characters in a subset name | 100 |
Attributes
| Item | Maximum value | Comment |
|---|---|---|
| Number of attribute tables per database | > 3,000 | |
| Number of attribute tables per dimension | 3 | |
| Number of characters in an attribute field name | 50 | |
| Number of characters in an attribute field description | 50 | |
| Number of characters in a text field of an attribute table | 253 | |
| Number of fields within an attribute table | 49 |
Users
| Item | Maximum value | Comment |
|---|---|---|
| Number of user groups | > 10,000 | |
| Number of groups per user | > 1,000 | |
| Number of concurrently connected users | 16,000 |