Need your advice on data export optimisation from essbase to relational table
SummaryNeed your advice on data export optimisation from essbase to relational table
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