::adCenter::
Bookmark and Share

What's New for Essential Studio 2012 Volume 1

All BI Products

Additional Information in OLAP Report Serialization

Users can save additional information in an OLAP report and load it wherever required. The following is the additional information that users can save in Essential BI Chart and Essential BI Grid:

Essential BI Chart:

  • Appearance
  • Legend position
  • Series color types
  • Skins for charts

Essential BI Grid:

  • Frozen headers
  • Show ToolTip
  • Header and value cell settings
  • Appearance

Serializing an OLAP Report

Essential BI PivotGrid

Show or Hide Subtotals

This feature is used to show or hide the subtotals in Essential BI PivotGrid. It enables users to have an abstract view of the data in the case of larger data tables by hiding the subtotals.

Pivot Grid with Hidden Subtotals
Persist Expand/Collapse State

Essential BI PivotGrid’s default behavior is to expand all nodes when a grid’s schema is changed. Support to persist expansion states enables users to maintain the expanded/collapsed state in the PivotGrid control when pivot schema is changed or when the pivot grid is de-serialized from an .xml file.

Persisted Expand/Collapse State of Records in a Pivot Grid
Disable Grouping by Specific Fields

This feature restricts users from dragging and dropping certain fields in the grouping area, thereby disabling grouping.

Grouping Disabled for a Field

Essential BI Client for ASP.NET

Paging Support

Paging support helps users view data in larger dimensions by breaking the data into pages. Paging support provides users with the following features:

  • Enable/disable pager
  • Categorical pager
  • Series pager
  • Pager option dialog

Paged Data in Essential BI Client

Essential BI Grid for ASP.NET

Hide Summary Elements at Different Levels

Users can hide the summary elements of an OLAP Grid at different levels based on the level name or level number. This feature helps users to view only the necessary details by hiding the unrequired summaries. It also optimizes the visibility of summary elements in Web pages.

Summary Elements Hidden at Different Levels
Frozen Headers

Users can freeze the header of the grid so that headers are always visible when scrolling through a grid with a large number of rows or columns.

Frozen Headers in an OLAP Grid

Essential BI PivotGrid for WPF

Run-Time Custom Summary Type Setting

Users can set custom and built-in summaries at run time using the Pivot Computation Information dialog. In previous versions, custom summaries could be set to a column only at load time, but the run-time custom summary type setting feature enables switching custom summaries at run time.

Setting Summary Type at Run Time
Hide Field Support

Users can hide unnecessary fields from the pivot schema designer by using the ShowDisplayFields property.

Pivot Table List with ShowDisplayFields Property Disabled
Pivot Table List with ShowDisplayFields Property Disabled