Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)

Part Number A86720-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

Working with Models, 7 of 8


Debugging a Model

How do you debug a model?

You debug a model in much the same way that you debug an OLAP DML program. There are two main methods for debugging OLAP DML programs. As outlined below, the method that you use depends on the degree of debugging that you want to perform.

Method 

Description 

Debugging file 

Creates a debugging file that logs the progress of a program execution so you can analyze it for errors. 

OLAP DML debugger 

Allows you to interactively step through programs one line at a time and displays the current values of OLAP DML objects. The OLAP DML debugger is used from within OLAP Worksheet. 

For more information on debugging in the OLAP DML, see Chapter 9.

Tools for debugging models

The OLAP DML provides an assortment of tools that will help you debug your models. You use these tools in OLAP Worksheet. These tools are listed in the following table.

Tool 

Purpose 

MODTRACE 

An option that controls whether each line of a model is displayed while you run the model. When MODTRACE is set to YES, the model lines are displayed, and you can observe the order in which the equations are solved. 

TRACE 

A command that lets you step through the model line by line or block by block. At each step, model execution is suspended so that you can type special debugger commands or any other OLAP DML commands to examine the model environment. The debugging environment and the TRACE command are available only when you are using OLAP Worksheet. 

WATCH 

A command that lets you monitor the value of specific assignment targets in a model. Each time the target is assigned a new value, this value is displayed. The debugging environment and the WATCH command are available only when you are using OLAP Worksheet. 

MODEL.COMPRPT 

A program that produces a report on the structure of a compiled model. The report shows how model equations are grouped into blocks.  

MODEL.DEPRPT 

A program that produces a report on the dependencies in model equations. The report lists the assignment target and data sources for each equation and specifies any dimensions of the dependencies in the equation.  

MODEL.XEQRPT 

A program that produces a report on the solution status of a model. If the model contains simultaneous equations, then the report specifies the values of the options that control simultaneous solutions.  

INFO 

A function that lets you obtain specific information about a model that you have compiled or executed.  

Related information

For more information, see the following table.

IF you want documentation about . . .  THEN see . . . 

the programs that produce debugging reports, 

the entry for the MODEL command in the OLAP DML Reference 

using the TRACE and WATCH commands, 

the entry for the command in OLAP DML Reference

Chapter 9 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, 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