2 Replies Latest reply: Mar 19, 2009 10:15 AM by 685877 RSS

    ASO data export using report script

    665137
      Hello Essbase consultants,

      We are facing an unanswered issue for a data export using a report script in our projec, we export from a ASO cube.
      MAxl Code implemented is the following :

      export database SYNTHASO.Plan1 using report_file 'Exp.rep'
      to data_file 'my.rpt';

      Error log is the following :

      MAXL> export database SYNTHASO.Plan1 using report_file 'Exp.rep'
      +2> to data_file 'my.rpt';+

      +ERROR - 1030100 - Cannot open file: [Exp.rep].+
      ERROR - 1241101 - Unexpected Essbase error 1030100.

      If we export level 0 data (no report script used), it works fine.
      We checked the report script (generated with query designer) it looks like correct (only level 0 data are selected)

      +<SETUP { TabDelimit } { decimal 13 } { IndentGen -5 } <ACCON <SYM <QUOTE <END+

      +<COLUMN("Mesure")+
      +<ROW("Entity","Distribution","Pages","Period","Year","Scenario","Version","Account")+

      +// Page Members+

      +// Column Members+

      +// Selection rules and output options for dimension: Mesure+
      +{OUTMBRNAMES}+
      +"EUR"+
      +// Row Members+

      +// Selection rules and output options for dimension: Entity+
      +{OUTMBRNAMES}+
      +"324129"+
      +// Selection rules and output options for dimension: Distribution+
      +{OUTMBRNAMES}+
      +"SD1"+
      +// Selection rules and output options for dimension: Pages+
      +{OUTMBRNAMES}+
      +<Link ((<LEV("Pages", "Lev0,Pages")) AND ( <IDESC("TOT_Pages")))+
      +// Selection rules and output options for dimension: Period+
      +{OUTMBRNAMES}+
      +"S_05"+
      +// Selection rules and output options for dimension: Year+
      +{OUTMBRNAMES}+
      +"FY08"+
      +"FY09"+
      +// Selection rules and output options for dimension: Scenario+
      +{OUTMBRNAMES}+
      +"REEL"+
      +// Selection rules and output options for dimension: Version+
      +{OUTMBRNAMES}+
      +"VT"+
      +// Selection rules and output options for dimension: Account+
      +{OUTMBRNAMES}+
      +"DGq"+
      +// Restrictions+
      +<RESTRICT (@DATACOL(1) != #Missing)+

      !

      Questions are :
      Have you already faced similar issues on your project ? can we just export ASO data with a report script ? Is there any syntax error on that script ?
      Is there any other solutions in exporting ASO data with restrictions ?

      Thanks for your time and help.

      Pierre-Jean