List of Tables

1-1 Syntax for Specifying and Retrieving Option Values

1-2 OLAP Data Object Definition Statements

1-3 Commands for Defining Calculation Specifications

1-4 Statements for Viewing Definitions

2-1 OLAP DML Data Types

2-2 OLAP DML Numeric Data Types

2-3 OLAP DML Text Data Types

2-4 Recognized Escape Sequences

2-5 OLAP DML Date Data Types

2-6 OLAP DML Operators

2-7 Arithmetic Operators

2-8 Comparison and Logical Operators

2-9 Objects in Expressions

2-10 Legal Operations for Dates

2-11 Boolean Expressions with NA Values that Result in non-NA Values

5-1 Statements For Determining Flow-of-Control

5-2 Names of Permission Programs for Different Attachment Modes

5-3 Trigger Program Characteristics

5-4 Arguments Passed to Trigger Programs

5-5 How Programs Triggered by Maintain Events Effect Dimension Status

6-1 Aggregation Methods

7-1 Keywords for the choice Parameter of the AGGMAPINFO function

7-2 Geography Hierarchy

7-3 Characters for Specify the Contents of the Error Log for ALLOCATE

7-4 Allocation Operators

8-1 Keywords for AW Function

9-1 Keywords for the type Argument of the CONVERT Function

9-2 Syntax for Specifying How Conversion of TEXT, NTEXT, ID, DATE, and INFILE are Performed

9-3 Values for escape-int Argument of the CONVERT

9-4 DATEFORMAT Templates for Day

9-5 DATEFORMAT Templates for Week

9-6 DATEFORMAT Templates for Month

9-7 DATEFORMAT Templates for Year

10-1 Valid Data Types for Variables

10-2 OLAP DML Statements for Aggcount Variables

12-1 Options That You Can Specify for the Entire Forecast

12-2 Options That You Can Specify for an Individual Trial

12-3 Types of Errors Returned by FILEERROR

13-1 File Attributes Returned by FILEQUERY

13-2 File Attributes

13-3 Values for ORIGIN Clause of FILESET

13-4 Effect of NASKIP When Loan or Rate Values are NA for a Time Period

14-1 Character-Group Specifications for IMPORT from Text

15-1 Choices for All Methods

15-2 Choices for TREND and EXPONENTIAL Forecasts

15-3 Choices for WINTERS Forecasts

15-4 INFO (MODEL) Choices to Retrieve General Information About the Model

15-5 INFO (MODEL) Choices to Retrieve Information about the Structure of the Model

15-6 INFO (MODEL) Choices to Retrieve Information about Target, Sources, and Dependencies

15-7 INFO (MODEL) Choices to Retrieve Information About Execution Status

15-8 INFO PARSE Keywords

15-9 INFO REGRESS Keywords

18-1 Time Zones

18-2 OLAP DML NLS Options

19-1 Valid dimname and dimexp Combinations for Concat Dimensions

20-1 Methods for Computing RANK

20-2 Results of Different Methods of Ranking

20-3 Valid Values for REDO specifier

20-4 Valid Values for REEDIT specifier

20-5 Formal Attributes for Data Values in a Report

21-1 Format Models for ROUND for Dates and Time

21-2 Column Attributes for ROW

21-3 Row and Column Arithmetic

21-4 Report-Related Options

21-5 OLAP DML Statements That Are Compatible with the ROW Command

21-6 Using Objects in Assignment Statements

22-1 RDBMS Data Type Conversion to OLAP DML Data Types

22-2 Automatic Data Type Conversion During Direct-Path Insertion

22-3 Keywords for STATLIST

23-1 Compatible Aggregation and Allocation Methods

23-2 Examples of Conversion Methods for Different Types of Financial Data

23-3 Possible Effects of Rounding

24-1 Subevents for the AW Event

24-2 Subevents for the MAINTAIN Event

24-3 Subevents for UPDATE Events

24-4 Format Models for TRUNC for Dates and Time

24-5 How NASKIP Affects the Results When a Loan or Rate Value is NA for a Given Time Period

24-6 Basic Codes for Components in VNF Templates

24-7 Component Combinations Allowed in VNF Templates

24-8 Format Styles for Day Available in VNF Templates

24-9 Format Styles for Month Available in VNF Templates

24-10 Format Styles for Year Available in VNF Templates

24-11 Format Styles for Period Available in VNF Templates

24-12 Default VNFs for DAY, WEEK, MONTH, QUARTER and YEAR Dimensions

A-1 System Properties Used When Aggregating or Allocating Data

A-2 System Properties Used When Working with NA Values

A-3 Options Related to Working with Analytic Workspaces

A-4 Multi-language Support Options

A-5 Aggregation Options

A-6 Allocation Options

A-7 Model Options

A-8 Compilation Options

A-9 Error Handling Options

A-10 Debugging Options

A-11 Embedded SQL Options

A-12 File Reading and Writing Options

A-13 EIF Options

A-14 Report Options

A-15 NA and Nonexistent Value Options

A-16 Date and Time Options

A-17 Numeric Options

A-18 Options for Monitoring RANK

A-19 General System Statements

A-20 Workspace Object Data Definition Statements

A-21 OLAP DML Statements for Extending Object Definitions

A-22 Statements for Creating and Managing Analytic Workspaces

A-23 Statements for Managing Objects When Attached in Multiwriter Mode

A-24 Data Type Conversion Functions

A-25 Assignment Statements

A-26 Statements for Working with NA Values

A-27 General Character Functions

A-28 Byte Functions

A-29 MultiLine Text Functions

A-30 Date and Time Functions

A-31 General Numeric Functions

A-32 Financial Functions

A-33 Statistical Functions

A-34 Time-Series Functions

A-35 Aggregation Functions

A-36 Statements for Simple Forecasts and Regressions

A-37 Statements for Forecasting Using a Forecasting Context

A-38 General Aggregation Statements

A-39 General Allocation Statements

A-40 Workspace Object Operation Statements

A-41 Dimension and Composite Operation Statements

A-42 Statements for Formulas

A-43 General Modeling Statements

A-44 Statements for Handling Programs

A-45 Statements Used Only in OLAP DML Programs

A-46 Statements Used Primarily in OLAP DML Programs

A-47 OLAP DML Program Debugging Statements

A-48 Statements for Working with Startup and Trigger Programs

A-49 File Reading and Writing Statements

A-50 Statements for Importing and Exporting Data

A-51 Reporting Statements

A-52 Statements Related to OLAP_TABLE