Maximum Capacity Specifications (Analysis Services - Multidimensional Data)

The following table specifies the maximum sizes and numbers of various objects defined in Microsoft SQL Server Analysis Services components.

SQL Server 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 Defining Data Sources (Analysis Services).

Data Types

For all DataItems, SQL Server 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

Concepts

Objects and Object Characteristics

Other Resources

Defining Data Sources (Analysis Services)