This section describes some Framework Manager entities.
Query
subjects
When you use Framework Manager, you work on a project that contains
a number of objects. A project contains a model, namespaces, packages, data
sources, and related information for maintaining and sharing model information.
A single project can span several data sources. The project (.cpf file) and
its associated files (defined in a .xml file) are contained in a project folder.
A query subject is a set of related query items. In most
cases, query subjects correspond to tables. The following kinds of query
subjects are used:
Data source
Data source query subjects
represent tables and views imported from data sources. Framework Manager
automatically creates a relational data source query subject for each table
and view that you import into your model.
Model
Model
query subjects represent abstracted or derived versions of underlying tables.
They are not generated directly from a data source but are based on query
items in other query subjects or dimensions, including other model query subjects.
By using model query subjects, you can create a more abstract, business-oriented
view of a data source.
Stored procedure
Stored procedure
query subjects are generated when you import a procedure from a relational
data source. User-defined stored procedures are supported, however, system
stored procedures are not supported.
Query items
A query item is the most granular element
of a model. It represents a property or field in a table, such as the date
that a product was introduced. Query items are contained in query subjects
or dimensions. For example, a query subject that references an entire table
contains query items that represent each column in the table.
Packages
A package is a subset of the dimensions, query
subjects, and other elements of a data model. Packages are used by reporting
servers to create reports and queries.
Dimensions
A dimension is a broad grouping of data
about a major aspect of a business, such as products, dates, or markets. Framework
Manager uses regular dimensions and measure dimensions.
Namespaces
A namespace is an identifier used to separate
metadata elements from different sources. You import different databases
into separate namespaces to avoid duplicate names. These namespaces are organized
in a hierarchy starting with the root level. There are three layers under
the root level: physical , consolidate view, and business view