|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Basic Concepts, 4 of 6
OLAP Worksheet is an interactive interface to Oracle OLAP that you can use to perform the following tasks:
OLAP Worksheet has a Command Input window and a program Edit window.
You can enter commands in the query (input) pane at the bottom of the command input window and see results in the response (output) pane at the top.
Once you have opened OLAP Worksheet, you can use it to establish a connection to Oracle OLAP, open a workspace, execute OLAP DML commands or write and debug programs, save any changes, close the workspace, and close the connection.
The following procedures identify menu choices that you can use to do various tasks. You may prefer to use the icons on the left side of the window, which provide a short-cut to some of the tasks.
You can open OLAP Worksheet either from Oracle Enterprise Manager or from the operating system command line.
To open OLAP Worksheet from Oracle Enterprise Manager, take these steps:
On Unix, to open OLAP Worksheet from the command line, take these steps:
binsubdirectory of the OLAP Worksheet installation directory.
On Windows, click the OLAP Worksheet icon that was created during installation.
Take these steps to establish a connection to Oracle OLAP:
You see the Login to Database box.
In the Service box, type the identification of the Oracle database, in the following format:
Oracle controls your access to data on the basis of your database user ID. Your user ID must have access rights to the analytic workspaces and relational tables that you want to use in OLAP Worksheet, or you will get an error when you try to access them.
You can execute OLAP DML commands and SQL statements in the Command Input window of OLAP Worksheet.
By selecting different options in the Options menu, you can specify whether you want to execute OLAP DML commands or SQL statements. You can also specify whether you want commands executed individually or saved in a buffer and executed together.
Or, to save the commands in a buffer, clear Execute on Enter. Then, to execute all of the commands that you have entered in the query pane, choose Execute from the View menu.
Be sure to locate your cursor in the query pane before you start to type. If you want to break a long command into several lines, you can continue the command on the next line by typing a continuation character (
-) at the end of the current line.
When the SQL option is ON, just type in the SQL statements and press Enter. Do not terminate SQL statements with a semicolon. If you do, you will get an error.
You can open a DML program in an Edit window so that you can add or modify program content. You can have multiple Edit windows open simultaneously, but an object definition can appear in only one Edit window at a time.
In addition to using the Edit window to work on a program, you can use it to edit a model or an aggregation map.
To edit a program, follow these steps:
object_name is the name of a DML program object that already exists. Use the
DEFINE command to create a new program object. If you want to edit a model or an aggregation map, type
AGGMAP before the object name.
UPDATEcommand, which updates all the changes that have been made in the analytic workspace up to this point.
Chapter 7, "Developing Programs" for more information about DML programs.
Use the following procedure to close a connection to Oracle OLAP:
When you disconnect, OLAP Worksheet executes a
COMMIT command before ending your session. If you have executed the
UPDATE command or chosen Save from the File menu of an Edit window before disconnecting, then the changes that you made before the update are made permanent. Otherwise, they are discarded. Any changes that you have made after the update are discarded when you disconnect.