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.