|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Defining and Working with Analytic Workspaces, 4 of 12
OLAP Worksheet is a command line interface to OLAP Services that you can use to perform the following tasks:
OLAP Worksheet has a Command Input window and an Edit window.
You can enter OLAP DML commands in the Input (query) pane at the bottom of the Command Input window. The results are displayed in the Output (result) pane at the top of the Command Input window.
This chapter describes how to use OLAP Worksheet to access analytic workspaces and execute OLAP DML commands. Refer to Chapter 9 for information about writing, editing, and debugging programs with OLAP Worksheet, as well as how to display its Edit window.
This guide provides basic information about using OLAP Worksheet. For details, refer to the OLAP Worksheet Help system.
Once you have started OLAP Worksheet, you can use its menus to establish a connection to OLAP Services, open a workspace, execute OLAP DML commands or write and debug programs, save any changes, close the workspace, and close the connection.
Use the following procedure to establish a connection to OLAP Services:
Once you have made a connection to OLAP Services, you can open an analytic workspace by entering a DATABASE ATTACH command in the Command Input window in OLAP Worksheet.
Alternatively, you can define a new analytic workspace.
For example, suppose that you have already defined a workspace named SALES that exists at the top level of the current directory. Enter the following command to open the SALES analytic workspace:
Suppose you want to define a new workspace named EXPENSE. You would enter the following commands to create the new workspace and then open it:
For more information about opening workspaces and working with more than one workspace at a time, see "Using the OLAP DML to Work with Analytic Workspaces".
When you have finished working with an analytic workspace and have saved changes, you can close it by entering a DATABASE DETACH command in the Command Input window in OLAP Worksheet.
For example, to close an analytic workspace named SALES, enter the following command:
Use the following procedure to close a connection to OLAP Services: