Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Need your advice on data export optimisation from essbase to relational table

edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

Need your advice on data export optimisation from essbase to relational table

Content

Hi Team,

 

I have a scenario where i am exporting level 0 data from essbase to one relational SQL table. what i am doing is basically fixing level 0 sparse member and few account (dense-level 0 account which is not dynamic calc) and running exporting script.

 

It is taking 2 hours 30 mintues to complete.

 

I have tried various essbase configuration setting to improve performance but did not get satisfactory result.

 

Below are the things i have already tried:-

 

1. batchenableinsert setting

2. Thread setting.

3. export thread setting

4. dynamic cal off to restrict exporting dynamic cal member

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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