Home > OLAP Dialog Boxes and Wizards > Cube Data Viewer
![]() Previous |
![]() Next |
Use the Cube Data Viewer to see the data as it appears in applications for end users. The view consists of the query and the returned values.
Select the parameters of your query.
Run: Click this button on any subpage after selecting the measures and dimensions for the query.
Measures
Measure Filter: Enter text to find matches in the Measure Name column. The filter is not case-sensitive, and so sales
matches sales
, Sales
, SALES
, and sAlEs
.
Measure Selection: Select the check box next to the Select heading to display all measures and calculated measures, or select the individual measures and calculated measures of interest. Each measure and calculated measure in the cube is described by its object name and description. Calculated measures are also described by the expression.
Dimensions
Specify the selection of data to display by identifying the level or depth of each dimension in the cube.
Complete the template for each dimension in the cube:
For dimension dimension show data for the level level and above in the hierarchy hierarchy.
For example: For TIME dimension show data for the CALENDAR_QUARTER level and above in the CALENDAR hierarchy.
Get the first n rows only: Enter the number of rows to be displayed. You can change the initial value (200 rows) on the OLAP Preferences dialog box.
Query
Shows the SQL SELECT
command for fetching the data.
Shows the results of executing the query.
Graph
Displays the data in a graphical format. A tool bar enables you to make temporary changes to the graph. The text tools are disabled. You can use these tools:
Fill Color: Changes the background color surrounding the graph.
Graph Type: Provides a variety of standard graph types, as described in Table: Partitioning Graph Types.
Show Legend: Controls whether the legend is displayed.
Grid Lines: Controls whether horizontal grid lines are displayed on graphs with an X/Y axis.
Gradient Effect: Controls whether colored areas appear solid or with a slight variation in color.
3-D Effect: Controls whether the graph appears flat or three-dimensional.
Partitioning Graph Types
Graph Type | Usage |
---|---|
Bar |
Comparisons (default) |
Horizontal Bar |
Comparisons |
Pie |
Percentage or comparisons of percentages; relationship between the parts and the whole |
Line |
Trends over time; rate of data change |
Area |
Trends over time; rate of data change |
Combination |
Trends over time; effect of one variable on another |
Scatter |
Correlations of two or three measures |
Stock |
Stock prices over time |
Circular |
Cyclical or directional patterns |
Pareto |
Highest and lowest contributors to a total; ranking |
3-D |
Three-dimensional comparison |
Funnel |
A filtering process that starts at 100% and decreases in stages to a much lower percentage |
Data
Displays the data in a tabular format. You can reorder the columns by dragging and dropping them.