Mondrian imports demo data to mysql

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 of www.2cto.com is the jar package required for running. The absolute path must be used. Note that you must 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 "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 "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