time_current.jsp 886 Bytes
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
<%@ 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 NON EMPTY {[Measures].[Employee], [Measures].[lt_count], [Measures].[lt], [Measures].[lv], [Measures].[ot1], [Measures].[ot15], [Measures].[ot2], [Measures].[ot3], [Measures].[source_in]} ON COLUMNS,
  NON EMPTY Hierarchize(Union({[position.position].[all position]}, [position.position].[all position].Children)) ON ROWS
from [time_current]



</jp:mondrianQuery>

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