[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: Re: [Mondrian] [Olap4j-devel] olap4j-xmlaserver: Initial refactoring of Mondrian's XMLA server into
From: Luc Boudreau <lucboudreau () gmail ! com>
Date: 2013-09-30 20:16:06
Message-ID: CAKTEAx9XZG7_yJr0SyeP_1oTH3fdn_s955++kZPh9kYwHcZZDg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Julian,
Sessions are part of the XMLA specs. We just never used them.
http://technet.microsoft.com/en-us/library/ms187187.aspx
IIRC, it was Michele who did a couple things around that part, but it never
was pushed through the finish line.
Luc
On Sun, Sep 29, 2013 at 7:09 PM, Benedikt Kämpgen <benedikt.kaempgen@kit.edu
> wrote:
> Hi Julian,
>
> Thanks for the background info and the great idea! I will use it.
>
> Best,
>
> Benedikt
>
> On 09/28/2013 06:36 PM, Julian Hyde wrote:
> > On Sep 28, 2013, at 5:36 AM, Benedikt Kämpgen <benedikt.kaempgen@kit.edu>
> wrote:
> >
> >> Hello,
> >>
> >> I was able to connect xmla4js [1] to xmlaserver [2] using the olap4j [3]
> >> driver olap4ld [4]. Many thanks to Julian Hyde, Roland Bouman, Michele
> >> Rossi and many others for their effort in creating those interoperable
> >> olap components.
> >
> > You are welcome. Good to know that it all works.
> >
> >> I am wondering whether it would be possible
> >> to keep track of sessions, i.e., xmla requests issued by the same user
> >> in the same usage period.
> >
> > XMLA is designed to be stateless, so naturally the requests don't carry
> session information. We could do something like adding optional attributes,
> and requiring all the layers in the stack to pass these attributes on over
> the various component boundaries. However, there are a lot of moving parts
> to change.
> >
> > So, how about something low-tech like adding a session id to the query
> inside a comment?
> >
> > SELECT /* $session: 1234 */ [Measures] on 0, ...
> >
> > The query will pass unchanged through the various components. You can
> parse it out of the logs using awk + sed technology.
> >
> > Julian
> >
>
> --
> AIFB, Karlsruhe Institute of Technology (KIT)
> Phone: +49 (721) 608 48941
> Email: benedikt.kaempgen@kit.edu
> Web: http://www.aifb.kit.edu/web/Hauptseite/en
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> _______________________________________________
> olap4j-devel mailing list
> olap4j-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/olap4j-devel
>
[Attachment #5 (text/html)]
<div dir="ltr">Julian,<div><br></div><div>Sessions are part of the XMLA specs. We \
just never used them. </div><div><br></div><div><a \
href="http://technet.microsoft.com/en-us/library/ms187187.aspx">http://technet.microsoft.com/en-us/library/ms187187.aspx</a><br>
</div><div><br></div><div>IIRC, it was Michele who did a couple things around that \
part, but it never was pushed through the finish \
line.</div><div><br></div><div>Luc</div></div><div class="gmail_extra"><br><br><div \
class="gmail_quote">
On Sun, Sep 29, 2013 at 7:09 PM, Benedikt Kämpgen <span dir="ltr"><<a \
href="mailto:benedikt.kaempgen@kit.edu" \
target="_blank">benedikt.kaempgen@kit.edu</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
Hi Julian,<br>
<br>
Thanks for the background info and the great idea! I will use it.<br>
<br>
Best,<br>
<br>
Benedikt<br>
<div class="im HOEnZb"><br>
On 09/28/2013 06:36 PM, Julian Hyde wrote:<br>
> On Sep 28, 2013, at 5:36 AM, Benedikt Kämpgen <<a \
href="mailto:benedikt.kaempgen@kit.edu">benedikt.kaempgen@kit.edu</a>> wrote:<br> \
><br> >> Hello,<br>
>><br>
>> I was able to connect xmla4js [1] to xmlaserver [2] using the olap4j [3]<br>
>> driver olap4ld [4]. Many thanks to Julian Hyde, Roland Bouman, Michele<br>
>> Rossi and many others for their effort in creating those interoperable<br>
>> olap components.<br>
><br>
> You are welcome. Good to know that it all works.<br>
><br>
>> I am wondering whether it would be possible<br>
>> to keep track of sessions, i.e., xmla requests issued by the same user<br>
>> in the same usage period.<br>
><br>
> XMLA is designed to be stateless, so naturally the requests don't carry \
session information. We could do something like adding optional attributes, and \
requiring all the layers in the stack to pass these attributes on over the various \
component boundaries. However, there are a lot of moving parts to change.<br>
><br>
> So, how about something low-tech like adding a session id to the query inside a \
comment?<br> ><br>
> SELECT /* $session: 1234 */ [Measures] on 0, ...<br>
><br>
> The query will pass unchanged through the various components. You can parse it \
out of the logs using awk + sed technology.<br> ><br>
> Julian<br>
><br>
<br>
</div><div class="HOEnZb"><div class="h5">--<br>
AIFB, Karlsruhe Institute of Technology (KIT)<br>
Phone: <a href="tel:%2B49%20%28721%29%20608%2048941" value="+4972160848941">+49 (721) \
608 48941</a><br>
Email: <a href="mailto:benedikt.kaempgen@kit.edu">benedikt.kaempgen@kit.edu</a><br>
Web: <a href="http://www.aifb.kit.edu/web/Hauptseite/en" \
target="_blank">http://www.aifb.kit.edu/web/Hauptseite/en</a><br> <br>
<br>
<br>
------------------------------------------------------------------------------<br>
October Webinars: Code for Performance<br>
Free Intel webinars can help you accelerate application performance.<br>
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from<br>
the latest Intel processors and coprocessors. See abstracts and register ><br>
<a href="http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk" \
target="_blank">http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk</a><br>
_______________________________________________<br>
olap4j-devel mailing list<br>
<a href="mailto:olap4j-devel@lists.sourceforge.net">olap4j-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/olap4j-devel" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/olap4j-devel</a><br> \
</div></div></blockquote></div><br></div>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic