What's New for Essential Studio Business Intelligence Edition

All BI Products

Quartet FS ActivePivot Support in OLAP Controls

Syncfusion OLAP controls can now bind with ActivePivot server databases. Users can customize the data view by pivoting, slicing, and dicing using the ActivePivot service in an OLAP report. Users can also store the current view of the ActivePivot data and load it whenever required through OLAP reports.

OLAPGrid Control with ActivePivot Data

OLAPChart Control with ActivePivot Data

Localization Support

Localization is the key feature for providing IT solutions for global users. This feature allows users to localize the control to a specific locale.

Localized Essential BI Client

Essential BI Client for ASP.NET

Showing MDX Query at UI Level

This feature allows users to view the MDX query of the current report, which will be displayed in a separate MDX Query dialog by clicking the Show MDX Query button in the toolbar.

Showing the MDX Query of an OLAP Report

Essential BI Grid for Silverlight

Calculated Measures at UI level

Users can define any desired calculated measures or members of data from the existing measure using the Calculated Member Editor dialog. They can edit the created calculated measures or members as they desire.

Calculated Member Editor

Essential BI PivotGrid for Silverlight

Context Menu Support for Expand-and-Collapse Operations

Users can expand and collapse all or any desired row or column headers containing unique text using a context menu or programmatically.

Expand-and-Collapse Options

ToolTip Support for Header and Value Cells

ToolTips are provided for column, row, and summary headers, as well as summary and value cells. The row or column header displays the unique text as a ToolTip. Value cell ToolTips provide information about the cell and its row and column header values. Users can also customize the ToolTip with their own templates.

ToolTip in Value Cell

ToolTip in Column Header Cell

Custom ToolTip Template

Essential BI PivotGrid for Windows Forms

PivotGrid Control

The PivotGrid control allows users to summarize selected columns and rows of data in a database table to organize it in a cross-tabulated form. With the PivotGrid control, users can add calculation values and also the desired summary type to the database table. This control enables users to summarize large amounts of data quickly.

It also supports the following:

Users can select grid cells similar to the cell selection in Microsoft Excel to copy data to the clipboard quickly.
Sorting enables users to quickly organize the data.
Grouping support enables users to drag fields between different areas such as columns or rows.
Filtering provides an easy and quick way of finding a subset of data in the database table.

Updating Support in PivotGrid

Cell Selection, Sorting, Grouping, and Filtering Support in the PivotGrid Control

Essential BI Client for ASP.NET

Showing MDX Query at UI Level

This feature allows users to view the MDX query of the current report, which will be displayed in a separate MDX Query dialog by clicking the Show MDX Query button in the toolbar.

Showing the MDX Query of an OLAP Report

Essential BI Grid for WPF

Calculated Measures at UI level

Users can define any desired calculated measures and members of data from the existing measure by using the Calculated Member Editor dialog. They can also edit the created calculated measures and members as they desire.

Calculated Member Editor

Essential BI Gridfor ASP.NET

Sort Data by Headers

This feature enables users to sort relational data in a desired order. Users can choose any of the following display orders:

Ascending: Displays all values beneath the row and column header in ascending order.
Descending: Displays all values beneath the row and column header in descending order.
Unspecified: Displays all values beneath the row and column header in the order in which they were passed into the relational data.

Data in Ascending Order

Data in Descending Order

Data in an Unspecified Order

Appearance and Performance Improvements

The overall appearance and performance of the OlapGrid control have been improved. Code optimization has been done at both the script level and code-behind level to improve performance.

The control’s theming has been enhanced, and the following themes have been included as built-in options that can be applied through a property without requiring theme-related style sheets at the application level.

Office 2007 Blue
Office 2007 Black
Office 2007 Silver
Office 2007 Oliver
Office 2010 Blue
Office 2010 Black
Office 2010 Silver

Essential BI Grid

Essential BI PivotGrid for WPF

ToolTip Support for Header and Value Cells

ToolTips are provided for column, row, and summary headers, as well as value and summary cells. The row and column headers display their unique text as a ToolTip. Value cell ToolTips provide information about the cell and its row and column header values. Users can also customize the ToolTip template at the sample level.

ToolTip in Value Cell

ToolTip in a Column Header Cell

ToolTip with Custom Template

Context Menu Support for Expand-and-Collapse Operations

Users can expand and collapse all or any desired row or column headers containing unique text using a context menu or programmatically.

Expand-and-Collapse Operations Available in Context Menu

Editing and Updating

When users edit data in value cells, data in the total cells will be updated accordingly. Values updated in the data source will be reflected in the pivot grid.

Users can set the time interval to update the edited data and customize the PivotCellInfo of the cell by customizing the editing manager.

Editing Support in the PivotGrid Control

Updating Support in PivotGrid