• Article

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