MMHeader

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 Run VDB 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