DB2 graphic  QMF Version 8

Using workbooks

A workbook provides a filtered view of your database, including only those database objects that you want to use in your QMF Visionary world. You can select tables, views, synonyms, functions, and procedures. The figure below illustrates an unfiltered view of a database versus a workbook.

Figure 4. Database vs. workbook

Suppose you share a database with other departments of your company. The database probably contains some information that is not relevant to the business analysis you want to illustrate in your QMF Visionary world. Creating a QMF Visionary workbook allows you to tailor the view of the database to your focused needs.

There are three types of workbooks:

A default workbook provides an unfiltered view of the database. QMF Visionary automatically creates a default workbook when you connect to a database. A default workbook is dynamic; QMF Visionary Studio re-creates it whenever you start QMF Visionary Studio instead of opening a saved workbook file. These workbooks can be quite large, with long lists of tables that make it difficult to find the tables you need. After you create a custom workbook, disable default workbooks by clicking Tools --> QMF Visionary Options and clearing the default workbook option on the Login page.

A custom workbook provides a filtered view of the database. You create a custom workbook using the Workbook wizard. You select only those tables, views, synonyms, procedures, and functions that are useful to you. For instructions on creating a custom workbook with the Workbook wizard, see the DB2 QMF Visionary Getting Started Guide.

A QMF workbook provides a list of the QMF queries for the selected QMF data source.

The figures below show two workbooks (on the Worlds page of the World Manager). The qademo workbook is a default workbook that shows the full contents of the database.

Figure 5. Default workbook (qademo)

The Auto_Summary workbook is a custom workbook that shows only those tables and views that are needed to create a QMF Visionary world that summarizes and analyzes auto sales.

Figure 6. Custom workbook (Auto_Summary)


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004