Is it possible to process and query mondrian cubes without deploying to pentaho bi-server?

Question

If yes, please give a reference. I did a little googling with no result. I want to use olap4j to query the cubes and use the result in a web application. But, I don't need any of the features of bi-server. According to tutorials, the olap schemas have to be published on an instance of bi-server. So isn't it really possible to have cubes built, processed and queried independently?

Try a pure javascript pivot table component at [webpivottable](http://webpivottable.com) . Here is the [demo](http://webpivottable.com/demo) . No plugin, no back end dependence. It connect to XMLA service directly and have MDX mode. — Sean Zhao, Sep 25 '13 at 15:53

score 3 · Answer 1 · answered Oct 29 '12 at 16:02

3

Take a look at Saiku - this will handle the server side of mondrian for you and is built from the ground up for integration, so may be easier than using olap4j directly ( saiku itself uses olap4j of course)

answered Oct 29 '12 at 16:02

Codek

5,114
3
24
38

score 2 · Accepted Answer · answered Dec 05 '12 at 15:19

2

Olap4j is the main programming API for Mondrian. You do not need a Pentaho BI server to use Mondrian. You should read this tutorial to get you started.

answered Dec 05 '12 at 15:19

Luc

672
3
8

Hi @Luc the link is no more available dear, can you please update it – Sohail Anwar Feb 24 '20 at 13:16

score 1 · Answer 3 · answered Nov 13 '12 at 22:04

1

Do you mean you just want to use API functions of mondrian.jar in java class or servlet, instead of via JSP page?

answered Nov 13 '12 at 22:04

bhuang3

3,493
2
17
17

score 1 · Answer 4 · answered Dec 21 '12 at 11:51

1

You can deploy the .xml file in tomcat server or saiku server and run it.

answered Dec 21 '12 at 11:51

Rudra

711
7
13
31

Is it possible to process and query mondrian cubes without deploying to pentaho bi-server?

4 Answers4