1 Reply Latest reply on Oct 6, 2017 9:49 PM by USER1211

    Multi-Period FDMEE import with more than 12 periods per year

    GIannuzzi

      Hello,

       

      Business wants to create a process to import the 5 years plan from Planning application to HFM.

      We are facing an issue importing the data from planning application to FDMEE import stage with the periods.

       

      For Period x we need to import MTD data

      For period y we need to import YTD data

       

      Setup is

       

      Y1 : MTD Jan-DEC

      Y12 to Y5 : YTD Dec

       

      However, MTD and YTD are in the Period Dimension. Setup is :

       

      Year total -> JAN-DEC

      YTD -> JAN_YTD to DEC_YTD (dynamicaly calculated using Shared members)

       

      We are unable to get FDMEE to take MTD period for Y1 and YTD for Y2 to 5 since we cannot map all those periods.

       

      Is there a way to do it?

        • 1. Re: Multi-Period FDMEE import with more than 12 periods per year
          USER1211

          What version of Hyperion(including patch level)?(e.g HFM 11.1.2.4.205,FDMEE 11.1.2.4.210)

          You could export dynamic dense member data  but it could severely impact your export time hence you must test such first to see if it is feasible.

          Secondly  have you tested loading the data into HFM into the applicable members and having HFM simply handle what is period versus YTD ? HFM has a View dimension.