Web pivot cell limit

Support - Assistance technique
1

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

2

Hi Dapo,

sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser?

Lars

···

On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

3

Hi Dapo,

I know this is a lot more involved than most people are willing to take on but if you’re able build your own dhis.war file you can modify the file /dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/DataQueryParams.java and change the number near line 100 to increase it to > 50000.

public static final int MAX_DIM_OPT_PERM = 50000;

Dan

···

On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

4

Hi Lars, to be able to download will be fine not necessarily to view in the browser.

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 23 January 2014 19:36
To: Dapo Adejumo
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] Web pivot cell limit

Hi Dapo,

sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser?

Lars

On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

5

Okay then there is trick based on generating the analytics URL yourself. Using the API you can ignore the limit. Docs here.

  • In chrome click F12, go to Network

  • Generate the pivot table you want (and let it fail validation)

  • Copy the URL of the request going to the server, starting with api/analytics/… etc.

  • In the URL, replace the file extension .json with .xls , then append a query parameter: &ignoreLimit=true

Don’t try this at home.

Lars

···

On Thu, Jan 23, 2014 at 9:13 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Lars, to be able to download will be fine not necessarily to view in the browser.

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: 23 January 2014 19:36
To: Dapo Adejumo
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] Web pivot cell limit

Hi Dapo,

sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser?

Lars

On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

6

Thanks Lars….will only try this at home…

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 23 January 2014 20:34
To: Dapo Adejumo
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] Web pivot cell limit

Okay then there is trick based on generating the analytics URL yourself. Using the API you can ignore the limit. Docs here.

  • In chrome click F12, go to Network

  • Generate the pivot table you want (and let it fail validation)

  • Copy the URL of the request going to the server, starting with api/analytics/… etc.

  • In the URL, replace the file extension .json with .xls , then append a query parameter: &ignoreLimit=true

Don’t try this at home.

Lars

On Thu, Jan 23, 2014 at 9:13 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Lars, to be able to download will be fine not necessarily to view in the browser.

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 23 January 2014 19:36
To: Dapo Adejumo
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] Web pivot cell limit

Hi Dapo,

sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser?

Lars

On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hi Devs,

The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily?

Any ideas?

…

Regards,

Dapo Adejumo

+2348033683677

skype : dapojorge

Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp