You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Export in Essbase

Received Response
22
Views
4
Comments
edited Aug 2, 2018 2:36AM in Essbase 4 comments

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');

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!