BI Chart controls for the display of OLAP data

Essential BI Chart is a great way to visualize business-intelligence data buried in OLAP and relational databases. This interactive control with drill down capabilities allows you to surface big-picture data and makes it available at your finger tips. Data source support ranges from SQL Server Analysis Services to any XMLA compatible OLAP database. 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, Silverlight and WPF.

Data Sources

Use our intuitive APIs to refer to an OLAP data source and specify which dimensions, measures and KPIs you want to visualize in the chart. 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-memory pivot engine transform the data dynamically and present it as multi-dimensional OLAP data.

• OLAP Binding
• Relational Binding
• Report Builder

Drilldown

BI Chart has built-in support for drilling down to the different levels of a hierarchical dimension. For example, collapsible axes labels let you visualize data by year, quarter or month in a time dimension.

• OLAP Visualization

Chart Types

Visualize chart data using numerous chart types ranging from bar charts to pie charts.

• Chart Gallery

Exporting Charts

Easily export BI Chart to several file formats. Also embed chart images into PDF, Excel or Word documents using our Reporting Studio.

• Exporting Chart Data

Chart Appearance

The background, fonts, borders, and other chart elements can be fully customized at the chart as well as series levels. Built-in customizable legends are displayed to identify dimensions that are visualized. Tooltip can be employed to provide additional information at point level.

• Customization
• Built-in Legends
• ToolTip Info

User Interaction

Interactive end-user zooming allows your end-users to zoom-into areas of interest within the chart.

• Zooming

Filter Elements based on top level records

Essential BI Chart filters individual measure elements based on top-level records, improving an application’s performance.

• Filter Top level Elements

Custom Expression Support

BI 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.

• Custom Expression Support

Named Set Records

BI Chart 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.

• Named Set Records

Filtering

The OLAP Chart allows you to filter the contents based on some filter conditions using the Reports.

• Subset
• Exclude

Calculated Members

The calculated members are classified into two types: Calculated Measure—which is a user-defined measure element created from an existing measure element; and Calculated Dimension—which is a user-defined dimension element created from an existing dimension. New calculated members can also be created from existing calculated members, and they can be added to a report through the API. That report, containing calculated members, can then be loaded into OlapChart.

• Calculated Members

Design-Time Support

Essential BI OlapChart for WPF supports customizing a control during design time using Visual Studio 2008 or Visual Studio 2010. You can easily connect using the Connection dialog. After connecting, you can customize a report to your liking by dragging and dropping dimensions and measures to create the form you need.

• Design-Time support