Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Essbase ASO cube load — Cloud Customer Connect
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

Essbase ASO cube load

Received Response
22
Views
12
Comments
edited Aug 2, 2018 2:36AM in Essbase 12 comments

Summary

Essbase ASO cube load

Content

- OS: Windows Server 2012 R2

- RDBMS: Oracle 12c (12.1.0.9)

- Essbase 11.1.2.4

We are loading the data to the ASO cube through SQL queries with plain import statements (with out buffers) and it used to take 15 to 20 minutes before creating the aggregate views.

It is taking 3 hrs 15 minutes to load the data into the cube after aggregate views have been created

how this data load can be optimized

Regards,

Raju.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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