Features not working

3 posts, 0 answers
  1. Stavros Menegos
    Stavros Menegos avatar
    8 posts
    Member since:
    Jul 2006

    Posted 25 Sep 2017 Link to this post


    I am using the latest version of Kendo UI i.e. 2017.3.921. I am trying to include in my solution the kendo-pivot but it seems that some of the features are not working:

    1. The configuration option sortable enables the "Sort Ascending / Descending" options in the pivot grid BUT when clicked they do nothing. I tried in local binding demo and added the sortable: true just below the filterable property, and it does not work. I tied the same in the documentation of the sortable configuration setting but the dojo example does nothing

    2. I have a kendo-pivot bound to a datasource with remote data of json type. I perform a read operation, the kendo pivot as well as the kendo configurator is populated with data. The pivot has only one Row dimension and no column fields (one measure, only). Should I expand the Row dimension to all its values and force a requery i.e. datasource.read() again the read function of the transport definition is execute OK BUT the statement options.sucess fails with the exception "cannot read property value of undefined"


    function preparePivotDS(espqParams, esOptions) {
                    var qParams = angular.isFunction(espqParams) ? espqParams() : espqParams;
                    var xParam = {
                        transport: {
                            requestEnd: function(e) {
                                var response = e.response;
                                var type = e.type;
                                console.log(type); // displays "read"
                                console.log(response.length); // displays "77"
                            read: function(options) {
                                var pqOptions = {};
                                var executeParams = qParams.Params;
                                if (executeParams instanceof esGlobals.ESParamValues) {
                                    if (!executeParams.isValidState()) {
                                        var err = new Error($translate.instant("ESUI.PQ.PARAMS_MISSING"));
                                        throw err;
                                    executeParams = executeParams.getExecuteVals();
                                esWebApiService.fetchPublicQuery(qParams.GroupID, qParams.FilterID, pqOptions, executeParams)
                                    .then(function(pq) {
                                        pq = pq.data;
                                        options.success(pq.Rows || []);
                                    .catch(function(err) {
                                        $log.error("Error in DataSource ", err);
                    if (esOptions) {
                        angular.extend(xParam, esOptions);
                    return new kendo.data.PivotDataSource(xParam);
  2. Stavros Menegos
    Stavros Menegos avatar
    8 posts
    Member since:
    Jul 2006

    Posted 25 Sep 2017 in reply to Stavros Menegos Link to this post

    For the sorting issue, I found a similar thread in this forum, stating that sorting is only available to Olap data. The documentation of the sortable configuration property does not clarify this. Furthermore, I agree with a fellow reader, that in that case the sort icons and menus should be visible / available to the user.

    Apart from that, should Progress is willing to support kendo-pivot on non olap data, then sorting should be supported. At least present the data sorted by measures either ascending or descending and not in the random order that are now presented.


  3. Konstantin Dikov
    Konstantin Dikov avatar
    2183 posts

    Posted 27 Sep 2017 Link to this post

    Hello Stavros,

    As documented in the following help topic, "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."
    As for introducing those features with the flat binding, you could vote in for the feature request in the public portal in order to increase their priority or log new ones:

    Konstantin Dikov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top