<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %> <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> <%-- uses mysql --%> <%-- jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost/foodmart" catalogUri="/WEB-INF/queries/FoodMart.xml"--%> <%-- uses a role defined in FoodMart.xml --%> <%-- jp:mondrianQuery role="California manager" id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:MondrianFoodMart" catalogUri="/WEB-INF/queries/FoodMart.xml" --%> <%-- <jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:kubota;UID=myhradmin;PWD=systemadmin" catalogUri="/WEB-INF/queries/myHR.xml"> --%> <%-- <jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:myhr_sql;UID=sa" catalogUri="/WEB-INF/queries/myHR.xml"> --%> <%-- <jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:myhr_oracle;UID=myhradmin;PWD=systemadmin" catalogUri="/WEB-INF/queries/myHR.xml"> --%> <jp:mondrianQuery id="query01" jdbcDriver="net.sourceforge.jtds.jdbc.Driver" jdbcUrl="jdbc:jtds:sqlserver://myhr-app;DatabaseName=MYKKBDB;user=myhradmin;password=systemadmin" catalogUri="/WEB-INF/queries/myHR.xml"> select Crossjoin({[bu2_e.bu2].[all bu2]}, {[Measures].[EmpCost], [Measures].[empCostPercentage], [Measures].[FamilyCost], [Measures].[FamilyCostPercentage], [Measures].[Cost], [Measures].[CostPercentage]}) ON COLUMNS, {([time.year1].[all time1].[2008], [sitewel.sitewel].[all sitewel])} ON ROWS from [EmployeeErCost] </jp:mondrianQuery> <c:set var="title01" scope="session">myHR...ER Cost</c:set>