Technical data

CHAPTER 10

Creating Rules, Formulas, and User Functions

This chapter provides overviews of rules, formulas, and user functions, filter user functions, and design time rule error

messages and discusses how to:

• Define and edit data cube formulas.

• Define and edit user functions.

• Work with the elements of rules.

• Perform exceptions to the rule.

• Work with circular formulas and circular systems.

Understanding Rules, Formulas, and User Functions

This se ction lists common elements and discusses rules, formulas, and user functions and the rule bar display.

Common Elements Used in This Chapter

Insert a plus symbol into the rule.

Insert a minus symbol into the rule.

Insert a multiplication symbol into the rule.

Insert a division symbol into the rule.

Insert an e

xponent symbol into the rule.

Insert a left parenthesis into the rule.

Insert a ri

ght parenthesis into the rule.

Insert a less than symbol into the rule.

Insert a greater than symbol into the rule.