We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Paging in OLAP Client

Thread ID:





121913 Feb 8,2016 08:15 AM UTC Feb 9,2016 08:47 AM UTC JavaScript 2
Tags: ejPivotClient
Asked On February 8, 2016 08:15 AM UTC

1. Is it possible to add paging to OLAP Client Grid and Chart?

We cant find it 
OLAP client hangs without it 
For example, use 'Date' in Row, Account\Customer\Delivery Date in Column
Works but with little browser freezing, maybe because chart rendering?
add 'Geography' to column and browser tab hangs (Chrome)

it looks strange because PivotGrid has paging
and Asp.Net OLAP has paging also

2. Another way to reduce size of data is group collapsing
For example: 
use default configuration with 'Measures' in column and 'Date' in Row,
add 'Account' to row
we can expand (drill down?) year to quarters and collapse to year, 
but we cant collapse Year group ( all account numbers for some year to total sum)

Replied On February 8, 2016 01:45 PM UTC

We found workaround 
But maybe there is a better way 

Paging for Grid

            displaySettings: displaySettings,
            renderSuccess: function (olapClient) {
                let pagerDiv = ej.buildTag("div#Pager", "", { "margin-top": "10px" }, {})[0].outerHTML;
                    mode: ej.PivotPager.Mode.Both,
                    targetControlID: "PivotGrid"
            title: "Cube Browser",
            url: "api/OlapClient"

plus  code in OlapClientController

1. In InitializeGrid
var olapReport = OLAPUTILS.Utils.DeserializeOlapReport(parameters.CurrentReport);
olapReport.EnablePaging = true;

2.Paging method
public class PagingParameters
            public string CurrentReport { get; set; }

            public string Action { get; set; }

            public string PagingInfo { get; set; }

            public string GridLayout { get; set; }

            public string ClientReports { get; set; }

        public Dictionary<string, object> Paging(PagingParameters parameters)
            var dataManager = new OlapDataManager(_connectionString);
            var htmlHelper = new Syncfusion.JavaScript.PivotGrid();
            dataManager.SetCurrentReport(htmlHelper.SetPaging(parameters.CurrentReport, parameters.PagingInfo));
            return htmlHelper.GetJsonData(parameters.Action, dataManager, parameters.GridLayout);

Also found a bug

In any case it does not work for the Chart
Its bad because browser hangs because of Chart rendering

Sorry for bad english

Ramesh Govindaraj [Syncfusion]
Replied On February 9, 2016 08:47 AM UTC

Hi Olegl,

Thanks for the update.

We will consider the paging support in OlapClient in our near future.

Ramesh G.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon