2 Replies Latest reply on Apr 10, 2017 12:35 PM by Nishant Fukate

    FDMEE Mapping Script

    Nishant Fukate

      Hello Experts,

       

      We are trying import data from flat file. We have 'Account'  dimension member in column number 5. And on the basis of this we want to decide the value of View dimension.

       

      For example, If Account numbers are starting from 1, 2 or 3 then View will be 'YTD' otherwise for rest of the members View will be 'Periodic'.. In order to achieve this, we have written the below script and associated it with View dimension in Import Format.

       

      def ISMapView_All(strField,strRecord):

      strAccount = strField

      if strAccount[0:1] == "1":

      fdmResult = "YTD"

      return fdmResult

      elif strAccount[0:1] == "2":

      fdmResult = "YTD"

      return fdmResult

      elif strAccount[0:1] == "3":

      fdmResult = "YTD"

      return fdmResult

      else:

      fdmResult = "Periodic"

      return fdmResult

       

       

      But Import process itself is getting failed. Am I missing anything in above code? Any guess?

      Kindly suggest.

       

       

      Regards

      Nishant