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.
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:
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.
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 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.
The drill replace option replaces an existing node with its respective child nodes that the end user drilled into.
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.
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.
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:
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.