hsqldbconfig.xml

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

<crosstab xmlns="http://www.pocolap.com">
	<rept name="Sales Sample" index="59">
		<!-- This is the config file for the HSQLDB 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.hsqldb.jdbcDriver" dbString="jdbc:hsqldb:${}/nss" user="sa" pass="" />
		<measure name="Sold Items" table="SALES" key="AMOUNT" function="sum" />
		<dimension name="Customers" table="CUSTOMERS" key="CUSTOMERID" measureKey="CUSTOMERID">
			<group name="Customer" defaultField="Customer Last Name">
				<field name="Customer Last Name" key="LASTNAME" />
				<!-- other fields are to be used when formatting is implemented -->
				<field name="Customer Number" key="CUSTOMERNUMBER" />
				<drilldown>Shoe Size</drilldown>
			</group>
			<group name="Customer Origin" defaultField="Zip Code">
				<field name="Zip Code" key="ZIP" />
				<field name="City" key="CITY" />
				<drilldown>Customer</drilldown>
			</group>
			<group name="Shoe Size">
				<field name="Shoe Size" key="SHOESIZE" />
				<field name="Size Type" key="SIZINGGENDER" />
				<field name="Extra Width" key="WIDESIZES" />
			</group>
		</dimension>
		<dimension name="Items to Sell" table="SALABLEITEMS" key="SALABLEITEMSID" measureKey="SALABLEITEMSID">
			<group name="Stock Keeping Unit">
				<field name="SKU Value" key="SKU" />
				<field name="Product Desription" key="DESCRIPTION" />
				<field name="Product or Service" key="ISPRODUCT" />
				<drilldown>Vendor</drilldown>
			</group>
			<group name="Vendor">
				<field name="Vendor Name" key="VENDOR" />
				<field name="Vendor Number" key="VENDORNUMBER" />	
				<drilldown>Stock Keeping Unit</drilldown>
			</group>
		</dimension>
		<dimension name="Dates" table="CALENDAR" key="CALENDARID" measureKey="CALENDARID">
			<group name="Sale Date">
				<field name="Date" key="DAYDATE" />
			</group>
			<group name="Month" defaultField="Month">
				<field name="Number of Month" key="MONTHOFYEAR" />	
				<field name="Month" key="MONTHNAME" />
				<field name="Abbreviated Month" key="MONTHABBREV" />
				<drilldown>Sale Date</drilldown>
			</group>
			<group name="Year">
				<field name="Year" key="YEAR" />
				<drilldown>Month</drilldown>
				<drilldown>Sale Date</drilldown>
			</group>
		</dimension>
		<supplemental>
			<description>This shows sales data stored in an HSQLDB database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
		</supplemental>
	</rept>
</crosstab>