Gaining Access to a Workspace from OLAP Worksheet

What is OLAP Worksheet?

OLAP Worksheet is a command line interface to OLAP Services that you can use to perform the following tasks:

• Access an analytic workspace

• Execute most OLAP DML commands

• Edit programs

• Debug programs

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.

Overview of accessing a workspace

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.

Establishing a connection

Use the following procedure to establish a connection to OLAP Services:

1. In the OLAP Worksheet menu bar, choose File.

2. Choose Connect.

3. Enter valid user credentials and information in the Login dialog box that appears.

Opening the workspace

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:

database attach sales

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:

database create expense
database attach expense

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".

Closing the workspace

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:

database detach sales

Closing the connection

Use the following procedure to close a connection to OLAP Services:

1. In the OLAP Worksheet menu bar, choose File.

2. Choose Disconnect.

3. When prompted to disconnect, choose Yes.