Mondrian

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(Links)
第46行: 第46行:
 
*http://docs.huihoo.com/javadoc/mondrian
 
*http://docs.huihoo.com/javadoc/mondrian
 
*http://download.huihoo.com/mondrian
 
*http://download.huihoo.com/mondrian
 +
 +
{{Comment}}
  
 
[[Category:BI]]
 
[[Category:BI]]
 +
[[Category:OLAP]]

2010年9月9日 (四) 09:42的版本

Mondrian is an Online Analytical Processing (OLAP) server written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL.

It executes queries written in the MDX language, reading data from a relational database (RDBMS), and presents the results in a multidimensional format via a Java API.

Mondrian Architecture

目录

Install

wget http://download.huihoo.com/mondrian/mondrian-2.4.2.9831-derby.zip
unzip mondrian-2.4.2.9831-derby.zip
explode lib/mondrian-embedded.war to TOMCAT_HOME/webapps/mondrian-embedded
Start up Tomcat
Hit http://localhost:8080/mondrian-embedded

olap4j

Mondrian 3.0 includes olap4j 0.9.6 along with significant improvements to security and additional function support.

PostgreSQL

C:\mondrian> java -cp "C:\mondrian\lib\mondrian.jar;C:\mondrian\lib\log4j-1.2.9.jar; C:\mondrian\lib\eigenbase-xom.jar;  
C:\mondrian\lib\eigenbase-resgen.jar; C:\mondrian\lib\eigenbase-properties.jar; C:\mondrian\lib\postgres-jdbc.jar"
    mondrian.test.loader.MondrianFoodMartLoader
    -verbose -tables -data -indexes
    -jdbcDrivers="org.postgresql.Driver,sun.jdbc.odbc.JdbcOdbcDriver"
    -inputJdbcURL="jdbc:odbc:MondrianFoodMart"
    -outputJdbcURL="jdbc:postgresql://localhost/foodmart"
    -outputJdbcUser=postgres
    -outputJdbcPassword=password

MySQL

$ mysqladmin create foodmart
mysql> grant all privileges on foodmart.* to foodmart@localhost identified by 'foodmart';
mysql> flush privilegs;
$ java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j-1.2.9.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar
:/mondrian/lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar"
        mondrian.test.loader.MondrianFoodMartLoader
        -verbose -tables -data -indexes
        -jdbcDrivers=com.mysql.jdbc.Driver
        -inputFile=/mondrian/demo/FoodMartCreateData.sql
        -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart" 

或下载: http://download.huihoo.com/mondrian/create-foodmart-mysql.zip

Apache Derby

Pentaho

Mondrian Schema Workbench (Pentaho Analysis schema design)

Code

Pentaho packages detail: http://docs.huihoo.com/javadoc/mondrian/3.0.4/

Links

Comment-32x32.png

<discussion>characters_max=300</discussion>

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