Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to import demo data into mysql in mondrian. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1. First decompress the mondrian-3.3.0/lib/mondrian.war

Then run the following command

Note:

Www.2cto.com

The red part of the jar package needed to run, must use the absolute path, pay attention to modify the version number of the corresponding jar package.

-inputFile=FoodMartCreateData.sql, because I am running in the mondrian-3.3.0/demo directory, and FoodMartCreateData.sql is in this directory, so the path here is the relative path. If you run the following command in another directory, you need to change the sql file path name.

Java-cp "JTX softwareUniverse MondrianMurray 3.3.0Universe LBTX MondrianUniver OLap4j.JARTY JTY JTY TN MondrianMon drian.JarTX JTX JTX Mondrian Universe MondrianMon True 3.3.0libUniverse MondrianUniverse log4jMY 1.2.8.JartJTX JTX MondrianUniv MondrianUniverse loggingMet 1.0.4.jarth JTY LBTY MondrianMondrianMon 3.0Get / software/mondrian-3.3.0/lib/mondrian/eigenbase-resgen.jar;J;/software/mondrian-3.3.0/lib/mondrian/eigenbase-properties.jar;J;/software/mondrian-3.3.0/lib/mondrian/mysql-connector-java-5.1.19.jar "

Www.2cto.com

Mondrian.test.loader.MondrianFoodMartLoader

-verbose

-tables

-data

-indexes

-jdbcDrivers=com.mysql.jdbc.Driver

-inputFile=FoodMartCreateData.sql

-outputJdbcURL= "jdbc:mysql://192.168.0.187:3306/foodmart?user=root&password=111111"

The above is how to import demo data into mysql in the mondrian shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.