ASO SmartView retrieval time is much slower than BSO
Summary:
We have a SmartView ad hoc sheet with 30,000 rows of data, while BSO cube took around 2.5 mins but ASO took around 6 mins for retrieval.
For ASO outline,
- No member formula used.
- Have dimensions with dynamic and multiple hierarchy types due to Shared members exists in those dimensions.
We have tried to have same 1 row of data repeated 30,000 times = 30,000 rows to see whether it is the amount of rows that caused the slow performance or it is related to the dimension members data that we used. For this case, this only take 32 seconds, so we are suspecting the slow performance is related to data.
Tagged:
0