The number of dense dimensions members affects the size of a block which ultimately affects the java heap size. For example, if the block cache is set to 2000, then the heap requirement for the blocks is 2000 times the size of the single block.
This example has the following three dense dimensions:
Time dimension = 104 members (2 years at 52 weeks per year)
Measure dimension = 30 members
Version dimension = 10 members
In this case, the size of each block is 104 x 30 x 10 x 8 (bytes) = 249.6KB, and the total heap required is 499.2MB (2000 x 249.6KB).
With the exception of time and measure dimensions, do not create dimensions as dense as the one in the above example.