Copyright (c) 2007 <<Your Company Name here>> Eclipse BIRT Designer Version 3.7.1.v20110905 Build <3.7.1.v20110913-1734> Creates a blank report with no predefined content. in Blank Report /templates/blank_report.gif auto layout static false string true simple text-box Unformatted static false integer true simple text-box Unformatted static false integer true simple text-box Unformatted 1 Week string 2 SKU string 3 ProductName string 4 CategoryName string 5 QuantitySold integer 6 GS decimal 7 GMS decimal 8 GMP decimal 9 GSP decimal 10 GP decimal 11 Rank integer Week Week SKU SKU ProductName ProductName QuantitySold QuantitySold GS GS GMS GMS GMP GMP GSP GSP GP GP Rank Rank CategoryName CategoryName 1 Week string 2 SKU string 3 ProductName string 4 CategoryName string 5 QuantitySold integer 6 GS decimal 7 GMS decimal 8 GMP decimal 9 GSP decimal 10 GP decimal 11 Rank integer OFbiz = totalRows) return false; { starschema = starschemas.get(currentRow); orderDateDateValue = starschema.getString("orderDateDateValue"); orderDateDayName = starschema.getString("orderDateDayName"); orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth"); orderDateMonthName = starschema.getString("orderDateMonthName"); orderDateYearName = starschema.getString("orderDateYearName"); orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay"); orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear"); orderDateDescription = starschema.getString("orderDateDescription"); WeekOfYear = starschema.getString("orderDateWeekOfYear"); SKU = starschema.getString("productProductId"); ProductName = starschema.getString("productInternalName"); //CategoryName = starschema.getString("categoryName"); CategoryName = starschema.getString("productCategoryId"); QuantitySold = starschema.getString("quantity"); GS = starschema.getString("GS"); GMS = starschema.getString("GMS"); GMP = starschema.getString("GMP"); GSP = starschema.getString("GSP"); GP = starschema.getString("GP"); salesChannelEnumId = starschema.getString("salesChannelEnumId"); row["Week"] = WeekOfYear; row["SKU"] = SKU; row["ProductName"] = ProductName; row["CategoryName"] = CategoryName; row["QuantitySold"] = QuantitySold; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; currentRow ++; } return true;]]> NewTabularHierarchy string Week NewTabularHierarchy1 string SKU string ProductName string CategoryName dataSetRow["QuantitySold"] integer dataSetRow["GS"] decimal dataSetRow["GMP"] decimal dataSetRow["GP"] decimal dataSetRow["GP"]/dataSetRow["QuantitySold"] decimal dataSetRow["Rank"] integer PDR landscape 0.25in 0.25in 0.25in 0.25in html new Date()]]> xx-large 0pt 1pt 20pt center Product Demand Report PDR Data Cube QuantitySold Products/CategoryName Weeks/Week solid 1px #000000 QuantitySold Products/CategoryName solid 1px #000000 Fixed Fixed QuantitySold_Products/CategoryName center QuantitySold solid 1px #000000 center QuantitySold solid 1px #000000 GS Products/CategoryName Weeks/Week GS center GS GMP Products/CategoryName Weeks/Week GMP Products/CategoryName Fixed Fixed GMP_Products/CategoryName center GMP center GMP GP Products/CategoryName Weeks/Week Unformatted GP Products/CategoryName Fixed Fixed GP_Products/CategoryName center GP center GP AGP Products/CategoryName Weeks/Week solid 1px #000000 Fixed Fixed AGP Products/CategoryName solid 1px #000000 Fixed Fixed AGP_Products/CategoryName center AGP solid 1px #000000 center AGP solid 1px #000000 Products Products/SKU center SKU Products/ProductName center ProductName Products/CategoryName center CategoryName solid 1px #000000 center Average last 4 weeks solid 1px #000000 solid 1px #000000 Weeks Weeks/Week 0pt center Week solid 1px #000000 solid 1px #000000 Week "Week "+dimension["Weeks"]["Week"] string SKU dimension["Products"]["SKU"] string QuantitySold measure["QuantitySold"] integer GS measure["GS"] decimal GMP measure["GMP"] decimal GP measure["GP"] decimal AGP measure["AGP"] decimal ProductName dimension["Products"]["ProductName"] string CategoryName dimension["Products"]["CategoryName"] string QuantitySold_Products/CategoryName measure["QuantitySold"] integer Products/CategoryName AVE GMP_Products/CategoryName measure["GMP"] decimal Products/CategoryName AVE GP_Products/CategoryName measure["GP"] decimal Products/CategoryName AVE AGP_Products/CategoryName measure["AGP"] decimal Products/CategoryName AVE