Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: [Mondrian] RESTful web service

  1. #1
    Kim Goldov Guest

    Default [Mondrian] RESTful web service

    I'm building a RESTful Mondrian web service. The service will accept GET requests containing MDX or our legacy query format. The request will return XML, CSV, or a JSON format compatible with Google's interactive time series graphs. I'm using Spring MVC with an XSLT view so I can easily map the result to the desired output format.

    I can think of two general approaches that I might take. One would be to generate XML from the Mondrian "Result" object using JAXB or an equivalent mechanism. The other would be to tap into Mondrian's XML/A capability at some level. I'm not sure what the best way is to go about either of these approaches. Is there another alternative I have not thought of?

    Please respond if this isn't the correct venue for this type of question.

    Thanks,
    Kim

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Pedro Alves Guest

    Default Re: [Mondrian] RESTful web service

    Take a look at the pentaho cda project, it may be similar to what you're
    building


    -pedro


    On 05/11/2010 07:09 PM, Kim Goldov wrote:[color=blue]
    > I

  3. #3
    Cristian E. Orellana Castillo Guest

    Default Re: [Mondrian] RESTful web service

    What about using CDA?

    El 11/05/2010 14:09, "Kim Goldov" <kgoldov (AT) uw (DOT) edu> escribi

  4. #4
    Luc Boudreau Guest

    Default Re: [Mondrian] RESTful web service

    You might be interested in xmla4js ( http://code.google.com/p/xmla4js/ ).
    _____________________________
    Luc Boudreau


    On Tue, May 11, 2010 at 2:09 PM, Kim Goldov <kgoldov (AT) uw (DOT) edu> wrote:

    > I’m building a RESTful Mondrian web service. The service will accept GET
    > requests containing MDX or our legacy query format. The request will return
    > XML, CSV, or a JSON format compatible with Google’s interactive time series
    > graphs. I’m using Spring MVC with an XSLT view so I can easily map the
    > result to the desired output format.
    >
    >
    >
    > I can think of two general approaches that I might take. One would be to
    > generate XML from the Mondrian “Result” object using JAXB or an equivalent
    > mechanism. The other would be to tap into Mondrian’s XML/A capability at
    > some level. I’m not sure what the best way is to go about either of these
    > approaches. Is there another alternative I have not thought of?
    >
    >
    >
    > Please respond if this isn’t the correct venue for this type of question.
    >
    >
    >
    > Thanks,
    >
    > Kim
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >
    >


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  5. #5
    Julian Hyde Guest

    Default RE: [Mondrian] RESTful web service

    There have been some other replies suggesting you look at CDA and xmla4js.
    You should definitely look into those.

    Also:

    Note that mondrian's XMLA server can now return results in JSON format (in
    addition to XML). (See
    <http://julianhyde.blogspot.com/2010/01/xmla4js.html>
    http://julianhyde.blogspot.com/2010/01/xmla4js.html and the comment thread
    following it.)

    If you are building something from scratch, I suggest you build on top of
    olap4j rather than mondrian's legacy API.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Kim Goldov
    Sent: Tuesday, May 11, 2010 11:09 AM
    To: 'mondrian (AT) pentaho (DOT) org'
    Subject: [Mondrian] RESTful web service



    I'm building a RESTful Mondrian web service. The service will accept GET
    requests containing MDX or our legacy query format. The request will return
    XML, CSV, or a JSON format compatible with Google's interactive time series
    graphs. I'm using Spring MVC with an XSLT view so I can easily map the
    result to the desired output format.



    I can think of two general approaches that I might take. One would be to
    generate XML from the Mondrian "Result" object using JAXB or an equivalent
    mechanism. The other would be to tap into Mondrian's XML/A capability at
    some level. I'm not sure what the best way is to go about either of these
    approaches. Is there another alternative I have not thought of?



    Please respond if this isn't the correct venue for this type of question.



    Thanks,

    Kim


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.