<%@ page session="true" contentType="text/html; charset=UTF-8" %> <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> <% response.setCharacterEncoding("UTF-8"); %> <%-- 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 id="query01" jdbcDriver="net.sourceforge.jtds.jdbc.Driver" jdbcUrl="jdbc:jtds:sqlserver://myhr-app;DatabaseName=Honda_Leasing_myHR1;user=myhradmin;password=systemadmin" catalogUri="/WEB-INF/queries/myHR.xml"> select Crossjoin({[bu2.bu2].[All bu2]}, {[Measures].[Employee], [Measures].[Percentage]}) ON COLUMNS, {[emp_type.emp_type].[all emp_type]} ON ROWS from [Employee] where [status.status].[all status].[Active] </jp:mondrianQuery> <c:set var="title01" scope="session">myHR...Employee</c:set>
