Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080226-1155> in Copyright (c) 2007 <<Your Company Name here>> Creates a blank report with no predefined content. Blank Report /templates/blank_report.gif static string simple false text-box true Unformatted static integer simple false text-box true Unformatted static integer simple false text-box true 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 GMP% decimal 12 AGP decimal 13 Rank integer Week Week SKU SKU ProductName ProductName QuantitySold QuantitySold GS GS GMS GMS GMP GMP GSP GSP GP GP GMP% GMP% AGP AGP 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 GMP% decimal 12 AGP decimal 13 Rank integer OFbiz = totalRows - 1) 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"); QuantitySold = starschema.getString("quantity"); GS = starschema.getString("GrossSales"); GMS = starschema.getString("GrossMerchandizeSales"); GMP = starschema.getString("GrossMerchandizeProfit"); GSP = starschema.getString("GrossShippingProfit"); GP = starschema.getString("GrossProfit"); 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;]]> PDR Summary Field NewTabularHierarchy string Week NewTabularHierarchy1 string SKU string ProductName string CategoryName dataSetRow["QuantitySold"] integer dataSetRow["GS"] decimal dataSetRow["GMP"] decimal dataSetRow["GP"] decimal dataSetRow["GMP"]/dataSetRow["GMS"] 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 QuantitySold QuantitySold solid 1px #000000 Products/CategoryName solid 1px #000000 Fixed Fixed QuantitySold_Products/CategoryName center QuantitySold solid 1px #000000 GS GS center GS GMP GMP Products/CategoryName Fixed Fixed GMP_Products/CategoryName center GMP GP Unformatted GP Products/CategoryName Fixed Fixed GP_Products/CategoryName center GP GMP% Percent ###0% GMP% center GMP% AGP Fixed Fixed AGP solid 1px #000000 Products/CategoryName solid 1px #000000 Fixed Fixed AGP_Products/CategoryName 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 PDR Data Cube 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 GMP% measure["GMP%"] 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