mondrian.olap4j.MondrianOlap4jDriver jdbc:mondrian4: foodmart foodmart jdbc:mysql://localhost:3306/foodmart_mondrian_4 com.mysql.jdbc.Driver solution:/public/Foodmart/FoodMart3.mondrian.xml Sample query on Foodmart Sales select {[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY [Time].[Time].[1997].Children ON ROWS from [Sales] where ([Product].[${productfamily}]) Quarter price PriceInK =[price]/1000000