Home > Data Modeler Dialog Boxes > 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