<%@ 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: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=Honda_Leasing_myHR1;user=myhradmin;password=systemadmin" catalogUri="/WEB-INF/queries/myHR.xml">


select {[Measures].[ageAll] , 
	[Measures].[age1], [Measures].[age1Percentage] , 
	[Measures].[age2], [Measures].[age2Percentage] , 
	[Measures].[age3],  [Measures].[age3Percentage] , 
	[Measures].[age4], [Measures].[age4Percentage] , 
	[Measures].[age5], [Measures].[age5Percentage] ,
	[Measures].[age6], [Measures].[age6Percentage] , 
	[Measures].[age7], [Measures].[age7Percentage] ,
	[Measures].[age8], [Measures].[age8Percentage] ,
	[Measures].[age9], [Measures].[age9Percentage] ,
	[Measures].[age10] , [Measures].[age10Percentage]} ON COLUMNS , 
  {[bu2.bu2].[All bu2]} ON ROWS
from [EmployeeAge]

</jp:mondrianQuery>

<c:set var="title01" scope="session">myHR...Employee age</c:set>