Testing Your VDB

In Dimension Designer you can execute a VDB to test/query actual data. (see Virtual Database Summary ). To execute a VDB, follow the steps below:

> Step 1: In the VDB Explorer, click on the Test Sources and Views icon to switch to the SQLExplorer perspective.

> Step 2: In the Database Structure View (upper left), expand the Table node to list the tables in your VDB.

> Step 3: Select one of the tables and do a right click. Select the ‘Generate Select in SQL Editor’ menu item.

> Step 4: A SELECT statement will appear in the editor (upper right).

> Step 5: Click the Execute SQL icon to run the SQL. Results will appear in the SQL Results tab (lower right).

> Step 6: A SELECT statement will appear in the editor (upper right).

Related Topics

> What's a VDB?

> Create a New VDB

> Web Service Advisor View

> Getting Started with Metamatrix Dimension

(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com