Maximum Capacity Specifications (Analysis Services)
New: 14 April 2006
The following table specifies the maximum sizes and numbers of various objects defined in Microsoft SQL Server 2005 Analysis Services (SSAS) components.
| SQL Server 2005 Analysis Services Object | Maximum sizes/numbers |
|---|---|
Databases in an instance |
2^31-1 = 2,147,483,647 |
Dimensions in a database |
2^31-1 = 2,147,483,647 |
Attributes in a dimension |
2^31-1 = 2,147,483,647 |
Members in a dimension attribute |
2^31-1 = 2,147,483,647 |
User-defined hierarchies in a dimension |
2^31-1 = 2,147,483,647 |
Levels in a user-defined hierarchy |
2^31-1 = 2,147,483,647 |
Cubes in a database |
2^31-1 = 2,147,483,647 |
Measure groups in a cube |
2^31-1 = 2,147,483,647 |
Measures in a measure group |
2^31-1 = 2,147,483,647 |
Calculations in a cube |
2^31-1 = 2,147,483,647 |
KPIs in a cube |
2^31-1 = 2,147,483,647 |
Actions in a cube |
2^31-1 = 2,147,483,647 |
Partitions in a cube |
2^31-1 = 2,147,483,647 |
Translations in a cube |
2^31-1 = 2,147,483,647 |
Aggregations in a partition |
2^31-1 = 2,147,483,647 |
Cells returned by a query |
2^31-1 = 2,147,483,647 |
Record size of the source query |
64K |
Length of object names |
100 characters |
Maximum number of distinct states in a data mining model attribute column |
2^31-1 = 2,147,483,647 |
Maximum number of attributes considered (feature selection) |
2^31-1 = 2,147,483,647 |
For more information about object naming guidelines, see Objects and Object Characteristics.
For more information about data source limitations for online analytical processing (OLAP) and data mining, see Working with Data Sources (Analysis Services).
Data Types
For all DataItems, SQL Server 2005 Analysis Services supports the following subset of System.Data.OleDb.OleDbType:
- BigInt
- Binary
- Boolean
- Currency
- Date
- Double
- Integer
- Single
- SmallInt
- TinyInt
- UnsignedBigInt
- UnsignedInt
- UnsignedSmallInt
- WChar
The following table lists the extra validations that Analysis Management Objects (AMO) does for certain bindings:
| Object | Binding | Allowed Data Types |
|---|---|---|
DimensionAttribute |
KeyColumns |
All but Binary |
NameColumn |
Only WChar |
|
SkippedLevelsColumn |
Only integer types: BigInt, Integer, SmallInt, TinyInt, UnsignedBigInt, UnsignedInt, UnsignedSmallInt, UnsignedTinyInt |
|
CustomRollupColumn |
Only WChar |
|
CustomRollupPropertiesColumn |
Only WChar |
|
UnaryOperatorColumn |
Only WChar |
|
ValueColumn |
All |
|
AttributeTranslation |
CaptionColumn |
Only WChar |
ScalarMiningStructureColumn |
KeyColumns |
All but Binary |
NameColumn |
Only WChar |
|
TableMiningStructureColumn |
ForeignKeyColumns |
All but Binary |
MeasureGroupAttribute |
KeyColumns |
All but Binary |
Distinct Count Measure |
Source |
BigInt, Currency, Double, Integer, Single, SmallInt, TinyInt, UnsignedBigInt, UnsignedInt, UnsignedSmallInt, UnsignedTinyInt |
See Also
Other Resources
Working with Data Sources (Analysis Services)
Objects and Object Characteristics