Does PFT Support Use of Expressions in Outputs For Any Type of Allocation Rule?

(Doc ID 2414982.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

There is requirement to verify two columns' value and place the lowest value in the Target (i.e. if C1>C2 then C2 else C1).

The same has been created in an Expression with an IF clause (see below).

The following needs to be clarified:

  1. How can this expression be placed in the allocation while selecting the Target column as C3 in Output (no source is required in this case as assumed)?
  2. Which allocation type would best suit the requirement: Dynamic Driver, Simple Driver or any Lookup?
  3. Please suggest the best approach for this requirement. Can this be handled in T2T?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms