Table of contents
No headers
The aggressiveness of the cube processing is based on two elements:
the number of elements to process and the connection pool.
The number of elements include:
- The number of dimensions
- The number of cubes
- The number of fact tables in cubes
- The number of partition per fact tables
- The number of data sources
In the NRS/NBI OALP base, we use a single data source and we are partitioned for fact tables more or less aggressively depending on the version:
In version 2.2.1
- Two partitions per fact tables for the raw results/messages/statusranges
In version 3.0.0
- 24 partitions per fact tables for the raw results/messages/statusranges
By default we allow 10 simultaneous connections to a data source.
To tune the aggressiveness of the cube processing you can modify the "maximum Number of connections" parameter of the data source through the data source properties in SSAS.
Comments