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.
Tags: maximum number of records, Max # records, cube, result set fetch size, record fetch size, Business Intelligence Support, Business Intelligence Articles, Business Intelligence Training, Limitation, Smarten Suite, Huge Records, RAM, Optimize, Fetch size, Database Level, Cube Rebuild Process, Data Aggregation, Faster Retrieval, Objects,
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article