Data source icons

Package, which contains the objects you can insert in a report.

Namespace, used to organize objects.

Query subject, which represents a table in the database.

In relational data sources, query item, which represents a column of qualitative data in the database, such as product name or country or region.

In dimensional data sources, level attribute, which represents a property of a level.

A member is a unique item within a hierarchy. For example, Camping Equipment and 4 Man tent are members of the Products Hierarchy.

Dimension, which represents a broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets.

Hierarchy, which represents a collection of dimensional members organized into a tree structure.

Level, which is a set of members that have common attributes. For example, a geographical dimension might contain levels for country or region or city.

Multiple levels can exist within a level hierarchy, beginning with the root level. The root level is the parent and rollup of all members in the first level. It is used to obtain a rollup of all values across the hierarchy and to provide a convenient point to start drilling.

For example, a Years level hierarchy may contain the following levels:

• Root level Years

• First level Year

• Second level Quarter

• Third level Month

Measure or fact, a query item that represents a column of quantitative data in the database, such as revenue or quantity, in a relational model.

Measure or fact, a query item that represents a column of quantitative data in the database, such as revenue or quantity, in a dimensional model.

Measures folder, which contains hierarchical measures, in a dimensional model.

Model filter.

Model calculation.

Folder, used to organize data items. You cannot import a folder into your report.