Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
Clear All
new posts
Previous template Next
    #1

    GWT pivot table widget

    Hello,
    I'm new to smartGWT . i want to build a pivot table widget like Excel Pivot table.

    how can i get started ? what are the smartGWT components i can use for this purpose?
    does anyone knows about a smartGWT extension that is a GWT pivot table that displays XMLA query data?

    Thanks for helping.
    Tags: None
    #2
    There is already a very sophisticated pivot table widget in the underlying SmartClient library. It can be used in SmartGWT via JSNI, or, you could sponsor the effort to have Smart GWT wrappers added for it.

    Comment

      #3
      Originally posted by Isomorphic
      There is already a very sophisticated pivot table widget in the underlying SmartClient library. It can be used in SmartGWT via JSNI, or, you could sponsor the effort to have Smart GWT wrappers added for it.
      thank you for the reply.
      is the smartclient JS library open source or is it commercial? i'm asking this b/c our gwt pivot table will be commercial so is it legal to use smartclient library for a commercial product?
      for sponsoring will we need to pay some money to get this widget developed by your developers? if yes what is the range of amount costs?

      thanks

      Comment

        #4
        There are both OSS and commercial versions of SmartClient available, exactly parallel to SmartGWT - see this overview.

        The CubeGrid "pivot table" widget is part of the Analytics module available as an add-on for SmartClient/SmartGWT Power edition.

        Feature sponsors pay roughly half Isomorphic's usual consulting rates for customer-specific development, and may get discounts on licenses or other services purchased at the same time. Use this page to contact us about an estimate and overall costs (including licenses/support).

        Comment

          #5
          I've some questions :

          It's possible to connect to a OLAP server (e.g. MSAS or Mondrain) using XMLA protocol to the pivot widget ?

          If yes, which XMLA protocol is used (http, dime and which security is supported) ?

          It's possible to generate a pivot with a generic MDX query and do you've drill down for it?

          Comment

            #6
            Yes - the CubeGrid uses a DataSource like all other major SmartGWT components. You can see the queries the CubeGrid is generating by watching the server side console in the SmartClient SDK as you navigate around the cube - they are facet-oriented and could be fulfilled by any of those protocols.

            Comment

              #7
              Thanks for you answer, but it sounds like a no to me

              Comment

                #8
                ???

                The answer is an unequivocal yes.

                Try reading about DataSources, that appears to be the part you don't understand - start with the overviews in the SmartGWT FAQ.

                Comment

                  #9
                  I had 3 questions, can you point out to a doc link for 1 ?

                  about 2 and 3 ?

                  Thanks

                  Comment

                    #10
                    It's the same question.

                    The CubeGrid generates facet/dimension oriented queries and when using the DataSource API you are given a Java object representing the query. The query can be straightforwardly turned into XMLA, you can use whichever security model you want, and the drill-down gesture in the UI (choosing a specific region, for example) can be mapped to MDX as well.

                    The FAQ points to overview documentation on how to use DataSources.

                    If you want an example created for you, it would not take long - services offerings are here.

                    Comment

                    Previous template Next
                    Working...
                    X