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
ElegantJ BI 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 ElegantJ BI Version 4.0. This may or may not be relevant to the ElegantJ BI version you may be using.