mondrian
mondrian copied to clipboard
pentaho
Installation issues
Hi, How exactly do you install the latest version of Mondrian(3.6.1)? I stumbled on a Pentaho link and decided to give it a spin. The SF.net download is a precompiled jar, nothing related to the stand-alone WAR and other related files referenced in the documentation here : http://mondrian.pentaho.com/documentation/olap.php
Any pointers as to how I may get it in running in Tomcat?
Thanks
Ah!
I knew I was forgetting something!
Luc, you know what? The latest builds of 3.6.1 no longer have the standalone war so I was unable to upload it to sf.net. People may complain about it. Was that intentional?
:p
-pedro
On Monday, December 9, 2013, Ozioma Ihekwoaba wrote:
Hi, How exactly do you install the latest version of Mondrian(3.6.1)? I stumbled on a Pentaho link and decided to give it a spin. The SF.net download is a precompiled jar, nothing related to the stand-alone WAR and other related files referenced in the documentation here : http://mondrian.pentaho.com/documentation/olap.php
Any pointers as to how I may get it in running in Tomcat?
Thanks
— Reply to this email directly or view it on GitHubhttps://github.com/pentaho/mondrian/issues/202 .
It’s impossible to include a WAR file in the mondrian-4 builds because we no longer include jpivot. Mondrian has gone back to being just a library; you have to supply your own web interface.
But that doesn’t apply to 3.6.x AFAIK.
Julian
I hope I'm not hijacking the thread.
@ozzioma Currently, Pivot4J's web application bundles with Mondrian 3.6.1, which you can download here.
I believe exclusion of the sample web application in the latest Mondrian builds was intentional. But if I'm mistaken, I'll be more than willing to help to make the build script download & reassemble pivot4j.war to include Mondrian's build output and be bundled with the distribution.
Sorry for such a shamelesss plug for my own project :)
I frankly don’t remember when we removed jpivot from mondrian’s distro. As I said, I thought it was only in 4.0. But anyway, our intent was to remove jpivot’s “special” status and to even the playing field for other projects such as pivot4j and saiku.
So, Xavier, your shameless plug is entirely appropriate. May the best UI win!
Julian
@julianhyde maybe a little clarification on the status of Mondrian 3.6.x as a library is in order. I'm guessing the download package was at least tested before release...was almost forwarding the download link to a friend before I checked out the download.
@mysticfall thanks. Will give it a spin.
Thanks for the clarification on the war. That all makes sense, problem is the installation docs[1] are really out of whack here and are leaving us a little confused.
They only talk about using the war (which no longer exists) and no alternatives (such as building your own war) seem to be documented.
We're approaching this as cold newbies who want to setup a data cube with an XML/A interface to Excel but are totally lost.
Any updates on how to achieve this would be greatly received.
[1] http://mondrian.pentaho.com/documentation/installation.php
Here here! I'm doing a Data Mining course at Uni.NSW, Sydney and we're using Mondrian for learning MDX but we're supposed to be using the test data set that did come with Mondrian out of the box? If anyone has instructions on how to get this going I'll pass it on to the class.
In the installation instructions: http://mondrian.pentaho.com/documentation/installation.php#2_2_Non_Access_setup.
You can definitely still use the FoodMart data loader that comes with the project to load the test data in a DB of your choice. As for the lack of a war, I'm looking into what other reasonable options would be good to document for standalone use. Maybe Saiku.
I found the Pivot4j useful.
Also, we created our own project to get xmla working. You can then point Saiku or Pivot4j or whatever at the xmla endpoint. https://github.com/ThoughtWorksInc/mondrian-xmla-spike
We found lots of bugs. Also we had to hardcode a few things (like paths to datasources in web.xml and url hostname etc.).
Very cool. I've also opened up a Mondrian issue in JIRA, http://jira.pentaho.com/browse/MONDRIAN-1945 that covers cleaning up the docs and resolving the issue with the installation instructions no longer being valid.
Hello everyone.
I should probably have answered these questions a long while ago. Sorry if I haven't answered before. I'm not receiving the notifications for some reason.
First off, a big thank you to @petergillardmoss for putting this very neat project together. I'll be taking a bookmark of it and will spread the word. This is a very useful little demo. If you'd like to share the issues that you have alluded to, that'd be great.
Why was JPivot removed? For a few reasons. JPivot is a dead project. Pentaho dropped support for it many years ago and no one has jumped in. There are numerous other projects which replaced it, being either inspired by or created to replace JPivot itself. We have created a marketplace for aid visibility and make installation a breeze and it has worked well so far.
While JPivot has been dead for a while, taking care of the packaging and releases was still part of a painful series of tasks which our build team had to go through for each of our frequent releases. (We release 4 times a year minimum, plus monthly service packs and more). It also introduced circular dependency problems for our build folks and made a lot of things very messy.
We have therefore decided to stop bundling JPivot as part of Mondrian.
But we didn't kill JPivot. We created a plugin for the Pentaho BA platform to offer a minimum support for legacy reports and analysis. (It lives here. https://github.com/pentaho/pentaho-platform-plugin-jpivot )
About support for Microsoft Excel, this is something that we have been actively working on. We are not ready to release anything in that regard yet, but we will give out more information in due time.
Finally, the comments about our holes in the documentation are warranted. Agreed, we have fallen behind a bit. Our docs are spread thin over many places and we have done a lot of refactoring, especially in the XMLA area. We have already started looking internally at how we (the team and the community) produce documentation, how we maintain it and how we publish it and make it available at wide. We already have a few active pilot projects which use a more modern documentation platform and as soon as we have the go ahead, Mondrian will move to this platform as well. We hope that in time our core team members can collaborate live with the community and other internal doc folks and maintain a central brain trust for all that is Mondrian.
Even though we haven't been very vocal about what we're doing behind the scenes, rest assured that we have been active in building a stronger and better organized team behind Mondrian and I expect our efforts to bear fruits in the following weeks.
Cheers
Luc
Hello , can someone help with the instruction to install and use schema workbench ? I am lost since there is no .war anymore in mondrian I spent three hours googling with no clue !! thanks in advance
Folks - what's the conclusion to the original question >> How exactly do you install the latest version of Mondrian ?
The latest stable build of Mondrian, I assume is 3.9.0 ? I just need something working, and it doesnt have to be latest or recent. I just want to evaluate Mondrian.
The installation docs are completely outdated: they reference a WAR but there is no WAR file in the download. This is the only document I could find and it was last updated over 5 years ago in 2009 http://mondrian.pentaho.com/documentation/installation.php
I understand @lucboudreau comments as the WAR is no longer there.. >> We have therefore decided to stop bundling JPivot as part of Mondrian… our holes in the documentation are warranted.
but I just need to know what to do with the JAR file so that I can
- Setup Mondrian against a dataset
- Run OLAP queries ..
The absolute simplest way is to download a build from Pentaho's community pages here: http://community.pentaho.com/
From there you can create your schemas from a web UI and then explore them with the jPivot plugin. Or you can explore your schemas with Rex (Warehouse Explorer) via XMLA: http://sourceforge.net/projects/whex/
@mirtariq, if you want a standalone WAR, perhaps this is of some use: http://lists.pentaho.org/pipermail/mondrian/2014-October/004999.html
Apart from this you might need to take heed of this:
"One additional thing I had to do was to change web.xml and supply a file:// url path to the datasources.xml for the XmlaServlet. Simple WEB-INF/datasources.xml did not work. An URL was required.”
Hope this helps.
The https://github.com/ThoughtWorksInc/mondrian-xmla-spike project mentioned above builds a standalone war using Jetty.
It's a little old now but perhaps it will be some working code which can provide some hints.
So...did anyone actually figure out how to install Mondrian?
Documentation is still outdated, there's little to no information on the internet about making at least something work in Mondrian stand-alone version. Newcomers like me find themselves in rather difficult situation when it's not clear how to even start using and testing Mondrian.
Downloading jar on http://community.pentaho.com/projects/mondrian/ gets me a raw library, what should I do with it as a next step? Any instructions or help is greatly appreciated.
Also evaluating Mondrian, and already on step #2 I hit this... I'll try a bit further with the Pentaho Community edition, but for now penalty points for crappy docs and confirming open-source cliché's ...
Can you, at least, delete the Installation documentation. It is completely false and misleading at this point. If there's no .war file, the rest of the instructions are useless. If Mondrian is a library now, how does one use it? Either way, what's there needs to go. It'll only take a minute to delete it and it'll save hours of wasted time by developers like myself. I don't want to beat up on you guys about documentation, just please don't leave false information out there.
To whom it may concern - I have a working .WAR + sample database + sample cubes + sample client applications (xmla4js - a lib to build your own XML/A OLAP webclients, and xmla4js based applications: Xavier, a GUI and Pash, a web-based MDX command line shell here)
https://github.com/rpbouman/xmondrian
I'm sure lots of improvements are possible - file an issue or better, send a pull request :)
Here are the rough notes I made
Mondrian Setup
Prereq
- Download ANT, and add it’s bin to the PATH
- Download Java, and add it’s bin to PATH
- Setup Tomcat7
edit TOMCATHOME/conf/tomcat-users.xml. Inside the
paste:
(this is probably not required but makes it easier to see if mondrian is correctly deployed)
- This assumes you got the database started and that you loaded the foodmart data.
o EC2 install mysql: sudo yum install mysql-server
o sudo service mysqld start
o mysql
o mysql -u root -p
o mysql> create database foodmart;
o mysql> grant all privileges on . to 'foodmart'@'localhost' identified by 'foodmart';
Ingest Data
Use Mondrian ingestion
java -cp "/usr/share/tomcat7/webapps/mondrian.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/log4j-1.2.12.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/commons-logging.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/eigenbase-xom.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/eigenbase-resgen.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/eigenbase-properties.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/mysql-connector-java-5.1.35-bin.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/olap4j.jar:/usr/share/tomcat7/webapps/mondrian/WEB-INF/lib/*" mondrian.test.loader.MondrianFoodMartLoader -verbose -tables -data -indexes -jdbcDrivers=com.mysql.jdbc.Driver -inputFile=data/FoodMartCreateData.sql -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"
o
o mysql> source createdb.sql mysql> quit
/usr/share/tomcat7/webapps/mondrian/WEB-INF/
Mondrian
-
git clone https://git_URL
-
cd into Mondrian folder
-
- make the war:
-
Copy the war to the webapps folder
-
ant war
11.move log4j-1.2.8.jar out of mondrian/WEBINF/lib
12.Download jars into MONDRIANHOME/WEBINF/lib: (find them at all at http://mvnrepository.com/)
o From MAVEN
§ commons-io-2.4.jar
§ jcl-over-slf4j-1.5.2.jar
§ log4j-1.2.12.jar
§ slf4j-api-1.5.2.jar
§ slf4j-log4j12-1.5.2.jar
o JDBC Jar for the specific database http://dev.mysql.com/downloads/file.php?id=456316
13.MONDRIANHOME/WEBINF/datasources.xml.
o Change the following tags:
<DataSourceName>FoodMart</DataSourceName>
(the xmla tester uses simply FoodMart, not this unwieldly long string that is in there by default)
<URL>http://localhost:8080/mondrian/xmla</URL> (for some reason, the
default uses a funny port)
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost:3306/foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver</DataSourceInfo>
(adjust this to fit your jdbc driver, jdbc url, and database credentials)
Modify the <Definition> inside <Catalogs> / <Catalog name="FoodMart"> to
<Definition>file:///home/roland/apache-tomcat-7.0.56/webapps/mondrian/WEB-INF/queries/FoodMart.xml</Definition>
(obviously, modify the absolute path to fit your location of the Foodmart.xml file)
13a) Edit MONDRIANHOME/WEBINF/web.xml and modify lines 86..101 to read:
(Only the contents of the
ᐧ
On Fri, Jan 8, 2016 at 2:46 PM, Roland [email protected] wrote:
To whom it may concern - I have a working .WAR + sample database + sample cubes + sample client applications (xmla4js - a lib to build your own XML/A OLAP webclients, and xmla4js based applications: Xavier, a GUI and Pash, a web-based MDX command line shell here)
https://github.com/rpbouman/xmondrian
I'm sure lots of improvements are possible - file an issue or better, send a pull request :)
— Reply to this email directly or view it on GitHub https://github.com/pentaho/mondrian/issues/202#issuecomment-170148691.
Thanks -Mir
I'm going to give that .war a shot. Thanks. I'll report back on how it goes. If it goes well, a link could be added to the docs.
@RogerWebb let me know how it goes! I really want to help to make it easy to install mondrian, and to get set up. Currently I create the war from a mondrian that I build locally, and I grab any necessary jars from there. It would be much better of course if this could be "mavenized" but I currently don't have the time to make that work properly. But I'm happy to share my buildscripts if that helps.
Always feel free to shoot me a mail at [email protected]
Best, Roland.
@rpbouman I am happy to report that the .war you supplied works great. It would be great if that, or a similar setup, could be distributed alongside the .jar version (for those who want to use it as a library). I can understand how a 1 size fits all bundle won't work for most folks, but if a war is going to be referenced in the docs, it'd be good to have one available for distribution. Thanks everyone for the helpful suggestions.
Hi Roger! Thank you so much for letting me know! It is much appreciated :)
The war is just a pet project of mine. On the one hand, I want to make it easy for people to get to know mondrian, on the other hand, I want to advertise my client applications, and a canned mondrian instance is a great platform to do so.
Personally, I would like it better if pentaho would keep providing a functional war. But they haven't been doing that for over a while, and frankly I don't see any indication that they intend to repair that situation in the future. So I'm afraid the future for standalone Mondrian lies outside Pentaho. (As much as I would like it to be inside)
On Mon, Jan 11, 2016 at 11:59 PM, Roger Webb [email protected] wrote:
@rpbouman https://github.com/rpbouman I am happy to report that the .war you supplied works great. It would be great if that, or a similar setup, could be distributed alongside the .jar version (for those who want to use it as a library). I can understand how a 1 size fits all bundle won't work for most folks, but if a war is going to be referenced in the docs, it'd be good to have one available for distribution. Thanks everyone for the helpful suggestions.
— Reply to this email directly or view it on GitHub https://github.com/pentaho/mondrian/issues/202#issuecomment-170724757.
Roland Bouman blog: http://rpbouman.blogspot.com/ twitter: @rolandbouman linkedin: http://www.linkedin.com/profile/view?id=5142800&trk=tab_pro
Author of "Pentaho Solutions" (Wiley, ISBN: 978-0-470-48432-6 http://tinyurl.com/lvxa88) and "Pentaho Kettle Solutions" (Wiley, ISBN: 978-0-470-63517-9 http://tinyurl.com/33r7a8m)