Paging in OLAP Client

[olegl]

Hello

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

http://js.syncfusion.com/demos/web/#!/azure/olapclient/displayoptions

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

http://js.syncfusion.com/demos/web/#!/azure/pivotgrid/olap/paging

and Asp.Net OLAP has paging also

http://asp.syncfusion.com/demos/bi/olapclient/Paging/Paging%20Demo/CS/Paging.aspx

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)

[olegl]

We found workaround 

But maybe there is a better way 

Paging for Grid

  $("#OlapClient").ejOlapClient({

            displaySettings: displaySettings,

            renderSuccess: function (olapClient) {

                $("#Pager").remove();

                let pagerDiv = ej.buildTag("div#Pager", "", { "margin-top": "10px" }, {})[0].outerHTML;

                $(pagerDiv).appendTo(".outerTable");

                $("#Pager").ejPivotPager({

                    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;

dataManager.SetCurrentReport(olapReport);

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; }

        }

        [System.Web.Http.ActionName("Paging")]

        [System.Web.Http.HttpPost]

        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

https://www.syncfusion.com/forums/javascript/ejpivotgrid/121914

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]

Hi Olegl,

Thanks for the update.

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

Regards,
Ramesh G.