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 SQL Explorer perspective. Your VDB should now be connected via the connector bindings defined previously. Verify the connection in the Connections View.
![]()
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).
Related Topics
(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com