Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

OLAP Grid

OLAP grid is used to summarize, analyze, explore, and present summaries for critical enterprise data, allowing informed decisions to be made. Data source support ranges from SQL Server Analysis Services to any XMLA-compatible OLAP databases, 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

Drill Member

OLAP grid 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 expander option.


Drill Position

The drill position feature enables the user to drill only the current position of a selected member in the OLAP report. This will exclude the drilled data of the selected member in other positions by using MDX query. This is useful when the objective of analysis is to view the drilled data only in the current position of a 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 grid 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

Grid Layouts

OlapGrid supports different types of layout to visualize. Supported layouts are normal, Excel-like, Excel-like layout with member properties, normal top summary, no summaries.


The cells in OLAP grid can be extended to behave like hyperlinks. You can listen to click events and process them based on which cell was clicked.


Conditional Formatting

The extensively customizable UI allows you to easily apply custom styles to cells based on filter conditions. The background, foreground, font family, font size, and font weight of value cells can be customized.


Cell Selection

OLAP grid supports Excel-like cell selection where you can select grid value cells like in Microsoft Excel. You can perform custom operations on cell selection and also can bind any control based on the selected cell values.


Freeze Headers

OLAP grid provides built-in support to freeze the column and row headers.


Paging

OLAP grid data can be viewed page-by-page through 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.


Style Dialog

Style dialog is used to format the cells of OLAP grid. Styling can be applied to column header, row header, summary cell, and value cell.


Tooltip

Tooltip provides cell information (measure, column header value, row header value, and cell value) when the mouse pointer is hovered over the value cells.


Exporting

OLAP grid can be easily exported to Excel, Word, and PDF file formats.


Localization

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.


Themes

OLAP grid supports different types of predefined themes, allowing users to switch among them to view the controls in different looks. Supported themes are blend, metro, default, Office2007Blue, Office2007Black, Office2007Silver, Office2010Black, Office2010Blue, Office2010Silver, transparent, and Office2003.


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.