We have PBCS cube where we have
In our data form
Rows - idescendants of Sparse dimension
Columns - combination of Dense dimension( Account & Period)
Page / POV have rest sparse dimensions.
suppress missing blocks and suppress missing rows - YES
Total Cells in form fetched for a combination is in the range of 82000 cells - taking 20 seconds of time to fetch data. or is this the optimal data form load time?
Is there a way we can reduce the time to fetch data (approx 82000 cells) in the data form?
Shall we play around the order of dimensions in the cube?
Present order of dimensions
Account
Period
Sparse 1 - Years (10 members)
Sparse 2 - Scenario (10 members)
Sparse 3 - Version (12 members)
Sparse 4 - Entity (145)
Sparse 5 (4865 members)
Sparse 6 (25 members)
Sparse 7 (1819 members)