OLAP Cube Dialog Box

English Query

English Query

OLAP Cube Dialog Box

Use this dialog box to display the dimensions and measures, including database properties such as tables, fields, and units of measure, associated with a cube.

Options

Is virtual

Indicate whether the cube is virtual. A virtual cube can be either a combination of multiple cubes in one logical cube, somewhat like a relational database view that combines other views and tables, or a cube based on a single cube that exposes only selected subsets of its measures and dimensions.

Fact Table

Specify the fact table associated with the cube.

Dimensions

Select the dimensions associated with the cube.

Measure

Display and modify the measures in the cube. The Primary Key icon indicates the default measure.

Aggregation

Indicate the type of aggregation, precalculated summary data used to create the units of measure.

Units

Specify (in singular, rather than plural form) the units of measure in which the measure data is stored (for example, year, inch, or kilometer).

Field

Display the fields and synonyms underlying the specified level.

See Also

Icons and Cursors Used in English Query