Frequently Asked Questions
This article lists the answers to the most frequently asked questions (FAQs) when working with the Kendo UI 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 section on accessing the cube securely.
If I do not have an OLAP cube, can I still use the PivotGrid?
Currently, the Kendo UI PivotDataSource has limited support for binding to flat data. Note that in this scenario not all of the features that are available when the component is bound to an OLAP cube (such as hierarchies and other) are supported.