Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

Overview

Pivot client control supports browsing multidimensional data that is organized in the form of dimensions, measures, named sets, and KPIs in a cube format. You can visualize the results in graphical (pivot chart) and tabular (pivot grid) formats. The control can also be used to create and edit reports on the fly that are stored for later use.


Data Binding

There is extensive support to bind OLAP data sources.


Slice and Dice

Pivot client is great for building analysis and decision-making applications where end users can easily drag and drop elements of their choice to visualize performance, trends, outliers, and more.


Pivot Grid

Pivot grid is used to display a set of multidimensional data in a concise, precise, and compact area. Rendering of data in the tabular format can be easily understood by users of any level.


Pivot Chart

Pivot chart provides a user-friendly graphical UI. Interactive capabilities allow end users to expand/collapse different levels in a hierarchical dimension.


Key Performance Indicators

KPI are a collection of calculations associated with a measure group that evaluates business success. Typically, these calculations are a combination of multidimensional expressions (MDX) or calculated members. There are four different types of available indicators:

  • KPI Goal
  • KPI Status
  • KPI Trend
  • KPI Value


Calculated Members

Pivot client control displays user-defined dimensions and measures through a UI specially created to define and add dimensions and measures. The calculated members are classified into two types: calculated measure, a user-defined measure element created from an existing measure element; calculated dimension, 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 UI.


Named Set

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


Virtual KPI

Users can create their own KPIs at run time and write expressions as well. In an expression, positive numbers will be represented by a green light or up arrow, and negative numbers will be represented by a red light or down arrow, depending on the user preference.


Dynamic Report

Reports can be created and updated on the fly by dragging items from cube dimension browser to axis element builder. We can also change the axis of each item by dragging the split button between different axes in the axis element builder.


Toolbar

Pivot client allows users to perform various operations, such as adding new reports, removing existing reports, renaming existing reports, saving and loading reports, and more. End users can also change the chart types, chart palette, exporting, and few other chart options using the icons in the chart toolbar, and change the grid layout, enable tooltip, exporting, and a few other grid options through the icons present in the grid toolbar.


Report Persistence

Pivot client allows you to store the current session of the report collection in your machine and then load it to the control at a later time.


Paging

Paging allows you to load and render a large amount of data without any performance constraint.


Localization

Localization is the process of customizing the user interface (UI) as locale-specific in order to display regional data. Using this feature, data can be displayed in the specific language and culture of a particular country or region. Visualization of the control right-to-left is also applicable.


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.