OLAP Xforms

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

OLAP Xforms

Smruti Naik
Hi ,
 
I want to use MDX query through Xforms,
 
Can you please tell is there any possibility to do that ?
 
I am using Mondrian OLAP Server to achieve that ..... Please help me.
 
Regards,
Smruti


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Erik Bruchez
Administrator
A long time ago we used to have an OLAP processor based on Mondrian in
Orbeon Forms. Since there was zero demand for it we stopped working on it.

It could be possible to revive this code. It is still available under
MDXProcessor.java. This was using Mondrian in an embedded way. Maybe
there is now a better way to communicate to Mondrian. I see in their doc
now that they support XML for Analysis, which is SOAP-based, and could
be called directly from XForms:

   http://mondrian.pentaho.org/documentation/architecture.php

-Erik

Smruti Naik wrote:

> Hi ,
>  
> I want to use MDX query through Xforms,
>  
> Can you please tell is there any possibility to do that ?
>  
> I am using Mondrian OLAP Server to achieve that ..... Please help me.
>  
> Regards,
> Smruti
>

--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Smruti Naik
Thanks Erik ,
 
Can you please tell if you have any example .
even want to know which version of ops i can get that MDXProcessor.java.?
 
Regards,
Smruti

 
On 9/21/07, Erik Bruchez <[hidden email]> wrote:
A long time ago we used to have an OLAP processor based on Mondrian in
Orbeon Forms. Since there was zero demand for it we stopped working on it.

It could be possible to revive this code. It is still available under
MDXProcessor.java. This was using Mondrian in an embedded way. Maybe
there is now a better way to communicate to Mondrian. I see in their doc
now that they support XML for Analysis, which is SOAP-based, and could
be called directly from XForms:

  http://mondrian.pentaho.org/documentation/architecture.php

-Erik

Smruti Naik wrote:

> Hi ,
>
> I want to use MDX query through Xforms,
>
> Can you please tell is there any possibility to do that ?
>
> I am using Mondrian OLAP Server to achieve that ..... Please help me.
>
> Regards,
> Smruti
>


--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto: [hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Erik Bruchez
Administrator
Smruti Naik wrote:
> Thanks Erik ,
>  
> Can you please tell if you have any example .

Mmh, we had an example, probably all the way back to OPS 2.8. Check the
files section to get 2.8:

   http://forge.objectweb.org/project/showfiles.php?group_id=168

> even want to know which version of ops i can get that MDXProcessor.java.?

The processor is still present in the latest Orbeon Forms. The processor
name is oxf:mdx.

-Erik

--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Smruti Naik

Thanks Erik ,
 
i saw this code
 
<processor name="oxf:mdx" uri="oxf/processor/mdx">
           <class name="org.orbeon.oxf.processor.mdx.MDXProcessor"/>
on http://mail-archive.objectweb.org/ops-commits/2007-06/msg00219.html
but written like no longer supported and even i downloaded the ops 2.8 but there is no example .
 
can you please tell me what we have to specify in processor like
any xml file path or etc . can you please attach code of example if you have ??
 
Please help me . i am really worried .
 
Regards,
Smruti
 
On 9/21/07, Erik Bruchez <[hidden email]> wrote:
Smruti Naik wrote:
> Thanks Erik ,
>
> Can you please tell if you have any example .

Mmh, we had an example, probably all the way back to OPS 2.8. Check the
files section to get 2.8:

  http://forge.objectweb.org/project/showfiles.php?group_id=168

> even want to know which version of ops i can get that MDXProcessor.java.?

The processor is still present in the latest Orbeon Forms. The processor
name is oxf:mdx.

-Erik

--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto: [hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Alessandro Vernet
Administrator
Smruti,

On 9/24/07, Smruti Naik <[hidden email]> wrote:

> <processor name="oxf:mdx" uri="oxf/processor/mdx">
>            <class
> name="org.orbeon.oxf.processor.mdx.MDXProcessor"/>
> on
> http://mail-archive.objectweb.org/ops-commits/2007-06/msg00219.html
> but written like no longer supported and even i downloaded the ops 2.8 but
> there is no example .
>
> can you please tell me what we have to specify in processor like
> any xml file path or etc . can you please attach code of example if you have
I can't see any example checked in. We used to have some example for
the MDX processor, but those must have been deleted at some point.
Since Mondrian supports a standard SOAP interface (XML for Analysis),
I would recommend you use that interface to talk to Mondrian.

If you want to write Java code, and you want to write your own
processor, you may or may not find the code in the MDX processor
useful, but this is not the route that I would explore first.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Smruti Naik
Thanks Vernet ,
 
Actually I need one java processor . also in that java class if i write any mdx queries . then i need 1 cube  it must be some xml file. so i just want to know that can we specify that xml file name in
MDX Processor , even i couldnt get your point for SOAP Interface , can you help me .?

 
On 9/25/07, Alessandro Vernet <[hidden email]> wrote:
Smruti,

On 9/24/07, Smruti Naik <[hidden email]> wrote:

> <processor name="oxf:mdx" uri="oxf/processor/mdx">
>            <class
> name="org.orbeon.oxf.processor.mdx.MDXProcessor"/>
> on
> http://mail-archive.objectweb.org/ops-commits/2007-06/msg00219.html
> but written like no longer supported and even i downloaded the ops 2.8 but
> there is no example .
>
> can you please tell me what we have to specify in processor like
> any xml file path or etc . can you please attach code of example if you have

I can't see any example checked in. We used to have some example for
the MDX processor, but those must have been deleted at some point.
Since Mondrian supports a standard SOAP interface (XML for Analysis),
I would recommend you use that interface to talk to Mondrian.

If you want to write Java code, and you want to write your own
processor, you may or may not find the code in the MDX processor
useful, but this is not the route that I would explore first.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: OLAP Xforms

Alessandro Vernet
Administrator
On 9/24/07, Smruti Naik <[hidden email]> wrote:
> Actually I need one java processor . also in that java class if i write any
> mdx queries . then i need 1 cube  it must be some xml file. so i just want
> to know that can we specify that xml file name in
> MDX Processor , even i couldnt get your point for SOAP Interface , can you
> help me .?

Do you already have Java code to talk to Mondian? If you do, I
recommend you read the Java processor documentation and put that code
in your own processor which you call from the Java processor in XPL:

http://www.orbeon.com/ops/doc/processors-java

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
http://www.orbeon.com/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws