|
From: todd r. <to...@us...> - 2005-03-31 20:58:39
|
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=""year"" /> <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> |