Infor Enterprise Performance Management OLAP Rules Engine Developer Guide (Cloud and On-premises)

Home

Back

Forward

  • Help
  • Copy URL
  • PDF
  • Print this page

Help

Copy URL

Topic URL copied to clipboard

PDF

Print

Overview of Rules Engine
General cube rules syntax
Areas
Constants
Operators
Alternate hierarchies and rules
Rules functions
Math rules functions
ABS
ACOS
ASIN
ATAN
COS
EXP
INT
ISNULL
LN
LOG
MAX
MIN
MOD
PI
ROUND
ROUNDP
SIGN
SIN
SQRT
TAN
Text rules functions
CAPIT
CHAR
CODE
DELET
FILL
INSRT
LONG
LOWER
NUMBR
SCAN
STR
SUBST
TRIM
UPPER
Date and time rules functions
DATE
DATES
DAYNO
FV
TODAY
Dimension related rules functions
CHILD
CLOSINGPERIOD
DE.CHILDNAME
DE.CHILDRENCOUNT
DE.COUNT
DE.DESCENDANTSCOUNT
DE.FIRST
DE.HSIBLING
DE.INDEX
DE.ISCHILD
DE.ISDESCENDANT
DE.LEAFCHILDRENCOUNT
DE.LEAFDESCENDANTSCOUNT
DE.LEVEL
DE.NAME
DE.NEXT
DE.PARENTNAME
DE.PARENTSCOUNT
DE.PREV
DE.SIBLING
DE.TYPE
DE.WEIGHT
DIM.TOPLEVEL
DIMIX
DIMNM
HCLOSINGPERIOD
HOPENINGPERIOD
OPENINGPERIOD
PARENT
Other rules functions
DB
GETATTR
IF
STET
Rules Engine evolution
Benefits of the pre-fetching Rules Engine
Accelerated Rules Engine
Rules, accelerators, and calculation
Restrictions
Pre-fetching Rules Engine
Rules and calculation
Best practices
Best practices to improve performance
Configuration
Leapfrog triejoin Rules Engine
Rule debugging
Activation
Output buffering
Output analysis
Example
CompleteStartMessage
CompleteStopMessage
Rules error codes
  • Links
  • docs.infor.com
  • Send Feedback on Current Topic
  • Product Support
  • Open link in new tab
  • Open link in new window
  • Copy link to clipboard