[Pocolap-cvscommit] pocolap/data/pocolapDB/crosstabdefs hsqldbconfig.xml,NONE,1.1 derbyconfig.xml,NONE,1.1

[todd r. <to...@us...>]

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/crosstabdefs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/crosstabdefs

Added Files:
	hsqldbconfig.xml derbyconfig.xml 
Log Message:
Reorganization of resources

--- NEW FILE: derbyconfig.xml ---
<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" />					
				</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 data stored in a Derby database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
		</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>

--- NEW FILE: hsqldbconfig.xml ---
<crosstab xmlns="http://www.pocolap.com">
	<rept name="Alternative SpreadSheet" 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 data stored in an HSQLDB database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
		</supplemental>
	</rept>
</crosstab>