Skip Headers

Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)

Part Number A95298-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Populating Workspace Data Objects, 5 of 5


Calculating and Analyzing Data

Typically, using the OLAP DML, you calculate and analyze data in the following ways:

The OLAP DML provides built-in functions for numeric analysis. The categories of these functions are described below.

Category

Description

Numeric cell-by-cell

Operate on each cell of an expression or variable.

Time series

Retrieve values from a previous or future time period and perform calculations on those values.

Statistical

Perform calculations for statistical analysis.

Financial

Perform calculations for financial analysis.

Aggregation

Return an aggregate value, generally consisting of a single value for many values of the input expression.




See Also:
  • Oracle9i OLAP DML Reference help for a categorized list of functions.
  • "Numeric Expressions" for information on working with numeric expressions.

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback