3 Replies Latest reply on Aug 12, 2010 2:57 PM by TonyScalese

    More complicated FDM conditional mapping

    Vladislav
      Hi friends,
      I would like to know what is the easiest way to do the following:

      1) I have these 5 source accounts and its values:
      34301 -123
      34302 500
      34303 200
      34304 -80
      34305 -300

      2) I create one LogicAccount witch accumulates these 5 values:
      LA343_Total 197

      3) I NEED to define conditional mapping for all 5 source accounts
      if LA343_Total >=0 Then mapp all source accounts to HFM account 343100
      if LA343_Total <0 then mapp all source accounts to HFM account 343200

      Please help if you know how to do it.
      Thank you
      Vladislav
        • 1. Re: More complicated FDM conditional mapping
          TonyScalese
          I would create a second set of logic accounts (in your existing logic group) for each of the individual accounts and then use a like map to map as you described below.

          When you add these lines to your existing logic group, just be sure to give them a sequence order greater than the logic account that creates the LA343_Total account.

          The like map can use varvalues(13) to read the LA343_Total account. Check the admin guide for help on conditional mapping.
          • 2. Re: More complicated FDM conditional mapping
            Vladislav
            This sounds good, but I dont understand last step. How can I read LA343_Total value during source account mapping? varValues(13) includes only current source account code (34301, 34302...34305).
            My map includes "like" rule 343* and I need write #script. Somethign like this:

            If |LA343_Total| >= 0 then
            Result = "343100"
            else
            Result = "343200"
            End if

            BUt this doesnt work. This syntax "|LA343_Total|" is not supported.
            Thank you
            • 3. Re: More complicated FDM conditional mapping
              TonyScalese
              Look for this text in the admin Guide: "Conditional Mapping Example".

              Logic groups are executed before mapping is applied so the LA_343 account will exist in your source data.

              Also, please take a look at this post: http://forums.oracle.com/forums/ann.jspa?annID=1184