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:

Copy Code<PropertyList>
    <Format>Multidimensional</Format>
</PropertyList>

The value of the AxisFormat should be TupleFormat.

Copy Code<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.