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, 2 of 5


Overview: Populating an Analytic Workspace

To use an analytic workspace, there must be data in it. There are two basic types of data: fact data and dimensions. Fact data is stored in variable workspace objects; dimensions, containing dimension values, are stored in dimension workspace objects.

Variables and dimensions can be populated:

To explicitly populate data objects in an analytic workspace, take the following steps:

  1. Specify the values for each dimension. These values provide indexes to the actual data, which is stored in analytic workspace variables.
  2. Specify the values for each relation. These values indicate the relationships between dimensions.
  3. For variables that provide the source data for your application, specify the actual data values.

You can populate an analytic workspace using programs written using the SQL command and data loading commands. The OLAP DML commands that you typically use to populate data objects are listed in the following table.

Command

Description

= or SET

Assigns the results of an expression to a variable, option, or relation. For more information, see "Assigning Values to Data Objects" and "Using Models to Calculate Data".

MAINTAIN

Adds, deletes, renames, moves, or merges values in a dimension; and adds, deletes, and merges values in a composite. For more information, see "Maintaining Dimensions and Composites".

FILEREAD

Stores the data that is read from an input file into a dimension, composite, relation, or variable. For more information, see Chapter 11, "Reading Data from Files".

SQL

Retrieves data from relational tables into a dimension or variable. For more information, see Chapter 10, "Working with Relational Tables".

IMPORT

Copies workspace data and definitions from an EIF file.




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