salvin francis wrote:@ swing to GWT:
you are comparing two different frameworks

Back to the topic,
I have not come across any "table gui" based component, let alone the pivot table in gwt,

having said that,
I dont think its that trival to build your own...

for the GUI, the Grid / Flexgrid seems to be a viable option,
as for the pivot functionality, define the rules you want and maybe i could suggest how you go about it...

Yes it seems to me it is a challenging project to build a GWT OLAP pivot table component .
thank you for offering to help me in this task. i'll keep posting my questions and issues in this thread and hope we could work together on this interesting problem.

my first question:
can you point me some papers or articles explaining the theory of pivot and the OLAP data presentation?

i did some research & found this project: http://code.google.com/p/pentahoanalysistool I investigated the java code of the pentaho analysis tool & found it uses GWT Pivot tables to visualize OLAP MDX queries. in fact i didn't yet compiled and run the code of pentahoanalysistool .i quickly looked to its svn code base. so i'm not 100% sure if it really has a GWT pivot table component in its codebase. can someone confirm this?
in case pentahoanalysistool is already an existing project that meets our needs , it will be logical if we build on top of it i.e instead of writing the whole GWT pivot table from scratch we can take the already existing code of pentahoanalysistool and extend & customize it to meet our own needs. this seems to me a better approach.Your thoughts?
again as i said i'm not sure if pentahoanalysistool Has a GWT pivot table in its code base (i'll need to check the code in more depth). but i need your feedback about this issue. what do you think of the http://code.google.com/p/pentahoanalysistool project? do you know of some other OS projects similar to this one that i can use as a building block for my project instead of writing everything from scratch?

Thank you all for contributing your Ideas and thoughts about this topic.

personally I dont know much about pentahoanalysistool,
but here is my opinion about using third party tools / libraries / components,

if the time taken to integrate the component into existing system < 1/2 of time it takes to build a new component from scratch,
then the existing component is the best option, provided it does solve all your issues.
else you are better off making it yourself

As i understand, its a relation of "A to B on the basis of C" for example, in the given image :
A : Region
B : Ship Date
C : Sum of units.

Its entirely up to you to decide where the functionality should come,
if your table is Large and/or if you are providing pagination, then i would suggest moving the logic entirely to the server and the GWT to only send ajax calls to server mentioning what is 'A','B','C' the server does the calculations and returns the result.
else if the data is small, then you could do it at client end, but that kind of defeats the purpose that if a data is small, i would not want a pivot view of it

Thank you guys for following with me in this thread : we will be discussing the building of a pivot table GWT component which is a challenging problem worth discussion ;) your ideas and contributions would be very welcome.

I have two first questions:

1- can you explain what the drill down and drill up functionality of a pivot table means? i think this is the most difficult behavior the gwt grid should have and it is worth knowing what drill down/drill up means and how it works.

2-the gwt pivot table will have to display XMLA query results in the grid. it should be able to display any XMLA query result data. how XMLA data format look like? and what technique to use to map a XMLA query result into a 2D GWT grid table?

Before taking the decision of coding or not your GWT pivot table , you may have a look at ours.
It is written in GWT . You can see an online demo to have an idea , on our website.

Its customizable via css so that it matches with your website visual standards. You spoke about
pagination , it is one the features supported. This pivot table can take data from a a text file. It
is also intended to display data from a xmla client bundled with it.

Before taking the decision of coding or not your GWT pivot table , you may have a look at ours.
It is written in GWT . You can see an online demo to have an idea , on our website.

Its customizable via css so that it matches with your website visual standards. You spoke about
pagination , it is one the features supported. This pivot table can take data from a a text file. It
is also intended to display data from a xmla client bundled with it.

thanks for pointing these two solutions.
seems to me the smartGWT pivot table component is great. is it free and open source?
anyway i'll get back to this project later and these two components will be useful
thanks

Charles Kendrick
Greenhorn

Joined: Jan 25, 2010
Posts: 10

posted Jan 27, 2011 13:03:38

0

Hello Yahya,

The SmartGWT pivot table component (called the CubeGrid) is a commercial extension to the open source SmartGWT framework. So it requires a license and is closed source, but you are running on an open source framework - for example, the superclass of the CubeGrid (ListGrid) is entirely open source. Licensing explained here:

philippe, does your GWT pivot widgets have open source code somewhere? I need to look at the source code and see if i can customize and work with your widget.
please if you have the source code of this widget available somewhere ,i'll be gratefull if you provide it.

philippe, does your GWT pivot widgets have open source code somewhere? I need to look at the source code and see if i can customize and work with your widget.
please if you have the source code of this widget available somewhere ,i'll be gratefull if you provide it.

Hello Philippe, I downloaded the iccube client library and did find the source code for GWT pivot table, but didn't find a running example on how to use it as claimed on the website, is it possible that you can send me a running code example? Will I be able to connect to existing SSAS cube?

philippe perez wrote:Hello

Before taking the decision of coding or not your GWT pivot table , you may have a look at ours.
It is written in GWT . You can see an online demo to have an idea , on our website.

Its customizable via css so that it matches with your website visual standards. You spoke about
pagination , it is one the features supported. This pivot table can take data from a a text file. It
is also intended to display data from a xmla client bundled with it.