Hány kockát építhetünk egy adatbázisban?
Összesen 2^31-1 azaz kicsit több, mint kétmilliárd kockát építhetünk egy Analysis Services-en alapuló BI megoldásba. Jó tudni, nehogy a kockák gyártása közben véletlenül túlszaladjunk ezen a korláton. J
Az Analysis Services felső korlátairól a Maximum Capacity Specifications (Analysis Services - Multidimensional Data) című cikkben található bővebb információ, de a lényeget bemásolom ide is:
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 |
Kővári Attila - BI projekt
Új hozzászólás