Dynamic Multidimensional Graphs


Create and Publish Dynamic Multidimensional Graphs

Designer features full multidimensional graphics. You can build rich charts and graphs that are completely dynamic with a Slice of data: if you change the row, column or page Dimension, or any data point, the graph will update to show the new perspective.

There are 15 basic types of graphs, each with hundreds of formatting options. You can display the graph—or both the graph and the Slice—on the Web, or within most Windows applications.

You can choose what level of control the end-user will have over the display, from simply viewing a locked dynamic image, to provide complete modeling capabilities. You can zoom in or out on a graph, set alarm zones, see values of points on a graph and drill down or through on those points. You can print the graphs or save them as .jpg or .png files.

Slice Tab/Graph

With this new feature you can make graphical representations of the Slice data.

By going to the Slice Tab, you can select one of the 15 Chart types shown below, at your preference (The Graph command is accessible through the Options Control Group of the Slice Tab).

Example Charts

Stacked Bar Chart

1.   Create a new Slice.

2.   Readjust the Slice as shown below.

3.   In the PowerOLAP ribbon, select Slice tab, Graph command, Stacked bar Chart.

The Graph is displayed in the lower pane as shown.

The functional features of the graph are controlled through the Graph short-cut menu settings shown in the succeeding topics.

You can adjust the graphical area/grid area by dragging the pane border (splitter) separating the two panes.

You can also Hide/Show the panes individually using the short-cut menu options.

Two other examples, Bar chart, and Pie chart are shown below.

Bar Chart


Pie Chart

Graph Control Settings

The graphs can be further customized using the short-cut menu settings shown below:

1.   Right-click on the graph. A short-cut menu appears as shown.

2.   Select from the different options.

You can customize your graphs by using the short-cut menu options: General Settings, Alarm Zones, Header, Footer, Legend, Series, X Axis, Y Axis, Show Marker, Show, and Value.

The other options Zoom, Change Graph type, Print Graph, Show Grid, Hide Graph, Save as JPEG or Save as PNG, are self-explanatory.

See Grid Shortcut menu options for details on these menu options.

Available Chart Types

PowerOLAP® application supports many kinds of charts to help you display data in ways that are meaningful to users. Use the Slice/Chart Wizard to create a chart — or when you use the Chart Type command to change an existing chart — you can easily select the type you want from a list of standard or custom chart types.

1. Line Chart

A line chart shows trends in data at equal intervals. The following chart displays trends over time or categories.

2. Bar Chart

A bar chart illustrates comparisons among individual items.

3. Pie Chart

A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data.


4. Stacked Bar

This type of chart shows the relationship of individual items to the whole.


5. Area Chart

An area chart emphasizes the magnitude of change over time.


6. HiLo

HiLo Chart in simple mode display showing Min and Max values. As for all chart types, the layout is fully configurable.

7. HiLo OpenClose graph

A HiLo OpenClose graph displays stock information using High, Low, Open, and Close values. Opening values are displayed using lines to the left, while closing values are indicated by lines to the right.


8. Candle graph

A candle graph displays stock information using High, Low, Open, and Close values. The size of the wick line is determined by the High and Low values, while the size of the bar is determined by the Open and Close values.

The bar is displayed using different colors, depending on whether the price of the stock has gone up or down.


9. Polar Graphs

Polar graphs provide graphs of a data using polar coordinate system (radial distance (y) and angle with x-axis (x) instead of the x-y Cartesian or rectangular coordinates.

For polar graphs the angular measurement and radial components correspond to the X and Y Coordinates in a line graph.

10. Radar Chart

A radar chart compares the aggregate values of a number of data series.

This type of chart displays changes in values relative to a center point. It can be displayed with markers for each data point. For example, in the following radar chart, the data series that covers the most area, Brand A, represents the brand with the highest vitamin content.

11. Filled Radar Chart

In this type of chart, the area covered by a data series is filled with a color.


12. Bubble Chart

The Bubble graph is an XY graph in which data points are represented by bubbles. The Bubble graph requires two Y values: the first Y value is used to plot the bubble along the Y axis, and the second Y value is used to set the size of the bubble.

13. 3D-Surface

A surface chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values. Surface charts have the following chart sub-types:

14. 3D-Bar

The 3D Bar chart is used to show categorized data along 2 axes.  Where a 2D Bar chart places multiple subsets next to each other, the 3D Bar places multiple subsets at different z locations. Similar to the Graph Object, the 3D Bar chart only needs Y Data. X Data and Z Data are not used in this mode.


15. 3D Scatter Plots

New 3D scatter plots accurately display relationships among data points. Data points can be arranged into series, each with its own point style and drop line style.