Mondrian imports demo data to mysql_MySQL

Mondrian imports demo data to mysql bitsCN.com
Mondrian has not moved mondrian since importing demo data to mysql for a long time. many steps have been forgotten. at the same time, the steps for the old version and the new version are somewhat different. this time, you need to use mondrian3.3, so I will install to use each process to record, for query: Environment: windows: version: mondrian-3.3.0 1. first unzip the mondrian-3.3.0/lib/mondrian. war and then run the following command. note: the red part is the jar package required for running, and the absolute path must be used. modify the version number of the corresponding jar package. -InputFile = FoodMartCreateData. SQL, because I am running under the mondrian-3.3.0/demo directory, and FoodMartCreateData. SQL is in this directory, so the path here is relative path. if you run the following command in another directory, you need to modify the path name of the SQL file. Java-cp & quot; J;/software/mondrian-3.3.0/lib/mondrian/olap4j. jar; J;/software/mondrian-3.3.0/lib/mondrian. jar; J;/software/mondrian-3.3.0/lib/mondrian/log4j-1.2.8.jar; J;/software/mondrian-3.3.0/lib/mondrian/commons-logging-1.0.4.jar; J; /software/mondrian-3.3.0/lib/mondrian/eigenbase-xom.jar; J;/software/mondrian-3.3.0/lib/mondrian/eigenbase-resgen.jar; J;/software/mondrian-3.3.0/lib/mondrian/eigen Base-properties.jar; J;/software/mondrian-3.3.0/lib/mondrian/mysql-connector-java-5.1.19.jar "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 "it takes 1-2 minutes to run the preceding command. wait patiently and check the foodmart database to see many tables. This indicates that the import is successful. The next step is to set mondrian datasource to point to the mysql instance. Author's four circles: bitsCN.com