We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

OLAP Chart

OLAP chart is a great way to visualize business intelligence data buried in OLAP and relational databases. This interactive control with drilldown capabilities allows you to surface big picture data and makes it available at your fingertips. Data source support ranges from SQL Server Analysis Services to any XMLA-compatible OLAP database, like Mondrian. With our in-memory pivot engine, you can also bind to any standard relational data sources.

Data Binding

OLAP control enables you to retrieve multidimensional data either from SSAS or from any XML/A provider and present the OLAP information in meaningful ways. Following is the list of data sources our OLAP controls support:

  • Microsoft SQL Server Analysis Services (MS SSAS)
  • Mondrian
  • ActivePivot

Chart Types

OLAP chart lets you visualize OLAP data using many different chart types: stacked area, spline area, step line area, stacked bar, 100% stacked bar column charts, stacked column, 100% stacked column line charts, spline, rotated spline, step line, pie charts, radar charts, funnel charts, and scatter charts.

Drill Member

OLAP chart control has built-in support for drilling up or down to visualize the multidimensional cube data. It provides a detailed view of any selected level while drilling down and shows a more abstract view after drilling up with the help of the expander option.

Drill Position

Drill position enables the user to drill only the current position of a selected member. This will exclude the drilled data of the selected member in other positions using MDX query. This is useful when the objective of analysis is to view the drilled data only in current position of selected member.

Drill Replace

The drill replace option replaces an existing node with its respective child nodes that the end user drilled into.

Calculated Members

OLAP chart control displays user-defined dimensions and measures through OLAP report to define and add dimensions and measures. The calculated members are classified into two types: Calculated Measure—a user-defined measure element created from an existing measure element; Calculated Dimension—a user-defined dimension element created from an existing dimension.

Named Set

A named set is a multidimensional expressions (MDX) expression that returns a set of dimension members that can be defined and saved as a part of the cube definition. Named sets are created by combining cube data, arithmetic operators, numbers, and functions. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.

Key Performance Indicators

KPI are a collection of calculations associated with a measure group that evaluates business success. Typically, these calculations are a combination of multidimensional expressions (MDX) or calculated members. There are four different types of available indicators:

  • KPI Goal
  • KPI Status
  • KPI Trend
  • KPI Value


A color code that helps to differentiate between chart items. A legend also has labels beside each color to indicate that it applies to information from Series 1, Series 2, and so on.


OLAP chart provides options to display chart series information such as measures, row and column member names, and values of a current segment while hovering over each individual series.


OLAP chart data can be viewed page-by-page through the pager option. The page sizes for categorical and series axes are set in the OLAP report through which large amounts of data are broken and navigated quickly and easily. Users can navigate the page with the help of the navigation bar available within the OLAP pager.


Localization is the process of customizing the user interface (UI) as locale-specific in order to display regional data. Using this feature, data can be displayed in a specific language and culture, of a particular country or region. Visualization of the control right-to-left is also applicable.


OLAP chart supports different types of predefined themes, allowing users to switch among them to view the controls in different looks. Supported themes are Office 2010 blue, Office 2010 black, Office 2010 silver, transparent, Office 2007 blue, Office 2007 black, Office 2007 silver, blend, metro, and default.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.