2 Replies Latest reply on Dec 6, 2015 4:42 AM by SoL

    Multi period data load from flat file to ASO database

    SoL

      FDM Gurus,

                           We're trying to load Plan data for 12 months to an Essbase ASO database using FDMEE.

      We followed the documented step of specifying in the Import format for Amount (Columns=<start>,<end>) AND choosing the "Multi-Period Text file (Contiguous Period)" in the data load rule.

      However, Validation still fails for Period dimension It complains "No Source value for UD3".  {UD3 in our case happens to be Period}

       

      Our flat file record looks like below:

           Dim1, Dim2,Dim3,Dim4,Dim5,Dim6,1,2,3,4,5,6,7,8,9,10,11,12

       

      In the Import format's mappings section, I see the "Period" dimension also. Could this be the problem? As you know, for Planning database, it doesn't show.

       

      Would appreciate if somebody could shed some light. Thanks!