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.
Unfortunately, activation email could not send to your email. Please try again.

Paging in OLAP Client

Thread ID:

Created:

Updated:

Platform:

Replies:

121913 Feb 8,2016 03:15 AM Feb 9,2016 03:47 AM JavaScript 2
loading
Tags: ejPivotClient
olegl
Asked On February 8, 2016 03:15 AM

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
Replied On February 8, 2016 08:45 AM

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 [Syncfusion]
Replied On February 9, 2016 03:47 AM

Hi Olegl,

Thanks for the update.

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

Regards,
Ramesh G.


CONFIRMATION

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.

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.

;