Max # records for a cube

Modified on Thu, 14 Mar 2024 at 12:17 PM

Is there any limitation on the maximum number of records for generating a cube? Viz., Maximum size of the cube by design?

There is no restriction on the maximum number of records by Smarten suite. When huge records are to be written into the cube, either you will need to increase the RAM to handle the huge data or you will have to optimize the fetch size as shown :

a) the result set fetch size at the database level

b) the record fetch size at the cube rebuild process

In all these cases, we still need to work on the data aggregation level too (for faster retrieval of objects)

Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using.

maximum number of records Max # records cube result set fetch size record fetch size Business Intelligence Support Business Intelligence Articles Business Intelligence Training