Large embed.xhtml/view.xhtml response body

[lhg-interact]

We are experiencing slow loadings in our analyzes due to large response body when requesting to embed.xhtml or view.xhtml.

Example of a single cell from grid: <td id="grid-form:col-1576375587" role="gridcell" class="ui-panelgrid-cell row-hdr-cell ui-widget-header" style="padding-left: 40px;"><span id="grid-form:txt-638737670" title="[Data].[2013].[Q1].[Fevereiro].[4]">4</span></td> This is too much data for a single cell, which will show a single character as its content.

Our clients access their analyzes over internet, so large data to be trafficked is a big problem. We have analyzes with sizes over 100MB, which is way too much to be trafficked over internet. Is there a way to make the response body more compact? Or make this table structure to be generated by the client?

[ShengtianM]

You can use “pivotStateManager.getModel().getCellSet()” to get the result data and response the data to the client. Then use client generates the table structure.

[lhg-interact]

This is not the solution i was expecting. I definitly don't want to build my own client from scratch. I was hoping there is a way to reduce the amount of information in the already implemented client from pivot4j-analytics, without breaking anything. Our clients are already used to this layout and its functionalities, so building a new one is very unlikely.

[mcastillob]

I'm corrected this problem long ago. https://github.com/mcastillob/pivot4j/commit/e42967c8461ee477d0dd1ff862eb75bbf30d1a6a.

[mcastillob]

"col-" + column.hashCode(); it can be duplicated when there is a lot of data.

change this for Generators.timeBasedGenerator().generate(); .

fix my versión in https://github.com/mcastillob/pivot4j/releases/download/pivot4j-1.0.1/pivot4j-pentaho-1.0-SNAPSHOT-plugin.zip