Use a BI Grid to summarize, analyze, explore, and present summaries for critical data in your enterprise and make informed decisions. 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. Use it in your Web or Windows development using the variants built natively for each of these platforms: ASP.NET, ASP.NET MVC (HTML 5-enhanced), Silverlight, and WPF.
Use our intuitive APIs to refer to an OLAP data source and specify which dimensions, measures, and KPIs you want to visualize in the grid. Or you can visually create a report definition schema (XML) using our Report Builder and refer to the schema in your applications. You can even bind to relational data sources and let our in-meory pivot engine transform the data dynamically and present it as multi-dimensional OLAP data.
The BI Grid comes with built-in support for drilling down to different levels of a hierarchical dimension. For example, collapsible headers let you visualize data by year, quarter, or month in a time dimension. Optionally, it also lets you view drill-down data via ToolTips.
Easily create executive summary scorecards to help visualize business critical KPIs with status and trend information. Scorecards could be hierarchical with built-in support for drill-down. The status indicators can be customized with several built-in or custom icons.
The BI Grid allows you to customize the look and feel of the different portions of the grid using styles. Easily customize the grid to fit your organization's themes.
The OLAP Grid allows you to filter the contents based on some filter conditions using the reports.
Essential BI Grid can export OLAP data to Excel spreadsheets or Word documents. Using Syncfusion products like Essential XlsIO, DocIO, and PDF, you can also export a BI Grid to an Excel or Word document.
The BI Grid has an option for displaying member properties that provide basic information about each member in each tuple, including member name, parent level, and number of children. These member properties are available for all members at any given level.
Essential BI Grid for WPF supports designing an OLAP grid from within the designer. Wizards help you connect to a data source as well as select dimensions and measures to visualize through simple drag and drops.
Appearance
Report Settings
Header Tooltip
Row level Drill down
Top level Summary
Bottom level Summary
Value Cell Tooltip
Waiting Popup
Exporting
Relational DataBinding
No Summary Grid Layout
HyperLink Cells
Filter Top Level elements
Excel-Like Grid Layout
Grid with KPI
Grid with Frozen Headers
Named Set Records
Custom Collection Support
Filtering with Subset
Filtering with Exclude
Designer Support
Member Properties
Calculated Members
| Development Environments |
|
| .NET Framework versions |
|
| Operating Systems |
|
| Web Servers |
|
| Browser Support |
|
About Syncfusion
Founded by industry experts in 2001, Syncfusion, Inc. provides the broadest range of enterprise-class software components and tools for the Microsoft .NET platform. With Syncfusion, developers can move beyond simply coding applications to delivering real business innovation—the elegant user interfaces, business intelligence dashboards, and sophisticated reporting that today's business users need, in the formats they demand.
Cart
Internet Explorer 7+
Mozilla 2.0+
Safari 3.0 + 
Chrome 1+