2 Replies Latest reply on Oct 31, 2012 3:07 PM by 971356

    Outlineload tool problem

      I'm trying to load Account dimension data using outlineload. My input file is very simple:

      Account;Parent;Data Storage;Data Type;Description;Account Type;Aggregation (Plan1)
      RT09_Caap;Account;Dynamic Calc;;Currency;Revenue;~

      But everytime I finish with the following error:

      [Oct 29 21:27:40 CET 2012]Successfully located and opened input file "c:\files\d_account.csv".
      [Mon Oct 29 21:27:40 CET 2012]Header record fields: Account;Parent;Data Storage;Data Type;Description;Account Type;Aggregation (Plan1)
      [Mon Oct 29 21:27:40 CET 2012]Located and using "Account" dimension for loading data in "prp_pl" ap:plication.
      [Mon Oct 29 21:27:40 CET 2012]Unable to obtain dimension information and/or perform a data load: Unrecognized column header value(s), refer to previous messages. (Note: column header values are case sensitive.)
      [Mon Oct 29 21:27:40 CET 2012]Examine the Essbase log files for status if Essbase data was loaded.
      [Mon Oct 29 21:27:40 CET 2012]Planning Outline data store load process finished with exceptions: not all input records were read due to errors (or an empty input file). 0 data records were read, 0 data records were processed, 0 were successfully loaded, 0 were rejected.

      I would be grateful for any hint
        • 1. Re: Outlineload tool problem
          In your example you are using semicolon to separate, it should be comma separated


          • 2. Re: Outlineload tool problem

            I think the sequence of your information in the file is not correct. There is a blank between Dynamic Calc and Currency. This blank is for Account type which is required field. The blank should be after Currency which is for Description.

            Your sequence is RT09_Caap;Account;Dynamic Calc;;Currency;Revenue;~

            Try loading in this sequence RT09_Caap;Account;Dynamic Calc;Currency; ;Revenue;~

            I hope this will help.