We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart View retrieval is extremely slow when retrieving data from ASO database

Received Response
11
Views
6
Comments
edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

Smart View retrieval is extremely slow when retrieving data from ASO database

Content

Hi all

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 - 11.1.1.2

Smart View Version - 11.1.1.2

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!