Show TOC

Function documentationLibrary of SQL Functions Locate this document in the navigation structure

 

Planning and Consolidation supplies SQL functions that you can use in your advanced rules formulas, including:

  • ROLLTOBS

  • ACCUMULATE

  • TRANSLATE_LDI

  • CALC_MOVEMENT

  • CALCULATE_TOTAL_AND_COMMIT

  • FX_OVERRIDE

  • FX_OVERRIDE_RATE

  • FX_OVERRIDE_NOZERO

  • TRANSLATE_PROFIT_AND_COMMIT

  • CARRYFORWARD_AND_COMMIT

  • DERIVE_YTD

The Allowed Uses categories are:

Category

Description

BY COMMIT

The *COMMIT keyword separates the logic script as a unit that is calculated together. In other words, a logic script block enclosed by *COMMIT is calculated and handled at one time. The next *COMMIT block is calculated afterwards.

So, if a logic instruction is BY COMMIT, the instruction is only effective in one single commit block. In the next commit block, the user can set another value of that instruction.

GLOBAL

Global is effective in the entire logic script. While BY COMMIT is only effective in a single COMMIT block, GLOBAL is effective in all lines of the logic script.

MDX

MDX is used in MDX logic.

SQL

SQL is used in SQL logic.