The OLAP grid control organizes and summarizes business data and displays the result in a cross-table format.
The OLAP grid control enables you to retrieve multidimensional data from SSAS or any XML/A provider. Following is the list of data sources our OLAP controls widely support:
OLAP grid delivers a detailed view of any selected level member while drilling down and shows an abstract view after drilling up.
Grid allows you to drill only the current position of a selected level member, excluding others.
The drill replace feature replaces an existing node with its respective child nodes that the end user drilled into.
Slicing and dicing creates a new view for the end user by selecting limited dimensions and measures from the Cube and filtering them.
KPI is a collection of calculations associated with a measure group that evaluates business success.
Named sets are MDX expressions that return a set of dimension members, which can be defined and saved as a part of the Cube definition. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.
You can now create and display dimensions and measures on your own. This can be done only through the report programmatically.
Member properties provides basic information about each member in each tuple, including member name, parent level, and number of children.
Drill through easily obtains the list of raw items for a particular value or summary cell.
Settings in the OLAP grid can be serialized to a XML format and loaded back through the built-in deserialization options.
Conditional formatting allows users to define conditions that, when met, format value and summary cells’ font, color, and border settings.
Extensive support has been provided to load and render large amounts of data without any performance constraint through pager.
You can view grid summaries in different ways, such as normal, top summaries, no summaries, and Excel-like summaries.
There is built-in support for freezing row and column headers for a better view of values.
Grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.
Grid has extensive support to select a range of value cells.
Tooltip provides basic information about a cell while hovering the mouse pointer over it..
OLAP grid has a rich set of options available for exporting data to Excel, Word, PDF, and CSV. Several options are also provided to customize the exporting operations.
OLAP grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.
OLAP grid provides ability to customize the appearance of the control to any extent programmatically.
Easily customize all aspects of appearance using the Theme Studio utility.