2 Replies Latest reply on Feb 21, 2011 4:15 AM by TonyScalese

    Flat file from FDM

    839870
      Hi Gurus,
      I have to load data from Planning to HSF using FDM. Version I am working on is 11.1.1.3. I just wanted to know if rather than directly loading data into HSF, can FDM prodoce a flat file as a result of the Export step, which can be later used to batch import into HSF?

      I have a similar requirement of local HFM application producing a flat file from FDM which will be subsequently loaded into the world-wide HFM application as local users have restricted access to the world-wide HFM appllication.

      Thanks & Rgards!
        • 1. Re: Flat file from FDM
          754501
          If you want FDM to produce flatfiles as output, you can use Pull adapter which gives your data as .dat files in FDM Outbox. However to load these files in HFM or other Hyperion tools, you would need special scripting.
          1 person found this helpful
          • 2. Re: Flat file from FDM
            TonyScalese
            You could use the HSF or HFM adaptor and simply disable the load. In the integration settings of each adaptor, there is an "Enable Load" option. Unchecking this will produce the dat file but will not load it.

            Please take the time to flag answers as helpful or correct if you found them to be.