Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/scripts_tools/outdated Added Files: MANIFEST.MF sampleconfig.xml testPage.jsp config.xml build.xml setupNSS.sql web.xml CaseConverter.pl Log Message: Reorganization of resources --- NEW FILE: MANIFEST.MF --- Manifest-Version: 1.0 Created-By: TaR --- NEW FILE: build.xml --- <project name="Package MCS site" basedir="." default="run"> <property name="zipFile" value="site.zip" /> <property name="buildDir" value="build" /> <property name="topDir" value="../../" /> <property name="srcDir" value="${topDir}/src" /> <property name="binDir" value="${topDir}/bin" /> <property name="cpj2ee" value="/opt/eclipse/jars/j2ee.jar" /> <!--<property name="cpxerces" value="/opt/eclipse/jars/xercesImpl.jar:/opt/eclipse/jars/xmlParserAPIs.jar" /> --> <property name="cpxerces" value="/opt/eclipse/jars/oldXerces.jar" /> <target name="run"> <antcall target="populateBuild" /> <antcall target="zip" /> </target> <target name="populateBuild" depends="cleanBuild"> <javac description="compile source code to classes directory" srcdir="${srcDir}" destdir="${buildDir}/WEB-INF/classes" excludes="**/Test*" classpath="com.pocolap.**:${cpj2ee}:${cpxerces}" /> <copy todir="${buildDir}" description="copy jsp pages"> <fileset dir="${srcDir}/jsps" includes="*.jsp,Error.html" excludes="jspRedirector.jsp" /> </copy> <copy todir="${buildDir}/WEB-INF/tlds" description="copy tld"> <fileset dir="${srcDir}/tlds" includes="*" /> </copy> <copy todir="${buildDir}/WEB-INF" description="copy descriptor (web.xml)"> <fileset dir="." includes="web.xml" /> </copy> <copy todir="${buildDir}/META-INF" description="copy manifest"> <fileset dir="." includes="MANIFEST.MF" /> </copy> <copy todir="${buildDir}/scripts" description="copy js and css files"> <fileset dir="${srcDir}/scripts" includes="*" /> </copy> <copy todir="${buildDir}/config" description="copy config file"> <fileset dir="." includes="config.xml" /> </copy> </target> <target name="zip" description="Bundle build into a zip file"> <zip destfile="${zipFile}" basedir="${buildDir}" /> </target> <target name="cleanBuild"> <delete dir="${buildDir}" /> <mkdir dir="${buildDir}" /> <mkdir dir="${buildDir}/META-INF" /> <mkdir dir="${buildDir}/WEB-INF" /> <mkdir dir="${buildDir}/WEB-INF/classes" /> <mkdir dir="${buildDir}/WEB-INF/tlds" /> <mkdir dir="${buildDir}/scripts" /> <mkdir dir="${buildDir}/config" /> </target> <target name="cleanAll"> <delete dir="${buildDir}" /> </target> </project> --- NEW FILE: config.xml --- <reptconfig> <rept name="Sales SpreadSheet"> <source classtype="com.pocolap.conn.StandardJDBC" driver="org.gjt.mm.mysql.Driver" user="nssUser" pass="nssPass">jdbc:mysql://localhost:3306/nss</source> <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> </dimension> </rept> </reptconfig> --- NEW FILE: testPage.jsp --- <%@page language="java" import="java.sql.*"%> <%! Driver driver = null; String dbURL = null; Connection conn = null; Statement stat = null; ResultSet rs = null; Object rsValue = null; int counter; String query = "select * from \"CUSTOMERS\";"; %> <% try { driver = (Driver) Class.forName("org.hsqldb.jdbcDriver").newInstance(); dbURL = "jdbc:hsqldb:" + application.getRealPath("/~pocolap/nss/nss"); conn = DriverManager.getConnection(dbURL,"nssUser", "nssPass"); stat = conn.createStatement(); rs = stat.executeQuery(query); } catch (Exception e) { out.print("Unable do make connection to customers"); out.print(e); } %> <html> <head> <title>Test Page</title> <meta http-equiv="Content-Type" content="text/html; charset="> </head> <body bgcolor="#FFFFFF" text="#000000"> <h3>Test Page<br> </h3> <table border="1"><tr><td>ID</td><td>NAME</td></tr> <% if (rs!=null){ if (rs.next()){ StringBuffer buffer = new StringBuffer("<tr><td>"); Object id = rs.getObject(1); Object name = rs.getObject(2); if (id==null){ //id = "null"; buffer.append("null"); }else{ buffer.append(id.toString()+" "); } buffer.append("</td><td>"); if (name==null){ buffer.append("null"); }else{ buffer.append(name.toString()+" "); } buffer.append("</td></tr>"); out.println(buffer.toString()); }else{ out.println("No rows for " + application.getRealPath("/~pocolap/nss/nss")); } }else{ out.println("it's null"); } try{ rs.close(); stat.close(); conn.close(); }catch(Exception e){ //ignore } %> </table> Done </body </html> --- NEW FILE: CaseConverter.pl --- #! /usr/bin/perl ########################## # # This script creates config.xml by # copying sampleconfig.xml and # converting all "table" and "key" # entries to uppercase since HSQLDB # converts everything whether you # want it to or not. # ########################### $origfile = "sampleconfig.xml"; $config = "config.xml"; open (ORIG, "<", $origfile) || die "Couldn't open original file"; open (CONFIG, ">", $config) || die "Couldn't open config file"; while (defined ($str=<ORIG>)){ if ($str =~ /table=\"/ || $str =~ /key=\"/){ @tokens = split(/ /,$str); foreach my $token (@tokens){ if ($token =~ /table=\"/ || $token =~ /key=\"/ || $token =~ /measureKey=\"/ ){ $token =~ s/\"(\w+)\"/\"\U$1\"/g; } print CONFIG "$token "; } }else{ print CONFIG $str; } } close(ORIG); close(CONFIG); print 'Done'; --- NEW FILE: setupNSS.sql --- create database if not exists nss; use nss; drop table if exists `customers`; drop table if exists `salableitems`; drop table if exists `calendar`; drop table if exists `sales`; create table `customers`( `customerid` int unsigned auto_increment primary key , `customerNumber` int, `firstName` varchar(50) null, `lastName` varchar(50) default ' ' not null , `address` varchar(100) null, `city` varchar(60) null, `stateName` varchar(50) null, `stateAbbrev` char(2) null, `zip` varchar (15) null, `phone` varchar(25) null, `birthdate` date null, `sizingGender` varchar(20) default 'mens' not null , `shoesize` float null, `wideSizes` bit default '0' not null ); create table `salableitems`( `salableitemsid` int unsigned auto_increment primary key , `sku` int default '0' not null, `description` varchar(50) default ' ' not null, `isProduct` bit default '0' not null, `isSizeDependant` bit default '0' not null, `color` varchar(30) default 'none' not null, `vendor` varchar(80) default ' ' not null, `vendorNumber` int default '0' not null); create table `calendar`( `calendarid` int unsigned auto_increment primary key, `dayDate` date default '1950-01-01' not null, `dayName` varchar(12) default ' ' not null, `dayAbbrev` char(3) default ' ' not null, `dayOfWeek` int default '0' not null, `dayOfMonth` int default '0' not null, `monthName` varchar(12) default ' ' not null, `monthAbbrev` char(3) default ' ' not null, `monthOfYear` int default '0' not null, `year` int default '0' not null, `isHoliday` bit default '0' not null, `wasOpened` bit default '0' not null); create table `sales`( `customerid` int default '0' not null, `salableitemsid` int default '0' not null, `calendarid` int default '0' not null, `amount` float default '0' not null, `webSale` bit default '0' not null); GRANT select,insert,delete,update on nss.* to nssUser@localhost identified by 'nssPass'; insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (17, 'Tom', 'Ling', '112 SomeStreet', 'Portland', 'Oregon', 'OR', '97201', '503-555-1233', '1962-02-25','mens','7.5', '0'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (19, 'Sammy', 'Hamm', '4102 W. First', 'Portland', 'Oregon', 'OR', '97210', '503-555-4754', '1964-10-04','mens','9.0', '1'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (24, 'Sarah', 'Weston', '421 Sideline St. Apt #4', 'Lake Oswego', 'Oregon', 'OR', '97035', '503-555-8874', '1974-03-21','mens','8.0', '0'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (25, 'Lisa', 'Weston', '421 Sideline St. Apt #4', 'Lake Oswego', 'Oregon', 'OR', '97035', '503-555-8874', '1991-10-07','girls','2.0', '0'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (26, 'Bill', 'Franklin', '801 Lake Ave.', 'Portland', 'Oregon', 'OR', '97202', '503-555-4120', '1965-09-21','mens','10.0', '0'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (28, 'Wilma', 'Barkley', '7021 SW 66th', 'Tigard', 'Oregon', 'OR', '97224', '503-555-4998', '1975-09-21','womens','7.0', '0'); insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`, `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) values (29, 'Walter', 'McClellan', '10425 Walling Cir', 'West Linn', 'Oregon', 'OR', '97068', '503-555-8856', '1938-02-29', 'mens','8.5', '1'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234001', '36" laces', '1', '0', 'Brown', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234002', '36" laces', '1', '0', 'Black', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234003', '36" laces', '1', '0', 'Beige', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234004', '36" laces', '1', '0', 'White', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234011', '54" laces', '1', '0', 'Brown', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234012', '54" laces', '1', '0', 'Black', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234013', '54" laces', '1', '0', 'Beige', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('234014', '54" laces', '1', '0', 'White', 'Laces USA', '78778'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('170211', 'odor insoles', '1', '1', 'none', 'feeterEater', '117'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('170211', 'cushioned insoles', '1', '1', 'none', 'feeterEater', '117'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('170211', 'cushioned odor insoles', '1', '1', 'none', 'feeterEater', '117'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42187', 'Polish', '1', '0', 'Black', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42188', 'Polish', '1', '0', 'Brown', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42189', 'Polish', '1', '0', 'Tan', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42190', 'Polish', '1', '0', 'Beige', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42191', 'Polish', '1', '0', 'Red', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('42192', 'Polish', '1', '0', 'Blue', 'Shine Right', '4242'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('100', 'Restitch', '0', '0', 'none', 'Self', '1'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('101', 'Glue', '0', '0', 'none', 'Self', '1'); insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`, `color`,`vendor`,`vendorNumber`) values ('102', 'Shine', '0', '0', 'none', 'Self', '1'); insert into `calendar` (`dayDate`) values ('2002-12-29'); insert into `calendar` (`dayDate`) values ('2003-01-05'); insert into `calendar` (`dayDate`) values ('2003-01-12'); insert into `calendar` (`dayDate`) values ('2003-01-19'); insert into `calendar` (`dayDate`) values ('2003-01-26'); insert into `calendar` (`dayDate`) values ('2003-02-02'); insert into `calendar` (`dayDate`) values ('2003-02-09'); insert into `calendar` (`dayDate`) values ('2003-02-16'); insert into `calendar` (`dayDate`) values ('2003-02-23'); insert into `calendar` (`dayDate`) values ('2003-03-02'); insert into `calendar` (`dayDate`) values ('2003-03-09'); insert into `calendar` (`dayDate`) values ('2003-03-16'); insert into `calendar` (`dayDate`) values ('2003-03-23'); insert into `calendar` (`dayDate`) values ('2003-03-30'); insert into `calendar` (`dayDate`) values ('2003-04-06'); insert into `calendar` (`dayDate`) values ('2003-04-13'); insert into `calendar` (`dayDate`) values ('2003-04-20'); insert into `calendar` (`dayDate`) values ('2003-04-27'); insert into `calendar` (`dayDate`) values ('2003-05-04'); insert into `calendar` (`dayDate`) values ('2003-05-11'); insert into `calendar` (`dayDate`) values ('2003-05-18'); insert into `calendar` (`dayDate`) values ('2003-05-25'); insert into `calendar` (`dayDate`) values ('2003-06-01'); update `calendar` set `dayName` = DATE_FORMAT(`dayDate`, '%W'); insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 1 DAY) from `calendar`; insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 2 DAY) from `calendar` where `dayName` = 'Sunday'; insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 3 DAY) from `calendar` where `dayName` = 'Sunday'; insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 4 DAY) from `calendar` where `dayName` = 'Sunday'; insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 5 DAY) from `calendar` where `dayName` = 'Sunday'; insert into `calendar` (`dayDate`) select DATE_ADD(`dayDate`, INTERVAL 6 DAY) from `calendar` where `dayName` = 'Sunday'; update `calendar` set `dayName` = DATE_FORMAT(`dayDate`, '%W'), `dayAbbrev` = DATE_FORMAT(`dayDate`, '%a'), `dayOfWeek` = DATE_FORMAT(`dayDate`, '%w'), `dayOfMonth` = DATE_FORMAT(`dayDate`, '%e'), `monthName` = DATE_FORMAT(`dayDate`, '%M'), `monthAbbrev` = DATE_FORMAT(`dayDate`, '%b'), `monthOfYear` = DATE_FORMAT(`dayDate`,'%c'), `year` = DATE_FORMAT(`dayDate`, '%Y'); update `calendar` set `wasOpened`='1'; update `calendar` set `wasOpened`='0' where `dayName` = 'Sunday' or `dayName`='Monday'; update `calendar` set `isHoliday`='1' where `dayDate` = '2002-12-31' or `dayDate` = '2003-01-01' or `dayDate` = '2003-02-17' or `dayDate` = '2003-05-05' or `dayDate` = '2003-05-26'; insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('1', '3', '35', '2.25', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('1', '2', '35', '2.25', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('1', '2', '35', '2.25', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('4', '7', '27', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('4', '7', '32', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('3', '5', '47', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('3', '6', '47', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('3', '7', '47', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('3', '6', '116', '2.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('3', '10', '116', '15.00', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('7', '11', '75', '17.50', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('7', '20', '75', '10.00', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('2', '15', '105', '7.25', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('2', '10', '105', '15.00', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('2', '13', '105', '7.25', '0'); insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`) values ('2', '18', '105', '8.00', '0'); --- NEW FILE: web.xml --- <?xml version="1.0"?> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd"> <web-app> <servlet> <servlet-name>XTabMain</servlet-name> <servlet-class>com.pocolap.servlets.XTabMain</servlet-class> <init-param> <param-name>whs_b</param-name> <param-value>./config/config.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>XTabMain</servlet-name> <url-pattern>/servlets/XTabMain</url-pattern> </servlet-mapping> <taglib> <taglib-uri>ReptTags</taglib-uri> <taglib-location>/WEB-INF/tlds/ReptTags.tld</taglib-location> </taglib> </web-app> --- NEW FILE: sampleconfig.xml --- <reptconfig> <rept name="Sales SpreadSheet"> <source classtype="com.pocolap.conn.StandardJDBC" driver="org.gjt.mm.mysql.Driver" user="nssUser" pass="nssPass">jdbc:mysql://localhost:3306/nss</source> <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> </dimension> </rept> </reptconfig> |