3 Replies Latest reply on Jun 2, 2016 4:10 PM by ksdesh

    Data export not writing period member

    ksdesh

      I am doing a data export in a calc script. I have 12 dimensions in the cube. The output file is coming out fine except for one issue. The file does not write the name of the period member for which the data is being extracted. It writes the members of 11 dimensions but does not write the period.

      If I fix on 1 month it will write a total of 12 columns 11 dimensions + 1 data column.
      What I want is 13 columns (12 dimensions + 1 data column)

       

      Am I missing something or is this how it is supposed to be?

       

      Period is a dense dimension, The following are my export options:

       

      SET DATAEXPORTOPTIONS

      {

      DataExportDynamicCalc On;

      DataExportDecimal 12;

      DataExportRelationalFile On;

      DataExportOverwriteFile ON;

      };

        • 1. Re: Data export not writing period member
          Julien Mallet

          Hi

           

          Add the option

          DataExportColHeader Period;

           

          Together with the other options.

           

          Cheers

          1 person found this helpful
          • 2. Re: Data export not writing period member
            GlennS_3

            Julian was on the right track as to why you are not seeing the period, but the answer will not give you want you want. When you do a dataexport you have to think of it like any grid retrieval where you have to have something in the rows and something in the columns. Therefore if you have 12 dimensions, you will have 11 members in the row and columns for the 12th value. In your case since you fix on a single period, you are getting that period as a column value. Unfortunately Dataexport does not display the names of the columns.  Were you to fix on Jan:Dec, you would have 12 columns , one for each period. The columns are always a dense dimension that dataexport will pick unless you explicitly specify what dimension is the columns (as Julian described).

            The only way I Know to get what you want is to add an additional dense dimension to the cube with a single member then you can use that for the dense dimension and get the periods in the rows. If you can't do that to your existing cube, you could create a clone of the cube, add the dimension, export the data from your cube into the new cube and then run your dataexport from there

            • 3. Re: Data export not writing period member
              ksdesh

              Thank you both.