Skip Headers
Previous
Previous
 
Next
Next

Cube Data Viewer

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.

Query Parameters

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.

Query Results

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:

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.