Edit this page

Frequently Asked Questions

This article provides a collection of the most frequently asked questions (FAQs) and answers related to the Kendo UI PivotGrid.

OLAP

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 widget is bound to an OLAP cube (such as sorting, hierarchies, and other) are supported.

See Also

Other article on the Kendo UI PivotGrid:

For how-to examples on the Kendo UI PivotGrid widget, browse its How To documentation folder.

Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy