Smart View retrieval is extremely slow when retrieving data from ASO database
SummarySmart View retrieval is extremely slow when retrieving data from ASO database
I have a ASO cube having with 15 dimension and total cube size is around 30gb
we trying to retrieve data from the cube and its taking around 40 mins for a report, and we have 19 similar reports
but the essbase log says "Spreadsheet Extractor Elapsed Time : [332.64] seconds", I'm not able to understand why its running for 40 mins.
I have already changed addin settings researched ways to improve performance but its not working.
Any thoughts on good solutions to this one?
Essbase version - 184.108.40.206
Smart View Version - 220.127.116.11