1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Planning Formula Expressions
  4. SmartLists

SmartLists

You can include a Smart List as a variable in a formula expression, such as the formula expression, "Product Channel"=[[Channel.Retail]].

"Product Channel" is the account with type "Smart List", Channel is the Smart List name, and Retail is a Smart List entry. If the Smart List ID for Retail is 2, Channel.Retail is replaced with a 2 in the member formula (the application treats Smart Lists as numbers). If the Smart List ID for Retail is 2, 2 is put in the calculation, and 2 is stored in the database.

Calculation Manager Syntax:

[[SLName.entryname]]

Example:

The following syntax:

FIX (Mar, Actual, Working, FY15, P_000, "111") 
   "Product Channel" =[[Channel.Retail]] ;
ENDFIX

returns the following script:

FIX (Mar, Actual, Working, FY15, P_000, "111") 
   "Product Channel" =2 ;
ENDFIX