Essbase ASO cube load
SummaryEssbase ASO cube load
- OS: Windows Server 2012 R2
- RDBMS: Oracle 12c (184.108.40.206)
- Essbase 220.127.116.11
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