|
Tools panel
This panel houses all the frequently used
operations on the OLAP chart - save, export, print
and display options.
|
Button |
Function |
 |
Load the Grid state |
 |
Save the Grid state |
 |
Export OLAP-slice data |
 |
Print OLAP-slice data |
 |
Preview |
 |
Undo |
 |
Redo |
 |
Switch axes |
 |
Select the docking panels layout |
 |
Set the scale of Chart display |
 |
Select the color palette for measures |
Modifier panel
Modificators are easy and powerful options of data
representation. You can choose your data be shown in
different colors, using different shapes and sizes,
so that you can easy distinguish them in a single
graph. You can simply place a dimension or a measure
on a modificator’s pane and get the graph showing
different values in a different manner. For example,
you might place the "Problem Category" dimension on
Color pane and get the Chart showing problem
categories in different colors. Or you can place the
"Cost" measure on Color pane to highlight the top
rates of supporting the service requests. The same
can be done for Shape and Size so that you can make
your data perfectly distinguished.

The layout of panels and hierarchies on the
Modifier panel allows you to change the appearance
of the displayed slice. When an element is placed to
the modifier panel (except for Details), its legend
will contain the display parameters. If you modify
the color and shape of an element, the appropriate
parameters can be amended.
|
Modifier |
The changes made upon placing a
Chart element to the modifier area of... |
|
a measure |
a hierarchy |
|
The color of the Chart elements will
be chosen from the standard set of
gradient colors |
Hierarchy members will be painted
with the colors from the current palette |
| Color |
The elements with the minimal value
will be painted with the first of the
gradient colors, and the elements with
the maximal value - with the last one |
N/A |
| Size |
Depending on the value of the
measure the size of the Chart points
will vary from the minimal to the
maximal. |
Hierarchy members will differ in
size |
| Shape |
Forbidden |
Hierarchy members will differ in
shape. If the number of hierarchy
members will exceed the number of
available shapes, some of them will be
used more than once |
| Details |
Forbidden |
The panels will display series for
all hierarchy members |
If a measure is placed on the Color pane, its
values range is mapped to the given colors range so
that it’s tremendously easy to spot the top/low
values.
If you select the discrete gradient type, you'll be
able to set threshold values for filling the Chart
elements. While the continuous gradient will let you
evaluate the trend as a whole. To select the
gradient type and tune its content, turn to the
legend panel.
The Legend panel
The panel contains descriptions of the modified
elements. The value, shape and color of a legend
element can be edited.
Setting the Color legend
To select a color, simply double-click the
appropriate element and choose a color from the
pop-up editor.

Setting the Gradient legend
To edit the gradient, double-click the element and
tune the settings in the editor. In the Gradient
Editor there are:
- a set of pre-made gradients;
- selecting gradient option (continuous or
discrete);
- creating a gradient with a set number of
intermediate colors option;
- setting threshold in per cent and measure
values option;
- selecting threshold color option.
Setting the Shape legend
The shape selection is made through the context
menu. This option is available only for points or
lines Charts. If the number of hierarchy members
exceeds the number of available shapes, they will be
repeated.

Chart Panes
The bulk of the OLAP-slice data are placed into
cells with Charts. Each measure group has its own
set of panes.

Measure groups with corresponding Charts in the
working area In the upper left part
of each Chart, there will appear a context menu for
selecting its type.

Chart type menu The size of Charts can be
changed to some extent. To expand a Chart along
either one of the axes, you need to capture its
boundary with the mouse and drag it. You can change
the size along both axes (or return to default)
through the tool menu in the upper part of the
working area.
| Hot keys for changing the
scale |
| Ctrl+* |
Reset Scale to 1:1 |
| Ctrl+Num+ |
Zoom In |
| Ctrl+Num- |
Zoom Out |
Navigation
If the content of the Grid exceeds the client area,
the scroll bars will appear. You can scroll down the
data using the mouse wheel. To scroll the Grid in
the vertical direction, turn the mouse wheel, while
holding Shift.
Selecting Data
You can select Chart points with the standard
Windows' method. Holding down the Ctrl button, you
can add selected points, holding down the Shift
button, you can select the horizontal range. You can
filter the Grid's points while selecting. In that
case, the corresponding hierarchy members will be
filtered automatically.
| Selecting and filtering
parts of Charts |
 |
 |
 |
| a. Selecting some of the Chart points |
b. Selecting the Filter command |
c. The result |
Note: When moving the mouse cursor over a data
axis, you are able to select a continuous range of
members (if the axis is composed of them) or a range
of values in Charts.
Filtering hierarchies
In case you need to collect data not from the whole
Grid, but just from a part of it, the component has
a few functions at your disposal: they let you
select or remove elements from the slice. Also,
there is a standard option of exporting data into a
number of formats and printing out the content of
OLAP-slices.
The simplest way of selecting data is through the
context menu. When you click a hierarchy member on
the Cube axis, there is a set of commands for quick
operations with members:
- Hide this member
- Hide all members except this
- Hide all members above this
- Hide all members below this
Filter on hierarchy level
The Filter area of the Editor becomes visible only
in case if filtering by hierarchy levels is
available. To apply a filter to hierarchy members,
you need to select a hierarchy level (if there's
more than one) and assign the Filter condition in
the Filter menu. In the same menu, there's a command
to clear filter.
Filtering hierarchy members
If the search field is not empty, the "Find" command
will make the component perform a search for
hierarchy members, whose levels contain the
specified string. You can narrow the search results
by checking the "Exact matching" box.
Filtering a single member of a hierarchy
By default, the Editor is able to select any number
of hierarchy members. To switch to the single-select
mode, uncheck the "Multiselect" box. In that case,
only one the hierarchy member with all its parents
and members will be selected.

Filtering measures
There is a number of available parameters for
filtering measures. In the same Editor, you can
clear the filter.
 |