Components
    • Animation
    • Barcodes
    • Buttons
    • Charts
    • Common Utilities
    • Conversational UI
    • Data Grid
    • Data Query
    • Data Tools
    • Date Inputs
    • Date Math
    • Dialogs
    • Drawing
    • Dropdowns
    • Editor
    • Excel Export
    • File Saver
    • Form
    • Gantt
    • Gauges
    • Indicators
    • Inputs
    • Labels
    • Layout
    • ListBox
    • ListView
    • Mapbeta
    • Notification
    • PDF Processing
    • PivotGrid
    • Popup
    • Progress Bars
    • Ripple
    • Scheduler
    • ScrollView
    • Sortable
    • TaskBoard
    • Tooltips
    • TreeList
    • TreeView
    • Upload
    Sample Applications
    Styling & Themes
    Common Features
    Project Setup
    Changelog

Frequently Asked Questions

This article lists the answers to the most frequently asked questions (FAQs) when working with the KendoReact PivotGrid.

Does the PivotGrid work with the OLAP cube that is delivered by MS SSAS?

Yes, it does. The Microsoft SQL Server Analysis Services (MS SSAS) use the XMLA protocol, which is the main requirement for the PivotGrid to work.

Does the PivotGrid work with different OLAP servers?

If the OLAP service implements the XMLA standard, it should work out-of-the-box. Note that the supported format of the Execute method is a multidimensional property:

<PropertyList>
    <Format>Multidimensional</Format>
</PropertyList>

The value of the AxisFormat should be TupleFormat.

<PropertyList>
    <AxisFormat>TupleFormat</AxisFormat>
</PropertyList>

How can I connect to a secured OLAP instance?

For more information, refer to the Accessing the Cube Securely section.

If I do not have an OLAP cube, can I still use the PivotGrid?

Currently, the KendoReact PivotGrid does not support binding to flat data.