gpa.jsp

<%@ 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="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].[grade1], 
[Measures].[grade1Percentage], 
[Measures].[grade2], 
[Measures].[grade2Percentage], 
[Measures].[grade3], 
[Measures].[grade3Percentage], 
[Measures].[grade4], 
[Measures].[grade4Percentage], 
[Measures].[grade5], 
[Measures].[grade5Percentage], 
[Measures].[grade6], 
[Measures].[grade6Percentage]} ON COLUMNS,
  Hierarchize({[bu2_e.bu2].[all bu2]}) ON ROWS
from [gpa]

</jp:mondrianQuery>

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