Technical data

Contents
Chapter 10
Creating Rules, Formulas, and User Functions................................................ .......111
Understandin
g Rules, Formulas, and User Functions.....................................................
.......111
Common Elements Used in This Chapter......................................................................111
Rules, Formulas, and User Functions................................ .. .. ..................... .. .. .............112
Filter User F
unctions.......................................................................................
.......113
Rule Bar Display...................................................................................................114
Understanding Rule Error Messages.. ...................................................................... .......114
Defining an
d Editing Data Cube Formulas..................................................................
.......119
Defining and Editing User Functions......................................................................... .......119
Working with the Elements of Rules......................................................................... .......120
Understan
ding the Elements of Rules...................................................................
.......120
Inserting a Built-in Function into a Rule.........................................................................128
Inserting a User Function into a Rule... ........................................................................128
Insertin
g a Numeric Value or Text Value into a Rule...................................................
.......128
Inserting a Data Cube Reference into a Rule..................................................................129
Inserting a Dimension Reference into a Rule..................................................................129
Insertin
g a Dimension Member Reference into a Rule................................................
.......129
Inserting a Blank Line into a Rule...............................................................................130
Inserting a Comment into a Rule................................................................................130
Perform
ing Exceptions to the Rule...........................................................................
.......130
Understanding Exceptions to the Rule..........................................................................131
Create Different Calculations for Different Members..........................................................131
Creati
ng Different Calculations for Different Groups of Members... .................................
.......133
Working with Circular Formulas and Circular Systems.................................................... .......134
Understanding Circular Formulas... ...................... ............................... .. .. ...................134
Under
standing Circular Systems and Recursive Systems.......................... .. ......... .. .....
.......135
Understanding Recursive System Resolution............................ .. ...... .. ........ ...................135
Understanding Circular System Resolution. ...................................................................135
Chan
ging Circular Formula and Circular System Options............................................
.......136
Chap
ter 11
Using Built-in Functions in Analytic Models................................................... .......139
Built-in Function Reference................................................................................... .......139
ABS
...........................................................................................................
.......139
ACOS...............................................................................................................139
ARGUMENTS Declaration.......................................................................................140
ASC
...........................................................................................................
.......140
ASIN.................................................................................................................141
Copyright © 1988-2007, Oracl e. All rights reserved. ix