The XtraPivotGrid Suite - Multi-Dimensional Data Analysis Control for .NET

When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table control provides business users unrivaled insights into daily operations. Until the release of the XtraPivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications.

The XtraPivotGrid Suite was engineered from the ground-up to blow away the limitations posed not just by these out-of-process solutions, but to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the XtraPivotGrid is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.

At Developer Express we know that your time is valuable and our goal has always been to deliver products that address your business needs, increase your productivity and offer the "wow" factor that helps you obtain loyal users for years to come. The XtraPivotGrid demonstrates our commitment to these principles by offering developers like you a nearly endless set of options to dissect data yet do so in an elegant and efficient manner.

With the XtraPivotGrid control you can view data from cubes that are deployed on an OLAP (online analytical processing) server. A cube represents a multidimensional structure defined by its measures and dimensions. You can think of a measure as a data field in the XtraPivotGrid control, while a dimension can be represented by a column field or row field.

In a typical binding mode, when the XtraPivotGrid control is bound to a regular data source, the control requires all data to be downloaded from a data store onto the client side. All data is processed locally. In OLAP binding mode, when the control is bound to a cube on an OLAP server, the grid doesn't calculate summaries itself. Instead, it delegates all data management and calculations to the server side. The raw data is not downloaded to the client side, only the results of calculations. So, the OLAP binding mode is appropriate for handling large amount of data, and especially when a cube is already defined on an OLAP server.

The following OLAP servers are supported:

• Microsoft SQL Server 2000 Analysis Services;
• Microsoft SQL Server 2005 Analysis Services.

Read more here.