Data Range for Cubes
Cube data can be classified for small, mid, and large cubes. Based on the data range for cubes, you can configure your database.
The following tables provide the data range for cubes. You can also use the tables as worksheets for noting the properties for cube, measures, dimensions, and users.
| Fields | Definition | Small cube | Mid cube | Large cube | Value |
|---|---|---|---|---|---|
| Cube properties | |||||
| Total Facts | Total number of transactions | <20 M | 20 to 30 M | >=30 M to <=50 M | |
| Monthly Facts | Number of Transactions in Monthly Fact | < = 10 M | > 10 M to <=20 M | >20 M <=30 M | |
| Large Dimension Rows | Number of rows in large dimension | <1 M | >1 M to <=1.5 M | >1.5 M to <=2.5 M | |
| Level | Maximum Level in a hierarchy for any Dimension | <3 | 3 to 5 | >5 to <=8 | |
| Max leaf node under a parent | Maximum number of leaf nodes in any given dimension | < 100000 | > = 100000 to <200000 | > 200000 to <=300000 | |
| Fields | Definition | Small cube | Mid cube | Large cube | Value |
|---|---|---|---|---|---|
| Base | Number of Base measures available in cube | <=3 | >3 and <=5 | >5 to <=7 | |
| Calculated | Number of Measures created over base measures in Spend Analysis system | <=2 | <=3 | > 3 to <=5 | |
| Hybrid | Number of Measures created over base measures of Hybrid type in Spend Analysis system | 0 | <=3 | >3 to <=5 | |
| Dynamic Masking | Measures with masking option turned On (Masking for rollup values not of a single unit) | 0 | 0 | >1 to <=5 | |
| Calculated in Calculated | Number of Measures created over calculated measures in Spend Analysis system | 0 | <=3 | >3 to <=5 |
| Fields | Definition | Small cube | Mid cube | Large cube | Value |
|---|---|---|---|---|---|
| Total Dimensions | Total number of all dimensions in a cube | <=18 | <=21 | >21 <=25 | |
| Visible Dimensions in Viewer | Number of dimensions made visible in a Viewer | <=7 | <=8 | >8 to <=10 | |
| Max No of Attributes in Dimension | Maximum numbers of attributes enabled for any dimension | <=2 | <=3 | >3 to <=5 |
| Fields | Definition | Small cube | Mid cube | Large cube | Value |
|---|---|---|---|---|---|
| Concurrent Users | Total number of Concurrent Users (Total Users) | 8 (54) | 12 (80) | 15 (100) s |
Note:
- If any two parameters change, consider the next cube size for hardware.
- If any two parameters change in Large-Size cube, consider the cube to be Extra Large. Separate sizing activity must be done on actual data for deciding the hardware. You can use the Large-Size cube hardware as the starting point for the hardware.
For information about hardware, see Hardware Requirements for Database and Application Servers for Emptoris Spend Analysis.