Data Export in Essbase
SummaryData Export in Essbase
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.
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');