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
(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com