With the acquisition of Hyperion Systems , Oracle finds itself owning the two most capable OLAP products on the market--Essbase and the OLAP Option to the Oracle Database. Written by the most knowledgeable experts on both Essbase and Oracle OLAP, this Oracle Press guide explains how these products are similar and how they differ. Oracle Essbase & Oracle OLAP will help you architect the Oracle OLAP product that is most appropriate for your application, and build, tune, and maintain OLAP solutions.[hide][/hide]

Table of contents :
Contents......Page 3
Send Us Your Comments......Page 27
Documentation Accessibility......Page 29
Structure......Page 30
Related Documents......Page 31
Conventions......Page 32
Part I Using the OLAP DML......Page 33
Basic Syntactical Units......Page 35
Categories of Options......Page 36
OLAP DML Properties......Page 37
OLAP DML Functions......Page 38
Statements for Creating Analytic Workspaces......Page 39
Defining Analytic Workspace Objects......Page 40
Defining Data Objects Using the OLAP DML......Page 41
Types of Calculation Specifications......Page 42
Creating Calculation Specification Objects......Page 43
OLAP DML as a Data Manipulation Language......Page 44
ONATTACH Programs......Page 45
TRIGGER_AW Program......Page 46
File-Reading Programs......Page 47
Trigger Programs......Page 48
Aggregation, Allocation, and Modeling Programs......Page 49
Programs to Export and Import Workspace Objects......Page 50
OLAP DML Data Types......Page 53
Using LONGINTEGER Values......Page 54
Text Data Types......Page 55
Boolean Data Type......Page 56
Date and Time Options......Page 57
Calculating Dates......Page 58
OLAP DML Operators......Page 59
Arithmetic Operators......Page 60
Assignment Operator......Page 61
Introducing OLAP DML Expressions......Page 63
Changing the Data Type of an Expression......Page 64
Syntax for Specifying an Object in an Expression......Page 65
When Not to Use Qualified Object Names......Page 67
How Objects Behave in Expressions......Page 68
Using Variables in Expressions......Page 69
Using Variables Defined with Composites in Expressions......Page 70
Dimensionality of OLAP DML Expressions......Page 71
How Dimension Status Affects the Results of Expressions......Page 72
Numeric Options......Page 73
Automatic Conversion of Numeric Data Types......Page 74
Using Dates in Arithmetic Expressions......Page 75
Limitations of Floating Point Calculations......Page 76
Text Expressions......Page 77
Boolean Expressions......Page 78
Creating Boolean Expressions......Page 79
Comparing NA Values in Boolean Expressions......Page 80
Controlling Errors Due to Numerical Precision......Page 81
Controlling Errors When Comparing Different Numeric Data Types......Page 82
Comparing Dimension Values......Page 83
Comparing Text Data......Page 84
Comparing Text Literals to Relations......Page 85
Conditional Expressions......Page 86
Substitution Expressions......Page 87
Specifying a Value of NA......Page 88
Controlling how NA values are treated......Page 89
Working with the $NATRIGGER Property......Page 90
Using NAFILL......Page 91
Working with Dimension Status......Page 92
Changing the Status List of a Dimension......Page 93
Specifying a Single Data Value in an Expression......Page 94
Qualifying a Variable......Page 95
Replacing a Dimension in a Variable......Page 96
Qualifying a Relation......Page 97
Using Ampersand Substitution with QDRs......Page 98
Using the QUAL Function to Specify a QDR......Page 99
Formulas......Page 101
Aggregations......Page 102
Aggregating Data......Page 103
Executing the Aggregation......Page 104
Creating Custom Aggregates......Page 106
Allocations......Page 107
Allocating Data......Page 108
Handling NA Values......Page 109
Creating Models......Page 110
Nesting Models......Page 111
Using Data from Past and Future Time Periods......Page 112
Solving Simultaneous Equations......Page 113
Compiling a Model......Page 114
Running a Model......Page 115
Dimensions of Solution Variables......Page 116
Solution Variables Dimensioned by a Composite......Page 117
Debugging a Model......Page 118
Creating OLAP DML Programs......Page 119
Creating User-Defined Functions......Page 120
Using Multiple Arguments......Page 121
Passing Arguments as Text with Ampersand Substitution......Page 122
Looping Nature of OLAP DML Commands and Functions......Page 123
Flow-of Control Commands......Page 124
Changing the Program Environment......Page 126
Saving the Status of a Dimension or the Value of an Option......Page 127
Handling Errors......Page 128
Suppressing Error Messages......Page 129
Handling Errors in Nested Programs......Page 130
Compiling Programs......Page 131
Testing and Debugging Programs......Page 132
Error and Debugging Options......Page 133
Sending Output to a Debugging File......Page 134
Executing Programs......Page 135
Part II Alphabetic Reference......Page 137
6 $AGGMAP to AGGMAP......Page 139
$AGGMAP......Page 141
$AGGREGATE_FROM......Page 143
$AGGREGATE_FROMVAR......Page 145
$ALLOCMAP......Page 147
$COUNTVAR......Page 149
$NATRIGGER......Page 151
$STORETRIGGERVAL......Page 156
$VARCACHE......Page 158
more........
Part III Appendixes......Page 1839
A Functions and Commands by Functional Category......Page 1841
Session Statements......Page 1842
Assignment Statements......Page 1843
Text Functions......Page 1844
General Character Functions......Page 1845
Byte Functions......Page 1846
Multiline Text Functions......Page 1847
Date and Time Functions......Page 1848
General Numeric Functions......Page 1850
Financial Functions......Page 1852
Statistical Functions......Page 1853
Time-Series Functions......Page 1854
Aggregation Functions......Page 1855
Statements for Forecasting Using a Forecasting Context......Page 1856
Aggregation Statements......Page 1857
Allocation Statements......Page 1858
Dimension and Composite Operation Statements......Page 1859
Modeling Statements......Page 1861
Statements for Handling Programs......Page 1862
Statement Used Only in Programs......Page 1863
Statements Used Primarily in Programs......Page 1865
Statements for Working with Startup and Trigger Programs......Page 1866
File Reading and Writing Statements......Page 1868
Reporting Statements......Page 1869
Statements Related to Using OLAP_TABLE in SQL......Page 1870
Statements Added......Page 1873
Statements Deleted......Page 1876
Statements Significantly Changed......Page 1878
Statements Renamed......Page 1879
A......Page 1881
B......Page 1883
C......Page 1884
D......Page 1886
E......Page 1888
F......Page 1889
I......Page 1891
L......Page 1892
M......Page 1893
N......Page 1894
O......Page 1895
P......Page 1896
R......Page 1898
S......Page 1899
T......Page 1901
V......Page 1903
Z......Page 1904