What's New for Essential Studio 2010 Volume 1

BI Grid/Chart simulates the Pivot Table feature of Microsoft Excel; it pivots and organizes a data table in a cross-tabulated form based on parameters defined in OLAP Data Manager.

A stacking column 100 chart displays multiple series as stacked columns, ensuring that the cumulative proportion of each stacked element always totals 100 percent. Hence, the y-axis is always rendered within the range 0-100.

A bar chart displays horizontal bars for each point in a data series. Points from an adjacent series are drawn as bars next to each other. Bar charts can be used to compare values across different categories—this aids in examining the variations in a value over time, or displaying the values of several items at a single point in time.

Stacking bar charts are regular bar charts with y-axis values stacked on top of each other in a specified order. This stacking allows end-users to visualize the relationship between parts of a whole.

A 100 percent stacked bar chart displays multiple series as stacked bars, ensuring that the cumulative proportion of all stacked elements always totals 100 percent. Hence, the y-axis will always be rendered within the range 0-100. This type of chart is best suited for depicting the relative contribution of each data point.

A rotated spline chart is just a regular spline chart that has been rotated and contains lines drawn horizontally.

BI Grid/Chart now comes with support for binding data from any object whose class implements the IEnumerable interface with a user-defined expression. This helps render summary values in a grid in accordance with a given expression.

BI Grid/Chart/Client supports data binding with named-set records predefined in a cube. A named set is a collection of tuples and members that can be defined and saved as a part of the cube definition.

BI Grid for Silverlight supports exporting OLAP data to Excel spreadsheets and Word documents. Exporting to Excel is one of the most essential functionalities required of an OLAP grid. Users can download data from an OLAP grid into an Excel spreadsheet for offline verification and computation. Grid data can also be exported into a Word document by using Syncfusion Essential Studio Reporting Edition.