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. BIC_DataCube.BIC.x integer false BIC_DataCube.BIC.y integer false BIC_DataCube.Account.NewTabularHierarchy1.x integer false BIC_DataCube.Account.NewTabularHierarchy1.y integer false BIC_DataCube.BIC.width integer false BIC_DataCube.BIC.height integer false BIC_DataCube.Account.NewTabularHierarchy1.width integer false BIC_DataCube.Account.NewTabularHierarchy1.height integer false SaleOrder_DataCube.Account.x integer false SaleOrder_DataCube.Account.y integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y integer false SaleOrder_DataCube.Account.width integer false SaleOrder_DataCube.Account.height integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height integer false 284 29 70 35 150 200 150 200 280 17 32 39 150 200 150 200 Blank Report /templates/blank_report.gif static date simple false text-box true Unformatted static date simple false text-box true Unformatted 1 orderDateYearName string 2 orderDateMonthOfYear string 3 orderDateMonthName string 4 orderDateWeekOfYear string 5 orderDateDayName string 6 orderDateDescription string 7 quantity integer 8 GrossSales decimal 9 GrossMerchandizeSales decimal 10 GrossMerchandizeProfit decimal 11 GrossShippingProfit decimal 12 GrossProfit decimal 13 AverageMerchandizeProfit decimal 14 AverageGrossProfit decimal 15 AccountType string 16 Pod string 17 Account string 18 SalesChannel string quantity quantity orderDateMonthName orderDateMonthName orderDateDayName orderDateDayName GrossSales GS GrossMerchandizeSales GMS GrossMerchandizeProfit GMP GrossShippingProfit GSP GrossProfit GP AverageMerchandizeProfit AMP AverageGrossProfit AGP orderDateWeekOfYear orderDateWeekOfYear orderDateDescription orderDateDescription AccountType AccountType Pod Pod Account Account SalesChannel SalesChannel orderDateYearName orderDateYearName orderDateMonthOfYear orderDateMonthOfYear 1 orderDateYearName string 2 orderDateMonthOfYear string 3 orderDateMonthName string 4 orderDateWeekOfYear string 5 orderDateDayName string 6 orderDateDescription string 7 quantity integer 8 GrossSales decimal 9 GrossMerchandizeSales decimal 10 GrossMerchandizeProfit decimal 11 GrossShippingProfit decimal 12 GrossProfit decimal 13 AverageMerchandizeProfit decimal 14 AverageGrossProfit decimal 15 AccountType string 16 Pod string 17 Account string 18 SalesChannel string OFbiz = totalRows - 1) return false; { starschema = starschemas.get(currentRow); orderDateDescription = starschema.getString("orderDateDescription"); orderDateDayName = starschema.getString("orderDateDayName"); orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth"); orderDateMonthName = starschema.getString("orderDateMonthName"); orderDateYearName = starschema.getString("orderDateYearName"); orderDateWeekOfYear = starschema.getString("orderDateWeekOfYear"); orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay"); orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear"); quantity = starschema.getString("quantity"); GrossSales = starschema.getString("GrossSales"); GrossMerchandizeSales = starschema.getString("GrossMerchandizeSales"); GrossMerchandizeProfit = starschema.getString("GrossMerchandizeProfit"); GrossShippingProfit = starschema.getString("GrossShippingProfit"); GrossProfit = starschema.getString("GrossProfit"); salesChannelEnumId = starschema.getString("salesChannelEnumId"); saleChannel = starschema.getString("saleChannel"); if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_AU; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_CA; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_IE; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_SG; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_UK; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod1; row["Account"] = account_B2C_US; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod2; row["Account"] = account_B2C_DE; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod2; row["Account"] = account_B2C_ES; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod2; row["Account"] = account_B2C_FR; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") { row["AccountType"] = account_type1; row["Pod"] = pod2; row["Account"] = account_B2C_IT; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_AU_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_AU; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_CA_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_CA; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_IE_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_IE; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_SG_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_SG; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_UK_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_UK; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_US_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod1; row["Account"] = account_B2B_US; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_DE_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod2; row["Account"] = account_B2B_DE; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_ES_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod2; row["Account"] = account_B2B_ES; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_FR_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod2; row["Account"] = account_B2B_FR; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } if (salesChannelEnumId == "B2B_IT_SALES_CHANNEL") { row["AccountType"] = account_type2; row["Pod"] = pod2; row["Account"] = account_B2B_IT; row["SalesChannel"] = salesChannelEnumId; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; row["quantity"] = quantity; row["GrossSales"] = GrossSales; row["GrossMerchandizeSales"] = GrossMerchandizeSales; row["GrossMerchandizeProfit"] = GrossMerchandizeProfit; row["GrossShippingProfit"] = GrossShippingProfit; row["GrossProfit"] = GrossProfit; } currentRow ++; } return true;]]> Summary Field1 NewTabularHierarchy string orderDateYearName string orderDateMonthOfYear string orderDateMonthName string orderDateWeekOfYear string orderDateDescription string orderDateDayName NewTabularHierarchy1 string AccountType string Pod string Account dataSetRow["quantity"] integer dataSetRow["GrossSales"] decimal dataSetRow["GrossMerchandizeSales"] decimal dataSetRow["GrossMerchandizeProfit"] decimal dataSetRow["GrossShippingProfit"] decimal dataSetRow["GrossProfit"] decimal sum false dataSetRow["GrossMerchandizeProfit"]/dataSetRow["quantity"] decimal average dataSetRow["GrossProfit"]/dataSetRow["quantity"] decimal BIC us-legal landscape 0.25in 0.25in 0.25in 0.25in html new Date()]]> xx-large normal 1pt 20pt center Sales Report 0 quantity left quantity Account/AccountType Date/orderDateDescription #BFBFBF normal quantity_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal quantity_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal quantity_Date/orderDateDescription bold center Sold Qty GrossSales left GrossSales Account/AccountType Date/orderDateDescription #BFBFBF normal GrossSales_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal GrossSales_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal GrossSales_Date/orderDateDescription bold center GS GrossMerchandizeSales GrossMerchandizeSales Account/AccountType Date/orderDateDescription #BFBFBF normal GrossMerchandizeSales_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal GrossMerchandizeSales_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal GrossMerchandizeSales_Date/orderDateDescription bold center GMS GrossMerchandizeProfit GrossMerchandizeProfit Account/AccountType Date/orderDateDescription #BFBFBF normal GrossMerchandizeProfit_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal GrossMerchandizeProfit_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal GrossMerchandizeProfit_Date/orderDateDescription bold center GMP GrossShippingProfit GrossShippingProfit Account/AccountType Date/orderDateDescription #BFBFBF normal GrossShippingProfit_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal GrossShippingProfit_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal GrossShippingProfit_Date/orderDateDescription bold center GSP GrossProfit GrossProfit Account/AccountType Date/orderDateDescription #BFBFBF normal GrossProfit_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal GrossProfit_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal GrossProfit_Date/orderDateDescription bold center GP AverageMerchandizeProfit Fixed Fixed AverageMerchandizeProfit Account/AccountType Date/orderDateDescription #BFBFBF normal Fixed Fixed AverageMerchandizeProfit_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal Fixed Fixed AverageMerchandizeProfit_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal Fixed Fixed AverageMerchandizeProfit_Date/orderDateDescription bold center AMP AverageGrossProfit 0pt Fixed Fixed AverageGrossProfit Account/AccountType Date/orderDateDescription #BFBFBF normal Fixed Fixed AverageGrossProfit_Account/AccountType_Date/orderDateDescription Account/Pod Date/orderDateDescription #E5E5E5 normal Fixed Fixed AverageGrossProfit_Account/Pod_Date/orderDateDescription Date/orderDateDescription #7F7F7F normal Fixed Fixed AverageGrossProfit_Date/orderDateDescription bold center AGP bold center Grand Total #7F7F7F Account Account/AccountType bold center AccountType middle 1pt bold center Total #BFBFBF Account/Pod bold center Pod middle bold center Total #E5E5E5 Account/Account bold center Account Date Date/orderDateYearName bold center orderDateYearName Date/orderDateMonthOfYear bold center orderDateMonthOfYear Date/orderDateWeekOfYear bold center orderDateWeekOfYear Date/orderDateDescription bold center orderDateDescription #FFFFFF BIC_DataCube quantity measure["quantity"] integer GrossSales measure["GrossSales"] decimal GrossMerchandizeSales measure["GrossMerchandizeSales"] decimal GrossMerchandizeProfit measure["GrossMerchandizeProfit"] decimal GrossShippingProfit measure["GrossShippingProfit"] decimal GrossProfit measure["GrossProfit"] decimal AverageMerchandizeProfit measure["AverageMerchandizeProfit"] decimal AverageGrossProfit measure["AverageGrossProfit"] decimal AccountType dimension["Account"]["AccountType"] string Pod dimension["Account"]["Pod"] string Account dimension["Account"]["Account"] string quantity_Account/AccountType_Date/orderDateDescription measure["quantity"] integer Account/AccountType Date/orderDateDescription sum GrossSales_Account/AccountType_Date/orderDateDescription measure["GrossSales"] decimal Account/AccountType Date/orderDateDescription sum GrossMerchandizeSales_Account/AccountType_Date/orderDateDescription measure["GrossMerchandizeSales"] decimal Account/AccountType Date/orderDateDescription sum GrossMerchandizeProfit_Account/AccountType_Date/orderDateDescription measure["GrossMerchandizeProfit"] decimal Account/AccountType Date/orderDateDescription sum GrossShippingProfit_Account/AccountType_Date/orderDateDescription measure["GrossShippingProfit"] decimal Account/AccountType Date/orderDateDescription sum GrossProfit_Account/AccountType_Date/orderDateDescription measure["GrossProfit"] decimal Account/AccountType Date/orderDateDescription sum AverageMerchandizeProfit_Account/AccountType_Date/orderDateDescription measure["AverageMerchandizeProfit"] decimal Account/AccountType Date/orderDateDescription sum AverageGrossProfit_Account/AccountType_Date/orderDateDescription measure["AverageGrossProfit"] decimal Account/AccountType Date/orderDateDescription average quantity_Account/Pod_Date/orderDateDescription measure["quantity"] integer Account/Pod Date/orderDateDescription sum GrossSales_Account/Pod_Date/orderDateDescription measure["GrossSales"] decimal Account/Pod Date/orderDateDescription sum GrossMerchandizeSales_Account/Pod_Date/orderDateDescription measure["GrossMerchandizeSales"] decimal Account/Pod Date/orderDateDescription sum GrossMerchandizeProfit_Account/Pod_Date/orderDateDescription measure["GrossMerchandizeProfit"] decimal Account/Pod Date/orderDateDescription sum GrossShippingProfit_Account/Pod_Date/orderDateDescription measure["GrossShippingProfit"] decimal Account/Pod Date/orderDateDescription sum GrossProfit_Account/Pod_Date/orderDateDescription measure["GrossProfit"] decimal Account/Pod Date/orderDateDescription sum AverageMerchandizeProfit_Account/Pod_Date/orderDateDescription measure["AverageMerchandizeProfit"] decimal Account/Pod Date/orderDateDescription sum AverageGrossProfit_Account/Pod_Date/orderDateDescription measure["AverageGrossProfit"] decimal Account/Pod Date/orderDateDescription average quantity_Date/orderDateDescription measure["quantity"] integer Date/orderDateDescription sum GrossSales_Date/orderDateDescription measure["GrossSales"] decimal Date/orderDateDescription sum GrossMerchandizeSales_Date/orderDateDescription measure["GrossMerchandizeSales"] decimal Date/orderDateDescription sum GrossMerchandizeProfit_Date/orderDateDescription measure["GrossMerchandizeProfit"] decimal Date/orderDateDescription sum GrossShippingProfit_Date/orderDateDescription measure["GrossShippingProfit"] decimal Date/orderDateDescription sum GrossProfit_Date/orderDateDescription measure["GrossProfit"] decimal Date/orderDateDescription sum AverageMerchandizeProfit_Date/orderDateDescription measure["AverageMerchandizeProfit"] decimal Date/orderDateDescription sum AverageGrossProfit_Date/orderDateDescription measure["AverageGrossProfit"] decimal Date/orderDateDescription average quantity_Account/AccountType_Date/orderDateWeekOfYear measure["quantity"] integer Account/AccountType Date/orderDateWeekOfYear sum GrossSales_Account/AccountType_Date/orderDateWeekOfYear measure["GrossSales"] decimal Account/AccountType Date/orderDateWeekOfYear sum GrossMerchandizeSales_Account/AccountType_Date/orderDateWeekOfYear measure["GrossMerchandizeSales"] decimal Account/AccountType Date/orderDateWeekOfYear sum GrossMerchandizeProfit_Account/AccountType_Date/orderDateWeekOfYear measure["GrossMerchandizeProfit"] decimal Account/AccountType Date/orderDateWeekOfYear sum GrossShippingProfit_Account/AccountType_Date/orderDateWeekOfYear measure["GrossShippingProfit"] decimal Account/AccountType Date/orderDateWeekOfYear sum GrossProfit_Account/AccountType_Date/orderDateWeekOfYear measure["GrossProfit"] decimal Account/AccountType Date/orderDateWeekOfYear sum AverageMerchandizeProfit_Account/AccountType_Date/orderDateWeekOfYear measure["AverageMerchandizeProfit"] decimal Account/AccountType Date/orderDateWeekOfYear sum AverageGrossProfit_Account/AccountType_Date/orderDateWeekOfYear measure["AverageGrossProfit"] decimal Account/AccountType Date/orderDateWeekOfYear average quantity_Account/Pod_Date/orderDateWeekOfYear measure["quantity"] integer Account/Pod Date/orderDateWeekOfYear sum GrossSales_Account/Pod_Date/orderDateWeekOfYear measure["GrossSales"] decimal Account/Pod Date/orderDateWeekOfYear sum GrossMerchandizeSales_Account/Pod_Date/orderDateWeekOfYear measure["GrossMerchandizeSales"] decimal Account/Pod Date/orderDateWeekOfYear sum GrossMerchandizeProfit_Account/Pod_Date/orderDateWeekOfYear measure["GrossMerchandizeProfit"] decimal Account/Pod Date/orderDateWeekOfYear sum GrossShippingProfit_Account/Pod_Date/orderDateWeekOfYear measure["GrossShippingProfit"] decimal Account/Pod Date/orderDateWeekOfYear sum GrossProfit_Account/Pod_Date/orderDateWeekOfYear measure["GrossProfit"] decimal Account/Pod Date/orderDateWeekOfYear sum AverageMerchandizeProfit_Account/Pod_Date/orderDateWeekOfYear measure["AverageMerchandizeProfit"] decimal Account/Pod Date/orderDateWeekOfYear sum AverageGrossProfit_Account/Pod_Date/orderDateWeekOfYear measure["AverageGrossProfit"] decimal Account/Pod Date/orderDateWeekOfYear average quantity_Date/orderDateWeekOfYear measure["quantity"] integer Date/orderDateWeekOfYear sum GrossSales_Date/orderDateWeekOfYear measure["GrossSales"] decimal Date/orderDateWeekOfYear sum GrossMerchandizeSales_Date/orderDateWeekOfYear measure["GrossMerchandizeSales"] decimal Date/orderDateWeekOfYear sum GrossMerchandizeProfit_Date/orderDateWeekOfYear measure["GrossMerchandizeProfit"] decimal Date/orderDateWeekOfYear sum GrossShippingProfit_Date/orderDateWeekOfYear measure["GrossShippingProfit"] decimal Date/orderDateWeekOfYear sum GrossProfit_Date/orderDateWeekOfYear measure["GrossProfit"] decimal Date/orderDateWeekOfYear sum AverageMerchandizeProfit_Date/orderDateWeekOfYear measure["AverageMerchandizeProfit"] decimal Date/orderDateWeekOfYear sum AverageGrossProfit_Date/orderDateWeekOfYear measure["AverageGrossProfit"] decimal Date/orderDateWeekOfYear average quantity_Account/AccountType measure["quantity"] integer Account/AccountType sum GrossSales_Account/AccountType measure["GrossSales"] decimal Account/AccountType sum GrossMerchandizeSales_Account/AccountType measure["GrossMerchandizeSales"] decimal Account/AccountType sum GrossMerchandizeProfit_Account/AccountType measure["GrossMerchandizeProfit"] decimal Account/AccountType sum GrossShippingProfit_Account/AccountType measure["GrossShippingProfit"] decimal Account/AccountType sum GrossProfit_Account/AccountType measure["GrossProfit"] decimal Account/AccountType sum AverageMerchandizeProfit_Account/AccountType measure["AverageMerchandizeProfit"] decimal Account/AccountType sum AverageGrossProfit_Account/AccountType measure["AverageGrossProfit"] decimal Account/AccountType average quantity_Account/Pod measure["quantity"] integer Account/Pod sum GrossSales_Account/Pod measure["GrossSales"] decimal Account/Pod sum GrossMerchandizeSales_Account/Pod measure["GrossMerchandizeSales"] decimal Account/Pod sum GrossMerchandizeProfit_Account/Pod measure["GrossMerchandizeProfit"] decimal Account/Pod sum GrossShippingProfit_Account/Pod measure["GrossShippingProfit"] decimal Account/Pod sum GrossProfit_Account/Pod measure["GrossProfit"] decimal Account/Pod sum AverageMerchandizeProfit_Account/Pod measure["AverageMerchandizeProfit"] decimal Account/Pod sum AverageGrossProfit_Account/Pod measure["AverageGrossProfit"] decimal Account/Pod average quantity_1 measure["quantity"] integer sum GrossSales_1 measure["GrossSales"] decimal sum GrossMerchandizeSales_1 measure["GrossMerchandizeSales"] decimal sum GrossMerchandizeProfit_1 measure["GrossMerchandizeProfit"] decimal sum GrossShippingProfit_1 measure["GrossShippingProfit"] decimal sum GrossProfit_1 measure["GrossProfit"] decimal sum AverageMerchandizeProfit_1 measure["AverageMerchandizeProfit"] decimal sum AverageGrossProfit_1 measure["AverageGrossProfit"] decimal average orderDateYearName dimension["Date"]["orderDateYearName"] string quantity_Account/AccountType_Date/orderDateYearName measure["quantity"] integer Account/AccountType Date/orderDateYearName sum GrossSales_Account/AccountType_Date/orderDateYearName measure["GrossSales"] decimal Account/AccountType Date/orderDateYearName sum GrossMerchandizeSales_Account/AccountType_Date/orderDateYearName measure["GrossMerchandizeSales"] decimal Account/AccountType Date/orderDateYearName sum GrossMerchandizeProfit_Account/AccountType_Date/orderDateYearName measure["GrossMerchandizeProfit"] decimal Account/AccountType Date/orderDateYearName sum GrossShippingProfit_Account/AccountType_Date/orderDateYearName measure["GrossShippingProfit"] decimal Account/AccountType Date/orderDateYearName sum GrossProfit_Account/AccountType_Date/orderDateYearName measure["GrossProfit"] decimal Account/AccountType Date/orderDateYearName sum AverageMerchandizeProfit_Account/AccountType_Date/orderDateYearName measure["AverageMerchandizeProfit"] decimal Account/AccountType Date/orderDateYearName sum AverageGrossProfit_Account/AccountType_Date/orderDateYearName measure["AverageGrossProfit"] decimal Account/AccountType Date/orderDateYearName average quantity_Account/Pod_Date/orderDateYearName measure["quantity"] integer Account/Pod Date/orderDateYearName sum GrossSales_Account/Pod_Date/orderDateYearName measure["GrossSales"] decimal Account/Pod Date/orderDateYearName sum GrossMerchandizeSales_Account/Pod_Date/orderDateYearName measure["GrossMerchandizeSales"] decimal Account/Pod Date/orderDateYearName sum GrossMerchandizeProfit_Account/Pod_Date/orderDateYearName measure["GrossMerchandizeProfit"] decimal Account/Pod Date/orderDateYearName sum GrossShippingProfit_Account/Pod_Date/orderDateYearName measure["GrossShippingProfit"] decimal Account/Pod Date/orderDateYearName sum GrossProfit_Account/Pod_Date/orderDateYearName measure["GrossProfit"] decimal Account/Pod Date/orderDateYearName sum AverageMerchandizeProfit_Account/Pod_Date/orderDateYearName measure["AverageMerchandizeProfit"] decimal Account/Pod Date/orderDateYearName sum AverageGrossProfit_Account/Pod_Date/orderDateYearName measure["AverageGrossProfit"] decimal Account/Pod Date/orderDateYearName average quantity_Date/orderDateYearName measure["quantity"] integer Date/orderDateYearName sum GrossSales_Date/orderDateYearName measure["GrossSales"] decimal Date/orderDateYearName sum GrossMerchandizeSales_Date/orderDateYearName measure["GrossMerchandizeSales"] decimal Date/orderDateYearName sum GrossMerchandizeProfit_Date/orderDateYearName measure["GrossMerchandizeProfit"] decimal Date/orderDateYearName sum GrossShippingProfit_Date/orderDateYearName measure["GrossShippingProfit"] decimal Date/orderDateYearName sum GrossProfit_Date/orderDateYearName measure["GrossProfit"] decimal Date/orderDateYearName sum AverageMerchandizeProfit_Date/orderDateYearName measure["AverageMerchandizeProfit"] decimal Date/orderDateYearName sum AverageGrossProfit_Date/orderDateYearName measure["AverageGrossProfit"] decimal Date/orderDateYearName average orderDateWeekOfYear "Week "+dimension["Date"]["orderDateWeekOfYear"] string orderDateDescription dimension["Date"]["orderDateDescription"] string orderDateMonthOfYear dimension["Date"]["orderDateMonthOfYear"] string