File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes GWT and the fly likes GWT Pivot table component? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » GWT
Bookmark "GWT Pivot table component?" Watch "GWT Pivot table component?" New topic
Author

GWT Pivot table component?

Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

Hi ,
i searched for some GWT pivot table component but couldn't find one.
does anyone knows of such component? or a pivot table in swing that i can convert to GWT.

thanks
salvin francis
Ranch Hand

Joined: Jan 12, 2009
Posts: 928

@ 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...


My Website: [Salvin.in] Cool your mind:[Salvin.in/painting] My Sally:[Salvin.in/sally]
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

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?

thanks.
salvin francis
Ranch Hand

Joined: Jan 12, 2009
Posts: 928

actually. that sounds like a business functionality than a programming question, I would rather discuss the technical stuff,
what exactly is your requirement here ?

If i was you, i would google for it, decide on what i need, discuss with client and then freeze on what exactly is required.
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

salvin francis wrote:actually. that sounds like a business functionality than a programming question, I would rather discuss the technical stuff,
what exactly is your requirement here ?

If i was you, i would google for it, decide on what i need, discuss with client and then freeze on what exactly is required.

Hi salvin, & thanks for continuing discussion with me about the GWT pivot table component.

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.
salvin francis
Ranch Hand

Joined: Jan 12, 2009
Posts: 928

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

some wheels are meant to be re-invented, at least I feel so.

glad to help
salvin francis
Ranch Hand

Joined: Jan 12, 2009
Posts: 928

Here is my though process on the pivot table,

considering that this is a sample table:


and you want the pivot to contain functionality like this:



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
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

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?

thanks.
philippe perez
Greenhorn

Joined: Jun 15, 2010
Posts: 3
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.

Just have a look and tell me what you think.

Thank you
Philippe
http://www.iccube.com

Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

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.

Just have a look and tell me what you think.

Thank you
Philippe
http://www.iccube.com


is the pivot table component freely downloadable ? there is no link to download the pivot table component. i guess it is a commercial component?
philippe perez
Greenhorn

Joined: Jun 15, 2010
Posts: 3
There is now a download link on this page, which also summarizes the key features.

http://www.iccube.com/products/contributions/gwt-pivot-table

It is a commercial component. I hope you will enjoy evaluating it. Do not hesitate to leave us some comments.
Thank you
Philippe

Charles Kendrick
Greenhorn

Joined: Jan 25, 2010
Posts: 10
There's a very, very powerful pivot table component in SmartClient, which could be made available in Smart GWT with maybe 1-2 weeks effort:

http://www.smartclient.com/index.jsp#basicCube
http://www.smartclient.com/index.jsp#analytics

There's a Feature Sponsorship program that would allow you to request this and sponsor it:

http://www.smartclient.com/services/index.jsp#features

philippe perez
Greenhorn

Joined: Jun 15, 2010
Posts: 3
Our first open source steps, GWT Pivot Table and XMLA library distributed under LGPL license !

http://www.iccube.com/products/contributions/gwt-pivot-table
Charles Kendrick
Greenhorn

Joined: Jan 25, 2010
Posts: 10
The pivot table I previously mentioned is now available as a standard SmartGWT feature (in Power Edition w/Analytics module) - no need any longer for feature sponsorship.

Demos here:
http://www.smartclient.com/smartgwtee/showcase/#cube_basic
http://www.smartclient.com/smartgwtee/showcase/#cube_analytics
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

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
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:

http://www.smartclient.com/product/index.jsp
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

philippe perez wrote:Our first open source steps, GWT Pivot Table and XMLA library distributed under LGPL license !

http://www.iccube.com/products/contributions/gwt-pivot-table


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.

Regards.
Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

Yahya Elyasse wrote:
philippe perez wrote:Our first open source steps, GWT Pivot Table and XMLA library distributed under LGPL license !

http://www.iccube.com/products/contributions/gwt-pivot-table


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.

Regards.

Sorry i found the source downloads at http://www.iccube.com/download
thanks again.
yan fei
Greenhorn

Joined: Jul 02, 2012
Posts: 1
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.

Just have a look and tell me what you think.

Thank you
Philippe
http://www.iccube.com

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: GWT Pivot table component?