Data Export in Essbase

Summary

Data Export in Essbase

Content

We have a requirement to export essbase cube data into table(relational database). I'm able to export essbase data using below mentioned DATAEXPORT command in calculation script but there is one constraint that I'm not able to find any option to control output sequence/format like we have formatting option in essbase report script.

For Example

If we have following dims in outline and target relational table (newyork).

- Time (Dense)

- Accounts (Dense)

- Product (Sparse)

- Entity (Sparse)

It will generate following INSERT query:

INSERT INTO newyork('Product1', 'Entity1', 'FY17', 'Account-1234', '500');