2 Replies Latest reply on May 21, 2008 1:52 PM by lalajib

    Multiload data across the years..

    lalajib
      Hi All,

      I'm trying to load the multiperiod data which is across two years, during the check -in process, Import process and Export process, FDM interface shows that it identified the two years correctly along with the months but the Export file which FDM creates before loading into Planning cube, does not show the changed year. When using the MultiLoad option within same year, it works fine but doesn't work if it's across the years.

      Did anybody encountered this issue and if so, can you please let me know how to resolve it. Any help would be appreciated.

      Thanks
      User625353
        • 1. Re: Multiload data across the years..
          635389
          HI,

          Using import script define variable that will get year from POV before importing data and then write it down to newly defined dimension. After that change the export script to replace this dimension for a year - replace the standard year dimension and export data to essbase

          regards
          Karolus
          • 2. Re: Multiload data across the years..
            lalajib
            Hi,

            We are doing something similar to this now but picking up year, starting month and the number of months from the Data File itself and based on that information generating the year and the associated month during import. Anyway thank you so much for your help.

            Thanks
            625353