0 Replies Latest reply: Jan 20, 2013 11:08 PM by 943321 RSS

    Extract level 0 data from Essbase using ODI

      Hi All,

      Its been discussed several times in the forms. I am sorry to ask you this question once again.

      I want to extract level 0 date from essbase to .csv file or .txt file using ODI.

      Step1 :
      Created following Calcscript ,

      DataExportDimHeader ON;
      DataExportRelationalFile ON;
      DataExportColHeader "Account";
      DataExportLevel "Level0";
      DataExportOverwriteFile ON;


      DataExport "File" "," "C:\Finbud\calc\Jan.csv"

      Even after adding DataExportDimHeader ON in calcscript its giving me the following error message. The same script is running file from EAS console.
      Version Details:
      Hyperion Essbase on Linux 64bit machine

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 1, in <module>
      at com.hyperion.odi.essbase.ODIEssbaseDataReader.getAppData(Unknown Source)

      at com.hyperion.odi.essbase.AbstractEssbaseReader.extract(Unknown Source)

      at sun.reflect.GeneratedMethodAccessor379.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(Method.java:597)
      com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: The first row in the data file should contain the dimension header. Please make sure that in your calculation script the DataExportDimHeader option is turned on
      Please Help me on this issue...