Slice Properties

This dialog box displays the properties of a slice of a cube in a multidimensional model. For more information about working with multidimensional data, see Oracle OLAP User's Guide and the online help for Analytic Workspace Manager.

General

Name: Name of the slice.

Read Only: Controls whether the data in the slice is read-only.

Measures

Calculated measures can add information-rich data to a cube. The data set is calculated on the fly, so no data is stored. You can add as many calculated measures as you like without increasing the size of the database.

Dimensions, Levels

Lists any dimension/hierarchy/level combinations for the slice. To add a level, click the Add (+) icon; to remove a level from the slice definition, select it and click the Remove (X) icon. (See also Level Properties.)

Selected Attributes

Lists any dimensions for the slice. To add a dimension, click the Add (+) icon; to remove a dimension from the slice definition, select it and click the Remove (X) icon. (See also Dimension Properties.)

Slice to Entity Mappings

Lists any attributes and their mappings for a specified entity.

Selection Criteria

Lets you specify one or more selection criteria (name, WHERE clause, and other details for each).

Oracle Names

Short Name: Short descriptive name that can be used by applications instead of the long name.

Long Name: Long descriptive name, typically used for display.

Plural Name: Plural name (for reporting purposes). For example: Myslices if the Short Name is Myslice

SQL Access to Oracle AW

Lists any relevant SQL Access to Oracle Analytic Workspaces (AW) objects. To add a SQL Access to Oracle AW object, click the Add (+) icon; to remove a SQL Access to Oracle AW object from the slice definition, select it and click the Remove (X) icon. To edit a SQL Access to Oracle AW object, double-click its item, or click its item and click the Properties icon. (See also SQL Access to Oracle AW Properties.)

Description

Description of the slice.

Comments, Notes, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.