Faster way for Data Extraction out of on-prem Essbase for freeform application

Summary:

Hi All,

We are extracting data from an on-prem Essbase application (single BSO cube) to load into the Freeform application. Due to the data size, we cannot extract the data in bulk from the Essbase application. Currently, we are extracting data for one month at a time using the DATA EXPORT command, and after that, changing the file so that it can be uploaded in Freeform using the data management.

The data import in the Freeform for a month is not taking much time as we use the simple mode in data management to import the data.

The problem is data extraction; the Essbase takes 5 to 6 hours to extract one month of data in the file. We are looking for a process that extracts the data from Essbase faster than the DATA EXPORT option. We went through some blogs where it was suggested that MDX in Essbase comparatively gives faster results than the DATA EXPORT command. Still, the problem is that MDX for on-premise Essbase does not have any native command to export the data in the file directly using the custom delimitator.