3 Replies Latest reply on Sep 13, 2016 8:56 AM by 2750537

    How to suppress 0 while importing SAP data in FDM using event script.




      We want to  suppress records having 0 amount when it is being imported to FDM. I was trying to use event scripts but confused which one to use for said purpose.

      I saw one oracle document stating below code -


      delStmt = """

      DELETE FROM tdataseg_t

      WHERE loadid = ?

      AND amount = 0


      params = [ fdmContext["LOADID"] ]

      delCount = fdmAPI.executeDML(delStmt, params, True)


      but this one does not get validated. Seems it is for FDMEE while we are using FDM Classic.


      Any help will be much appreciated.