• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

GWT Pivot table component?

 
Ranch Hand
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 2911
150
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
@ 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...
 
Yahya Elyasse
Ranch Hand
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Bartender
Posts: 2911
150
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Bartender
Posts: 2911
150
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2911
150
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 510
Google Web Toolkit Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

 
Life just hasn't been the same since the volcano erupted and now the air is full of tiny ads.
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic