Technical data
Viewing and Debugging Analytic Models Chapter 14
Filter/Sor
t Criteria window
Members are only filtered when the filter condition is met. In addition, if an aggregate member is filtered, all
its children are also filtered.
Select Dim
ension
Select the dimension upon which you want to base the filter or sort.
Select Filter
Select th
e filter.
Apply Filter
Apply the selected filter.
Clear Filter
Clear the selected filter.
Sort
Select whether to sort by key, by name, or by neither. When you elect to sort
by key, you can choose from one to three keys upon which to sort, and can
choose to sort each one of those keys either ascending or descending. When
you sort by name, you can choose to sort either ascending or descending.
Apply Sort
Apply the selected sort.
Clea
rSort
Clear the selected sort.
Return
Go back to the main page.
Viewing and Debugging Data Cubes
This section discusses how to:
•Vie
w data cubes and data cube propertie s.
•Deb
ug data cubes.
See C
hapter 5 , “Creating Data Cubes,” page 31.
Viewing Data Cubes and Data Cube Properties
Acc
ess the Analytic Model Viewer and select a data cube whose properties you want to view:
The a nalytic grid underneath the Cube Properties panel displays the data cube’s values. As with cube
collections, you ca n use drag and drop to manipulate this grid. You can also view slices of your data by
choosing from the drop-down lists of dimensions.
236 Copyright © 1988-2007, Oracl e. All rights reserved.