We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

Browse multidimensional data (OLAP) organized into dimensions, measures, named sets, and KPIs in a cube format, as well as pivot data, with the Pivot and OLAP browser. You can visualize the results in graphical (pivot chart) and table (pivot grid) formats. The control can also be used to create and edit reports at runtime that can be stored for later use.


Data binding

The JavaScript Pivot and OLAP browser provides extensive support to bind OLAP and pivot data sources.

  • OLAP data sources - SSAS, Mondrian, ActivePivot, and Oracle.
  • Pivot data sources - DataTable, DataView, DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List and ArrayList.

OLAP and relational data binding in JavaScript Pivot and OLAP browser


Optimized for mobile devices

Touch support for JavaScript Pivot and OLAP browser

Touch support

All the features work smoothly on desktop and tablet devices. Features such as drag and drop, drill up and drill down, filtering, sorting, and report manipulation can be done on the fly.

Responsive view of JavaScript Pivot and OLAP browser

Responsive support

The control layout can be viewed on desktop and tablet devices in a compact manner.


JavaScript Pivot Table

End users can enable built-in features in the Pivot Table either through UI or a simple, user-friendly API in the code-behind.

For more details about the built-in Pivot Table features, check here.


JavaScript Pivot Chart

End users can enable built-in features in the Pivot Chart either through UI or a simple, user-friendly API in the code-behind.

For more details about the built-in Pivot Chart features, check here.


OLAP cube

End users can easily slice and dice the OLAP cube elements of their choice to visualize performance, trends, outliers, and more.

Slicing and dicing functionalities in JavaScript Pivot and OLAP browser

Slice and dice

With slice and dice, you can create a new view for end users by selecting dimensions and measures from the OLAP cube and filtering them.

KPI functionalities in JavaScript Pivot and OLAP browser

KPIs

KPIs are a collection of calculations associated with a measure group that evaluates business success.

Paging support in JavaScript Pivot and OLAP browser

Paging

Extensive support has been provided to load and render large amounts of data without any performance constraints through paging or virtual scrolling.

Named sets support in JavaScript Pivot and OLAP browser

Named Set

Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.

Calculated members and measures support in JavaScript Pivot and OLAP browser

Calculated members and measures

You can create and display dimensions and measures on your own.

Measure group support in JavaScript Pivot and OLAP browser

Measure groups

View measures belonging to the same underlying fact table in a group.


Axis element builder

The axis element builder is similar to the pivot table field list in Excel. You can create and manage the control with either multidimensional or pivot data sources. End users can drag fields and filter them at runtime to create reports.

Axis element builder in JavaScript Pivot and OLAP browser


Cube browser in JavaScript Pivot and OLAP browser

Pivot and cube browser

  • OLAP cube organizes its elements such as dimensions, hierarchies, measures, KPIs, and named sets, from the selected cube in a tree-like structure.
  • For the pivot data source, fields are loaded in a tree-like structure.

Filtering

Use built-in normal and Excel-like filter UIs with advanced filtering options to filter and view data as required.

Filters row and column headers JavaScript in Pivot and OLAP browser

Header filtering

Display only select values for a field either through the UI (member editor) or code behind.

Excel like filtering meanu in Pivot and OLAP browser

Excel-like filtering

Excel-like filtering presents an advanced option to filter column and row headers based on label text or grand-total values.


Sorting

Order the column and row header text in ascending or descending order.

sorting in JavaScript Pivot and OLAP browser


Member editor in JavaScript Pivot and OLAP browser

Member editor

The member editor dialog display members of the selected field in a tree-like structure. You can search those members, apply filters and order them in either ascending or descending order. Also, members can be paged when there are large amount of records bound to the control.


Number and date formatting

Number formatting and date formatting help to transform the appearance of the actual value for pivot charts and pivot grids. This is applicable only for pivot data sources.

Number and date formatting in JavaScript Pivot and OLAP browser


