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

DATAEXPORT Calc Script Error

Received Response
19
Views
10
Comments
edited Aug 2, 2018 2:36AM in Essbase 10 comments

Summary

DATAEXPORT Calc Script Error

Content

Hi,

I'm using a Calc Script to export a partial data into a File. When I see the export file I see that the export contains 2 header rows with all the dimensions in the first row and all the "Measures" in the second row since I used   DataExportColHeader "Measures". Now back in ODI, it is unable to recognize this Flat File. When I'm doing reverse engineering, it's just picking up the first row of dimensions and sorting the rows accordingly which is actually deviating from our purpose to extract right columns of data.

So is there anything I need to change in my below Calc script to export right dimensions in just one row? Please Advice?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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