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. Image for the cookie policy date

Paging in OLAP Client

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)

2 Replies

OL olegl 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

RG Ramesh Govindaraj Syncfusion Team 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.

Live Chat Icon For mobile
Up arrow icon