paging in pivotgrid

[Mul]

how do i set the datasource in the pivotgrid to the correct data generate in the pivotgrid in the paging?
for example: in my datasource i have 500 rows which generate into 250 rows and 250 colums in the pivot grid. 
how to i take the new data size which was created in the pivotgrid and not from the datasource for calculation the paging for the pivotgrid?

i use this: 
     $("#pager").kendoPager({
                    dataSource: result.data,                         /* not correct*/
                    pageSizes: [10, 25, 50]
                });

when the result.data is the 500 rows that was arrived from the original datasource.

[Georgi Krustev]

Hello Mul,

The PivotDataSource component does not support paging. In general, there is no clear way (at least to my knowledge) to page data retrieved from an OLAP instance. Note that this is applicable for the flat data binding too.

Regards,
Georgi Krustev
Telerik

 

 

[rwb]

Paging in the pivotGrid is badly needed when working with anything but the most trivially small datasets.

The display can be paged in both directions according to the row and column headers. 

The XMLA properties BeginRange and EndRange will perform the paging.

You can calculate appropriate values and page boundaries from the number of members in each dimension.

[Alex Hajigeorgieva]

Hello both,

Currently there is no paging functionality in the Kendo UI Pivot Grid. However, please share your idea in the User Voice Forum below:

http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/category/170004-pivot-grid

If it gains enough popularity, we will consider implementing it in a future release.

Kind Regards,
Alex
Telerik

 

 

[rwb]

Example of DevExpress (admittedly MVC version only; not JS) with paging and sorting by measure.

[Alex Hajigeorgieva]

Hi Richard,

The feedback we receive in the UserVoice portal is instrumental in determining future enhancements or features. If the feature has not been requested yet, then we assume that there is no demand and harness our efforts in other popular areas so more of our clients can benefit. 

Please check the UserVoice portal and create the idea as it does not exist. Alternatively, cast your vote for possibly the closest idea to paging that we have there - the DevExpress Compact Layout as it seems to incorporate paging here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/7861869-pivot-grid-compact-layout.

Regards,
Alex
Telerik by Progress