Toolbar support in JavaScript Pivot and OLAP browser

Toolbar

The following options are available in the toolbar to perform reporting operations:

  • Filtering: Filter the members based on the grand total of the specific measure.
  • Sorting: Sort the headers based on the grand total of the specific measure.
  • Chart types: Change the chart types at runtime.
  • Full screen: View the pivot chart and pivot grid in the full screen of the device.
  • Toggle axis: Toggle the fields in the row axis and column axis.
  • MDX: Show the MDX query of the current report.

NOTE: Filtering and sorting are supported only in OLAP server mode.


Report manipulation

  • New: To create a new report collection.
  • Add: Add a new report to the current report collection.
  • Rename: Individual report names can be modified in the current report collection.
  • Remove: Individual reports can be removed from the current report collection.

Report manipulation support in JavaScript Pivot and OLAP browser


Loads report from the database in JavaScript Pivot and OLAP browser

Save and load reports

You can save reports from the current session as a stream in a database for later use. UI support provided for save, save as, rename, delete, and load report operations from database:

  • Save: Current report collection can be saves in the database.
  • Save AS: Existing report collection can be resaved with a different name in the database.
  • Load: Any of the saved reports collection can be retrieved back from the database.
  • Remove: Any of the saved reports collection can be removed from the database.
  • Rename: Any of the saved reports collection can be renamed in the database.

Layout customization

Render the control in different layouts with the help of built-in properties:

  • Customize the control’s size through the API.
  • Display either a pivot grid or pivot chart as the default view during initial loading.
  • Display either pivot chart or pivot grid alone.
  • Collapse view support for pivot or cube browser
  • Place control in either tab or tile view.

Layout customization support in JavaScript Pivot and OLAP browser


Exports report to Excel, Word, and PDF in JavaScript Pivot and OLAP browser

Exporting

You can export a pivot table or pivot chart to Excel, Word, or PDF documents.


Custom style and theme

Built-in theme support in JavaScript Pivot and OLAP browser

Built-in themes

Ships with a set of 13 stunning, built-in themes: azure, lime and saffron in light, dark and gradient patterns.

Custom CSS for JavaScript Pivot and OLAP browser

Custom styling

You can customize the control appearance to any extent in code behind.

Customizes JavaScript Pivot and OLAP browser appearance using theme studio

Theme studio

Easily customize all aspects of the control appearance using the Theme Studio utility.


Developer-friendly API

For a great developer experience, flexible built-in APIs are available to define and customize the JavaScript Pivot and OLAP browser. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.


Web accessibility

Our JavaScript Pivot and OLAP browser has been developed to make it possible for people with disabilities to use and interact with the control.

Web accessibility in JavaScript Pivot and OLAP browser


Globalization and localization

Globalization in JavaScript pivot grid control

Globalization

Users from different locales can use this control by applying appropriate date formats, currency formats, and number formats.

Localization in JavaScript Pivot and OLAP browser

Localization

Users can customize the text in the user interface based on the local culture.

Right-to-left in JavaScript Pivot and OLAP browser

Right-to-left (RTL)

The text direction and layout of the control can be rendered right-to-left(RTL) direction.


Browser compatibility for JavaScript Pivot and OLAP browser

Cross-browser and cross-platform

The JavaScript Pivot and OLAP browser will work on all major browsers across Windows and macOS. It is written in jQuery to provide the same working experience on popular browser like Chrome 17+, Firefox 22+, and Internet Explorer 8+. It also works with platforms like ASP.NET Web Forms, ASP.NET MVC and ASP.NET Core.


Third-party frameworks support

The JavaScript Pivot and OLAP browser has built-in integration with Angular and Ember third-party frameworks. Check out the control’s unique features for each platform:


75+ JAVASCRIPT UI CONTROLS

Integrates with Top Frameworks

Built-in integration with the most popular third-party frameworks, like Angular 2+, and React.

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon