derbyconfig.xml

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your

<crosstab xmlns="http://www.pocolap.com">
	<rept name="Employee Hours Sample" index="58">
		<!-- This is the config file for the Sample database that
      		comes with pocolap.  This should be placed in the 
      		pocolapDB/crosstabdefs directory if you would like 
      		to use the sample database.  You may remove this 
      		file if you do not want to use the sample database.
    	--> 
		<source classtype="com.pocolap.conn.PocOlapSampleDatabaseConnection" driver="org.apache.derby.jdbc.EmbeddedDriver" dbString="jdbc:derby:;databaseName=${}"/>
		<measure name="Hours Worked" table="LABORHOURS" key="HOURS" function="sum" />
		<dimension name="Employees" table="EMPLOYEES" key="EMPID" measureKey="EMPID">
				<group name="Employee" defaultField="Employee Last Name">
						<field name="Employee Last Name" key="LASTNAME" />						
						<drilldown>Position</drilldown>						
				</group>
				<group name="Position">
						<field name="Position" key="POSITION" />	
						<drilldown>Employee</drilldown>
						<drilldown>Status</drilldown>
				</group>
				<group name="Status">
						<field name="Status" key="STATUS" />												 
						<field name="Paid Weekly" key="ISPAIDWEEKLY" />					
						<drilldown>Position</drilldown>
						<drilldown>Employee</drilldown>
				</group>
		</dimension>
		
		<dimension name="Work Items" table="WORKITEMS" key="ITEMID" measureKey="ITEMID">
				<group name="Work Item">					
					<field name="Work" key="WORKNAME" />
					<drilldown>Customer Contact</drilldown>					
				</group>
				<group name="Customer Contact">
					<field name="Customer Contact" key="CUSTOMERCONTACT" />
					<drilldown>Work Item</drilldown>
				</group>
		</dimension>
		
		<dimension name="Work Types" table="WORKTYPES" key="TYPEID" measureKey="TYPEID">
				<group name="Work Type">					
					<field name="Type" key="TYPENAME" />					
				</group>
				<group name="Is Overtime">
					<field name="Is Overtime" key="ISOVERTIME" />
				</group>
		</dimension>
		<dimension name="Dates" table="CALENDAR" key="CALENDARID" measureKey="CALENDARID">
				<group name="Work Date">
					<field name="Date" key="DAYDATE" />
				</group>
				<group name="Month" defaultField="MONTH">
					<field name="Month" key="MONTHNAME" />
					<field name="Abbreviated Month" key="MONTHABBREV" />
					<drilldown>Work Date</drilldown>
				</group>
				<group name="Month Number">
					<field name="Number of Month" key="MONTHOFYEAR" />	
					<drilldown>Month</drilldown>
					<drilldown>Work Date</drilldown>
				</group>
				<group name="Year">
					<field name="Year" key="&quot;year&quot;" />
					<drilldown>Month Number</drilldown>
					<drilldown>Month</drilldown>
					<drilldown>Work Date</drilldown>
				</group>
		</dimension>
		
		<supplemental>
			<description>This shows employee labor data stored in a Derby database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
			<pdfConfig display="true"/>				
		</supplemental>
		
	</rept>
	<savedreport name="Inventory Week">
		<selector>
			<selectordimension across="Employees" down="Work Items" />
			<across name="Position" index="1" />
			<across name="Employee" index="2" />
			<down name="Work Item" index="1" />
		</selector>
		<filter>
			<table name="Dates">
				<field name="Date" type="date">
					<range startvalue="2003-01-28" endvalue="2003-02-01" />
				</field>
			</table>
		</filter>
	</savedreport>
</crosstab>