Technical data

Creating Cube Collections Chapter 7
Dimensions tab
Dimensio
n
Displays the name of the dimension.
Persist Aggregate
Display
s any aggregates that are persisted for the dimension.
Filter
Displays the filter formula that is applied to the dimension.
Sort Type
Displays the sort type that is applied to the dimension’s values.
Sort #1
If the dimension values are sorted by key, displays the first key field by which
the dimension member values are sorted.
Sort #1 Order
If the dimension member values are sorted by the first key, displays whether
the sort is by ascending or d escending order.
Sor
t#2
If the dimension member values are sorted by key, displays the second key
field by which the dimension member values are sorted.
Sort #2 Order
If
the dimension member values are sorted by a second key, displays whether
th
e sort is by ascending or descending order.
Sort #3
If the dimension member values are sorted b y key, displays the third key field
by which the dimension member values are so rted.
Sort #3 Order
If the dimension member values are sorted by k ey, displays whether the sort is
by ascending or descending order.
62 Copyright © 1988-2007, Oracl e. All rights reserved.