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