Here, we’ll cover the ability to use ODI for one its basic features: extracting data from Essbase and using the exported file to load to a table. It turns out that ODI was not recognizing the file generated by Essbase. Let’s see what we were missing: We have a calc script exporting level 0 data from […]
Posts Tagged ‘DATA export from Essbase’
Performance vs Set DATAEXPORTOPTIONS in ESSBASE
Many of us may have used SET DATAEXPORTOPTIONS. But I noticed that there are some glitches in that command usage that is not documented explicitly. It can cause a “LOT” of trouble with respect to performance. I spent few hours on this and thought will share it with you all to save some time. However, […]