1 Reply Latest reply on May 17, 2017 8:37 PM by Robert Gideon

    FDMEE Multi Dimension Mapping

    Moatasem Shebl

      Hello Leaders,

       

      I have a mapping case want to deal with it using the multi dimension mapping, the case as that :

       

      my basic dimension is account dimension

          

                     SourceMulti Dimension Mapping   Target
      AccountEntityDetailsAccount
      1010101100USA1010102
      1010101200USA1010103
      1010101100UAE1010104

       

       

      Thank You

        • 1. Re: FDMEE Multi Dimension Mapping
          Robert Gideon

          Is your "Details" field set up in your Target Application? If this is not already set up, you can take a look at the FDMEE admin guide about setting up a Lookup dimension. Then map the Details field in the import format to this lookup dimension (UDx). Then, in the multi dimension mapping, you can specify when Account is 1010101, Entity is 100, and UDx is "UAE", then account is 1010104.

           

          An alternative to the multi dimension map would be a SQL mapping script using Case When statements to define the mapping. That is in the admin guide under mapping script (or search for #SQL).

          1 person found this helpful