Framework Manager entities

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

Feedback