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. |