How to: Explore Data In "Quadrant"

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

This topic shows common ways to explore data by using Microsoft code name “Quadrant”.

This is the second topic in the "Quadrant" Pet Shop Tutorial.

To change viewers in "Quadrant"

  1. On the View menu, click Explorer, and then click MSPetShop4. The database opens in a new workpad.

  2. Expand the Database icon.

  3. Drag the dbo2 icon onto the workspace. A workpad named dbo2 appears, showing the tables in the MSPetShop4 database.

  4. Drag the Product icon to the workspace. This opens a workpad that displays a single table from the database. By default, the workpad uses a Table viewer.

  5. In the upper-right corner of the workpad, click the viewer switch icon (the triangle) and click Tree.

    The data is now displayed in a tree viewer. “Quadrant” includes several viewers that you can use to view data. The kind of viewer you can use depends on the kind of data that you are browsing. For example, you can view collections of data by using a table viewer, a tree viewer, a tree master/detail viewer, or a list viewer. You can view single entities by using a properties viewer, a diagram viewer, or a tree viewer.

  6. Switch the view to the other viewers (list, master/detail, and tree master/detail) to see how the same data appears in different viewers.

To use the properties viewer

  1. Switch the Product workpad view to a List viewer.

  2. Double-click the first item (Pelican). A new workpad appears that displays the data in a Properties viewer.

    Note that you can either drag a row onto the workspace, or you can double-click it. When you double-click a row, it appears in a new workpad that appears beside the parent workpad. Double-clicking saves you time, and is an efficient way to use “Quadrant”.

  3. Expand the References section of the workpad. There are two items associated with the record.

  4. Right-click Item, click View Item As, and then click Table in the context menu.

    The related records appear in a table viewer. Double-click a record to open it in a new workpad, or change the view another viewer such as the Tree viewer.

  5. Switch the view to the over viewers to see how the data appears differently. (Right-click Item and select a viewer from the list.)

To close all workpads

  • Right-click an open area on the workspace and click Close All Workpads.

In this topic, you have learned how to drag items to the workspace, and how to double-click items to view their contents. You have also learned how to switch viewers to explore the data in different ways.

The next topic is How to: Edit Data in "Quadrant".

See Also