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

    Multiload data across the years..

      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.

        • 1. Re: Multiload data across the years..

          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

          • 2. Re: Multiload data across the years..

            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.