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

    Extract level 0 data from Essbase using ODI

    943321
      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 ,

      SET DATAEXPORTOPTIONS
      {
      DataExportDimHeader ON;
      DataExportRelationalFile ON;
      DataExportColHeader "Account";
      DataExportLevel "Level0";
      DataExportOverwriteFile ON;

      };

      FIX("Jan")
      DataExport "File" "," "C:\Finbud\calc\Jan.csv"
      ENDFIX;

      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 11.1.2.2 on Linux 64bit machine
      ODI 11.1.1.6

      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...

      Thanks
      Vikram.