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.
There is extensive support to bind OLAP data sources.
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 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 provides a user-friendly graphical UI. Interactive capabilities allow end users to expand/collapse different levels in a hierarchical dimension.
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:
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 sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.
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.
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.
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.
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 allows you to load and render a large amount of data without any performance constraint.
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.