准备

?#1 下载mondrian 3.14 war包

该压缩包含mondrian 3.14及tomcat8.5.9，详细见如下分享链接：

链接：https://pan.baidu.com/s/1KQopFKvYB1fzSDtAOfLKmg

提取码：9dtp

#2 初始化foodmart数据库

#1 下载mondrian

SourceForge.net里下载mondrian-3.3.0.14703

#2 执行数据库初始化，这里

java -cp D:\FoodMart\mondrian.jar;D:\FoodMart\log4j-1.2.8.jar;D:\FoodMart\commons-logging-1.0.4.jar;D:\FoodMart\eigenbase-xom.jar;D:\FoodMart\eigenbase-resgen.jar;D:\FoodMart\eigenbase-properties.jar;D:\FoodMart\mysql-connector-java-5.1.20-bin.jar;D:\FoodMart\olap4j.jar;D:\FoodMart\mysql-connector-java-5.1.19.jar mondrian.test.loader.MondrianFoodMartLoader -verbose -tables -data -indexes -jdbcDrivers="com.mysql.jdbc.Driver" -inputFile=D:\FoodMart\FoodMartCreateData.sql -outputJdbcURL="jdbc:mysql://localhost:3309/foodmart?user=root&password=root1234

# 详细见

Mondrian mysql版数据初始化https://blog.csdn.net/shenliang1985/article/details/122980468?spm=1001.2014.3001.5501

配置mondrian

#1 解压到指定的目录

# 当前是ubuntu环境，

/root/software/apache-tomcat-8.5.9/

# 2 赋予可执行权限

catalina.sh、shutdown.sh、startup.sh 赋予可执行权限

如：

chmod +x catalina.sh

#3 修改jsp里的jdbc链接信息

将apache-tomcat-8.5.9/webapps/jpivot/WEB-INF/queries下的arrows.jsp和colors.jsp里的jdbc信息修改为mysql的。详细见下：

<jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost:3306/foodmart" jdbcUser="root" jdbcPassword="root1234" catalogUri="/WEB-INF/queries/FoodMart.xml" connectionPooling="false">

#4 回到Tomcat的bin目录下启动Tomcat

/root/software/apache-tomcat-8.5.9/bin

root@slave2:~/software/apache-tomcat-8.5.9/bin# ./startup.sh

验证

#1 输入访问地址

这里为localhost:8080/jpivot/

#2点击Colors in Cells

#3 选择指标和维度对应的值后点击确定?

#4 点击+号下钻取更多数据。

#5 SQL验证

-- 取得产品名称为'Good Imported Beer','Good Light Beer'的成本、销售额及盈利额。
SELECT B.product_name
,round(SUM(store_cost),2) store_cost
,round(sum(store_sales),2) store_sales
,round(sum(store_sales)-SUM(store_cost),2) profit
FROM sales_fact_1997 A
JOIN product B
ON A.product_id = B.product_id
	AND B.product_name IN ('Good Imported Beer','Good Light Beer')
JOIN customer C
ON A.customer_id = C.customer_id
AND C.gender ='F'
GROUP BY B.product_name