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.
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 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.
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.
The drill replace option replaces an existing node with its respective child nodes that the end user drilled into.
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.
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:
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.
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.
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.
OLAP grid provides built-in support to freeze the column and row headers.
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 is used to format the cells of OLAP grid. Styling can be applied to column header, row header, summary cell, and value cell.
Tooltip provides cell information (measure, column header value, row header value, and cell value) when the mouse pointer is hovered over the value cells.
OLAP grid can be easily exported to Excel, Word, and PDF file formats.
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 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.