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. NBO Cube.NBO.x integer false NBO Cube.NBO.y integer false NBO Cube.Account.NewTabularHierarchy1.x integer false NBO Cube.Account.NewTabularHierarchy1.y integer false NBO Cube.NBO.width integer false NBO Cube.NBO.height integer false NBO Data Cube.NBO.x integer false NBO Data Cube.NBO.y integer false NBO Date Data Cube.NBO.x integer false NBO Date Data Cube.NBO.y integer false NBO Mouthly Data Cube.NBO_Monthly.x integer false NBO Mouthly Data Cube.NBO_Monthly.y integer false 261 35 10 172 150 200 135 80 135 80 135 80 Blank Report /templates/blank_report.gif static string simple false text-box true Unformatted static string simple false text-box true Unformatted static integer simple false text-box true Unformatted static integer simple false text-box true Unformatted static integer simple false text-box true Unformatted 1 SalesChannel string 2 orderDateMonthName string 3 orderDateDateValue string 4 Parcel integer 5 GS decimal 6 GMS decimal 7 GMP decimal 8 GSP decimal 9 GP decimal 10 eBay decimal 11 eBay% decimal 12 RRC decimal 13 RRC% decimal 14 Others decimal 15 GP% decimal 16 GMP% decimal 17 NBO decimal 18 Monthly Projection decimal 19 Monthly Forecast decimal 20 Daily integer 21 Pod string 22 Account string 23 Date string 24 Month string 25 MonthName string 26 Today string SalesChannel SalesChannel orderDateMonthName orderDateMonthName orderDateDateValue orderDateDateValue Parcel Parcel GS GS GMS GMS GMP GMP GSP GSP GP GP eBay eBay eBay% eBay% RRC RRC RRC% RRC% Others Others GP% GP% GMP% GMP% NBO NBO Daily Daily Monthly Projection Monthly Projection Monthly Forecast Monthly Forecast Pod Pod Account Account Date Date Month Month MonthName MonthName Today Today 1 SalesChannel string 2 orderDateMonthName string 3 orderDateDateValue string 4 Parcel integer 5 GS decimal 6 GMS decimal 7 GMP decimal 8 GSP decimal 9 GP decimal 10 eBay decimal 11 eBay% decimal 12 RRC decimal 13 RRC% decimal 14 Others decimal 15 GP% decimal 16 GMP% decimal 17 NBO decimal 18 Monthly Projection decimal 19 Monthly Forecast decimal 20 Daily integer 21 Pod string 22 Account string 23 Date string 24 Month string 25 MonthName string 26 Today string 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"); quantity = starschema.getString("quantity"); GS = starschema.getString("GrossSales"); GMS = starschema.getString("GrossMerchandizeSales"); GMP = starschema.getString("GrossMerchandizeProfit"); GSP = starschema.getString("GrossShippingProfit"); GP = starschema.getString("GrossProfit"); eBay = starschema.getString("eBay"); RRC = starschema.getString("RRC"); Others = starschema.getString("OtherFree"); NBO = starschema.getString("NBO"); salesChannelEnumId = starschema.getString("salesChannelEnumId"); if (orderDateMonthOfYear == DateMonth) { row["Daily"] = 1; } else { row["Daily"] = 2; } if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_AU; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_CA; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_IE; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_SG; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_UK; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_US; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_DE; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_ES; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_FR; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_IT; row["Date"] = orderDateYearMonthDay; row["Month"] = orderDateMonthOfYear; row["MonthName"] = orderDateMonthName; row["Today"] = DateDay; } currentRow ++; } return true;]]> 1 SalesChannel string 2 orderDateDayOfMonth string 3 orderDateMonthName string 4 orderDateYearName string 5 orderDateDateValue string 6 Parcel integer 7 GS decimal 8 GMS decimal 9 GMP decimal 10 GSP decimal 11 GP decimal 12 eBay decimal 13 eBay% decimal 14 RRC decimal 15 RRC% decimal 16 Others decimal 17 GP% decimal 18 GMP% decimal 19 NBO decimal 20 Pod string 21 Account string 22 Date string SalesChannel SalesChannel orderDateDayOfMonth orderDateDayOfMonth orderDateMonthName orderDateMonthName orderDateYearName orderDateYearName orderDateDateValue orderDateDateValue Parcel Parcel GS GS GMS GMS GMP GMP GSP GSP eBay eBay RRC RRC Others Others Pod Pod Account Account Date Date NBO NBO eBay% eBay% RRC% RRC% GP% GP% GMP% GMP% GP GP 1 SalesChannel string 2 orderDateDayOfMonth string 3 orderDateMonthName string 4 orderDateYearName string 5 orderDateDateValue string 6 Parcel integer 7 GS decimal 8 GMS decimal 9 GMP decimal 10 GSP decimal 11 GP decimal 12 eBay decimal 13 eBay% decimal 14 RRC decimal 15 RRC% decimal 16 Others decimal 17 GP% decimal 18 GMP% decimal 19 NBO decimal 20 Pod string 21 Account string 22 Date string OFbiz = totalRows) return false; { Date_starschema = Date_starschemas.get(currentRow); orderDateDateValue = Date_starschema.getString("orderDateDateValue"); orderDateDayName = Date_starschema.getString("orderDateDayName"); orderDateDayOfMonth = Date_starschema.getString("orderDateDayOfMonth"); orderDateMonthName = Date_starschema.getString("orderDateMonthName"); orderDateYearName = Date_starschema.getString("orderDateYearName"); orderDateYearMonthDay = Date_starschema.getString("orderDateYearMonthDay"); orderDateMonthOfYear = Date_starschema.getString("orderDateMonthOfYear"); orderDateDescription = Date_starschema.getString("orderDateDescription"); quantity = Date_starschema.getString("quantity"); GS = Date_starschema.getString("GrossSales"); GMS = Date_starschema.getString("GrossMerchandizeSales"); GMP = Date_starschema.getString("GrossMerchandizeProfit"); GSP = Date_starschema.getString("GrossShippingProfit"); GP = Date_starschema.getString("GrossProfit"); eBay = Date_starschema.getString("eBay"); RRC = Date_starschema.getString("RRC"); Others = Date_starschema.getString("OtherFree"); NBO = Date_starschema.getString("NBO"); salesChannelEnumId = Date_starschema.getString("salesChannelEnumId"); if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_AU; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_CA; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_IE; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_SG; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_UK; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod1; row["Account"] = account_B2C_US; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_DE; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_ES; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_FR; row["Date"] = orderDateYearMonthDay; } if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateDayOfMonth"] = orderDateDayOfMonth; row["orderDateMonthName"] = orderDateMonthName; row["orderDateYearName"] = orderDateYearName; row["orderDateDateValue"] = orderDateDateValue; row["Parcel"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; row["eBay"] = eBay; row["RRC"] = RRC; row["Others"] = Others; row["NBO"] = NBO; row["Pod"] = pod2; row["Account"] = account_B2C_IT; row["Date"] = orderDateYearMonthDay; } currentRow ++; } return true;]]> 1 SalesChannel string 2 orderDateMonthName string 3 Pod string 4 Account string 5 NBO decimal 6 CountDate integer 7 Monthly Forecast decimal SalesChannel SalesChannel orderDateMonthName orderDateMonthName Pod Pod Account Account NBO NBO CountDate CountDate Monthly Forecast Monthly Forecast 1 SalesChannel string 2 orderDateMonthName string 3 Pod string 4 Account string 5 NBO decimal 6 CountDate integer 7 Monthly Forecast decimal OFbiz = totalRows) return false; { starschema = starschemas.get(currentRow); salesChannelEnumId = starschema.getString("salesChannelEnumId"); orderDateMonthName = starschema.getString("orderDateMonthName"); orderDateYearName = starschema.getString("orderDateYearName"); NBO = starschema.getString("NBO"); CountDate = starschema.getString("CountDate"); if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_AU; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_CA; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_IE; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_SG; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_UK; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod1; row["Account"] = account_B2C_US; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod2; row["Account"] = account_B2C_DE; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod2; row["Account"] = account_B2C_ES; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod2; row["Account"] = account_B2C_FR; row["NBO"] = NBO; row["CountDate"] = CountDate; } if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") { row["SalesChannel"] = salesChannelEnumId; row["orderDateMonthName"] = orderDateMonthName; row["Pod"] = pod2; row["Account"] = account_B2C_IT; row["NBO"] = NBO; row["CountDate"] = CountDate; } currentRow ++; } return true;]]> NBO Summary Field false NewTabularHierarchy string Today NewTabularHierarchy1 string Pod string Account integer dynamic orderDateMonthName string Daily average dataSetRow["Parcel"] integer average dataSetRow["GS"] decimal average dataSetRow["GMP"] decimal average false dataSetRow["GSP"] decimal average dataSetRow["GP"] decimal average dataSetRow["eBay"] decimal average (dataSetRow["eBay"]/dataSetRow["GP"]) decimal average dataSetRow["RRC"] decimal average false (dataSetRow["RRC"]/dataSetRow["GP"]) decimal average false dataSetRow["Others"] decimal average (dataSetRow["GP"]/dataSetRow["GS"]) decimal average (dataSetRow["GMP"]/dataSetRow["GMS"]) decimal average dataSetRow["NBO"] decimal NBO_Month NBO_Today Summary Field NewTabularHierarchy2 string orderDateDateValue NewTabularHierarchy3 string Pod string Account string Date dataSetRow["Parcel"] integer dataSetRow["GS"] decimal dataSetRow["GMP"] decimal dataSetRow["GSP"] decimal dataSetRow["GP"] decimal dataSetRow["eBay"] decimal (dataSetRow["eBay"]/dataSetRow["GP"]) decimal dataSetRow["RRC"] decimal (dataSetRow["RRC"]/dataSetRow["GP"]) decimal dataSetRow["Others"] decimal (dataSetRow["GP"]/dataSetRow["GS"]) decimal (dataSetRow["GMP"]/dataSetRow["GMS"]) decimal dataSetRow["NBO"] decimal NBO_Date NBO MonthlySummary Field NewTabularHierarchy6 string orderDateMonthName NewTabularHierarchy7 string Pod string Account sum dataSetRow["NBO"] decimal (dataSetRow["NBO"]/dataSetRow["CountDate"])*params["NunberDate"] decimal dataSetRow["Monthly Forecast"] decimal NBO_Monthly landscape 0.25in 0.25in 0.25in 0.25in html new Date()]]> xx-large normal 1pt 20pt center Net Before Overhead 0 Parcel1 Parcel1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Parcel1_Date_Today/orderDateDateValue center Parcel #FFFF00 GS1 Currency $###0 GS1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 GS1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 GS1_Date_Today/orderDateDateValue center GS #FFFF00 GMP1 Currency $###0 GMP1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 GMP1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 GMP1_Date_Today/orderDateDateValue center GMP #FFFF00 GSP1 Currency $###0 GSP1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 GSP1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 GSP1_Date_Today/orderDateDateValue center GSP #FFFF00 GP1 Currency $###0 GP1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 GP1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 GP1_Date_Today/orderDateDateValue center GP #FFFF00 eBay1 Currency $###0 eBay1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 eBay1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 eBay1_Date_Today/orderDateDateValue center eBay #FFFF00 eBay%1 Percent ###0% eBay%1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Percent ###0% eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Percent ###0% eBay%1_Date_Today/orderDateDateValue center eBay% #FFFF00 RRC1 Currency $###0 RRC1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 RRC1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 RRC1_Date_Today/orderDateDateValue center RRC #FFFF00 RRC%1 Percent ###0.0% RRC%1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Percent ###0.0% RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Percent ###0.0% RRC%1_Date_Today/orderDateDateValue center RRC% #FFFF00 Others1 Currency $###0 Others1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 Others1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 Others1_Date_Today/orderDateDateValue center Others #FFFF00 GP%1 Percent ###0.0% GP%1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Percent ###0.0% GP%1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Percent ###0.0% GP%1_Date_Today/orderDateDateValue center GP% #FFFF00 GMP%1 Percent ###0.0% GMP%1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Percent ###0.0% GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Percent ###0.0% GMP%1_Date_Today/orderDateDateValue center GMP% #FFFF00 NBO1 Currency $###0 NBO1 Account_Today/Pod Date_Today/orderDateDateValue #E5E5E5 Currency $###0 NBO1_Account_Today/Pod_Date_Today/orderDateDateValue Date_Today/orderDateDateValue #BFBFBF Currency $###0 NBO1_Date_Today/orderDateDateValue center NBO #FFFF00 center Grand Total #BFBFBF Account_Today Account_Today/Pod center Pod #FFFF00 middle center Pod Total #E5E5E5 Account_Today/Account center Account #FFFF00 middle Account_Today/Date center Date #FFFF00 middle Date_Today Date_Today/orderDateDateValue center orderDateDateValue #FFFF00 NBO Date Data Cube Pod dimension["Account_Today"]["Pod"] string orderDateDateValue dimension["Date_Today"]["orderDateDateValue"] string Parcel1 measure["Parcel1"] integer Account dimension["Account_Today"]["Account"] string Date "Today" string GS1 measure["GS1"] decimal GMP1 measure["GMP1"] decimal GSP1 measure["GSP1"] decimal GP1 measure["GP1"] decimal eBay1 measure["eBay1"] decimal eBay%1 measure["eBay%1"] decimal RRC1 measure["RRC1"] decimal RRC%1 measure["RRC%1"] decimal Others1 measure["Others1"] decimal GP%1 measure["GP%1"] decimal GMP%1 measure["GMP%1"] decimal NBO1 measure["NBO1"] decimal Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue measure["Parcel1"] integer Account_Today/Pod Date_Today/orderDateDateValue sum GS1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GS1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum GMP1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GMP1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum GSP1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GSP1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum GP1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GP1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum eBay1_Account_Today/Pod_Date_Today/orderDateDateValue measure["eBay1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue measure["eBay%1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum RRC1_Account_Today/Pod_Date_Today/orderDateDateValue measure["RRC1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue measure["RRC%1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum Others1_Account_Today/Pod_Date_Today/orderDateDateValue measure["Others1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum GP%1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GP%1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue measure["GMP%1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum NBO1_Account_Today/Pod_Date_Today/orderDateDateValue measure["NBO1"] decimal Account_Today/Pod Date_Today/orderDateDateValue sum Parcel1_Date_Today/orderDateDateValue measure["Parcel1"] integer Date_Today/orderDateDateValue sum GS1_Date_Today/orderDateDateValue measure["GS1"] decimal Date_Today/orderDateDateValue sum GMP1_Date_Today/orderDateDateValue measure["GMP1"] decimal Date_Today/orderDateDateValue sum GSP1_Date_Today/orderDateDateValue measure["GSP1"] decimal Date_Today/orderDateDateValue sum GP1_Date_Today/orderDateDateValue measure["GP1"] decimal Date_Today/orderDateDateValue sum eBay1_Date_Today/orderDateDateValue measure["eBay1"] decimal Date_Today/orderDateDateValue sum eBay%1_Date_Today/orderDateDateValue measure["eBay%1"] decimal Date_Today/orderDateDateValue sum RRC1_Date_Today/orderDateDateValue measure["RRC1"] decimal Date_Today/orderDateDateValue sum RRC%1_Date_Today/orderDateDateValue measure["RRC%1"] decimal Date_Today/orderDateDateValue sum Others1_Date_Today/orderDateDateValue measure["Others1"] decimal Date_Today/orderDateDateValue sum GP%1_Date_Today/orderDateDateValue measure["GP%1"] decimal Date_Today/orderDateDateValue sum GMP%1_Date_Today/orderDateDateValue measure["GMP%1"] decimal Date_Today/orderDateDateValue sum NBO1_Date_Today/orderDateDateValue measure["NBO1"] decimal Date_Today/orderDateDateValue sum 0 Parcel Parcel Account/Pod Date/Today #E5E5E5 Parcel_Account/Pod_Date/Today_1 Parcel_lastmonth Date/Today #BFBFBF Parcel_Date/Today Parcel_total_lastmonth center Parcel #1E90FF GS Currency $###0 GS Account/Pod Date/Today #E5E5E5 Currency $###0 GS_Account/Pod_Date/Today Currency $###0 GS_lastmonth Date/Today #BFBFBF Currency $###0 GS_Date/Today Currency $###0 GS_total_lastmonth center GS #1E90FF GMP Currency $###0 GMP Account/Pod Date/Today #E5E5E5 Currency $###0 GMP_Account/Pod_Date/Today Currency $###0 GMP_lastmonth Date/Today #BFBFBF Currency $###0 GMP_Date/Today Currency $###0 GMO_total_lastmonth center GMP #1E90FF GSP Currency $###0 GSP Account/Pod Date/Today #E5E5E5 Currency $###0 GSP_Account/Pod_Date/Today Currency $###0 GSP_lastmonth Date/Today #BFBFBF Currency $###0 GSP_Date/Today Currency $###0 GSP_taotal_lastmonth center GSP #1E90FF GP Currency $###0 GP Account/Pod Date/Today #E5E5E5 Currency $###0 GP_Account/Pod_Date/Today Currency $###0 GP_lastmonth Date/Today #BFBFBF Currency $###0 GP_Date/Today Currency $###0 GP_total_lastmonth center GP #1E90FF eBay Currency $###0 eBay Account/Pod Date/Today #E5E5E5 Currency $###0 eBay_Account/Pod_Date/Today Currency $###0 eBay_lastmonth Date/Today #BFBFBF Currency $###0 eBay_Date/Today Currency $###0 ebay_total_lastmonth center eBay #1E90FF eBay% Percent ###0% eBay% Account/Pod Date/Today #E5E5E5 Percent ###0% eBay%_Account/Pod_Date/Today Percent ###0% eBay%_lastmonth Date/Today #BFBFBF Percent ###0% eBay%_Date/Today Percent ###0% eBay%_total_lastmonth center eBay% #1E90FF RRC Currency $###0 RRC Account/Pod Date/Today #E5E5E5 Currency $###0 RRC_Account/Pod_Date/Today Currency $###0 RRC_lastmonth Date/Today #BFBFBF Currency $###0 RRC_Date/Today Currency $###0 RRC_total_lastmonth center RRC #1E90FF RRC% Percent ###0.0% RRC% Account/Pod Date/Today #E5E5E5 Percent ###0% RRC%_Account/Pod_Date/Today Percent ###0% RRC%_lastmonth Date/Today #BFBFBF Percent ###0% RRC%_Date/Today Percent ###0% RRC%_total_lastmonth center RRC% #1E90FF Others Currency $###0 Others Account/Pod Date/Today #E5E5E5 Currency $###0 Others_Account/Pod_Date/Today Currency $###0 Others_lastmonth Date/Today #BFBFBF Currency $###0 Others_Date/Today Currency $###0 Others_total_lastmonth center Others #1E90FF GP% Percent ###0.0% GP% Account/Pod Date/Today #E5E5E5 Percent ###0% GP%_Account/Pod_Date/Today Percent ###0% GP%_lastmonth Date/Today #BFBFBF Percent ###0.0% GP%_Date/Today Percent ###0.0% GP%_total_lastmonth center GP% #1E90FF GMP% Percent ###0.0% GMP% Account/Pod Date/Today #E5E5E5 Percent ###0.0% GMP%_Account/Pod_Date/Today Percent ###0.0% GMP%_lastmonth Date/Today #BFBFBF Percent ###0.0% GMP%_Date/Today Percent ###0.0% GMP%_total_lastmonth center GMP% #1E90FF NBO Currency $###0 NBO Account/Pod Date/Today #E5E5E5 Currency $###0 NBO_Account/Pod_Date/Today Currency $###0 NBO_lastmonth Date/Today #BFBFBF Currency $###0 NBO_Date/Today Currency $###0 NBO_total_lastmonth center NBO #1E90FF center Grand Total Avg this month center Grand Total Avg last month #BFBFBF Account Account/Pod 0pt 1pt center auto Pod #1E90FF middle eq data["Pod"] English #FFFF00 center Pod Total Avg this month center Pod Total Avg last month #E5E5E5 Account/Account 0pt 1pt center Account #1E90FF middle Account/Daily center Show_Daily #1E90FF 67px Date Date/Today center Today #1E90FF NBO Month Data Cube Pod dimension["Account"]["Pod"] string Parcel measure["Parcel"] integer GS measure["GS"] decimal GMP measure["GMP"] decimal GSP measure["GSP"] decimal GP measure["GP"] decimal eBay measure["eBay"] decimal eBay% measure["eBay%"] decimal RRC measure["RRC"] decimal RRC% measure["RRC%"] decimal Others measure["Others"] decimal GP% measure["GP%"] decimal GMP% measure["GMP%"] decimal NBO measure["NBO"] decimal Account dimension["Account"]["Account"] string Daily dimension["Account"]["Daily"] integer Today "Average this month and last month" string Show_Daily if(dimension["Account"]["Daily"]==1) { "Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3) } else if(dimension["Account"]["Daily"]==2) { "Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3) } string Parcel_Account/Pod_Date/Today measure["Parcel"] integer Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 GS_Account/Pod_Date/Today measure["GS"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 GMP_Account/Pod_Date/Today measure["GMP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 GSP_Account/Pod_Date/Today measure["GSP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 GP_Account/Pod_Date/Today measure["GP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 eBay_Account/Pod_Date/Today measure["eBay"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 eBay%_Account/Pod_Date/Today measure["eBay%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==1 RRC_Account/Pod_Date/Today measure["RRC"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 RRC%_Account/Pod_Date/Today measure["RRC%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==1 Others_Account/Pod_Date/Today measure["Others"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 GP%_Account/Pod_Date/Today measure["GP%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==1 GMP%_Account/Pod_Date/Today measure["GMP%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==1 NBO_Account/Pod_Date/Today measure["NBO"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 Parcel_Date/Today measure["Parcel"] integer Date/Today SUM dimension["Account"]["Daily"]==1 GS_Date/Today measure["GS"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 GMP_Date/Today measure["GMP"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 GSP_Date/Today measure["GSP"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 GP_Date/Today measure["GP"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 eBay_Date/Today measure["eBay"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 eBay%_Date/Today measure["eBay%"] decimal Date/Today AVE dimension["Account"]["Daily"]==1 RRC_Date/Today measure["RRC"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 RRC%_Date/Today measure["RRC%"] decimal Date/Today AVE dimension["Account"]["Daily"]==1 Others_Date/Today measure["Others"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 GP%_Date/Today measure["GP%"] decimal Date/Today AVE dimension["Account"]["Daily"]==1 GMP%_Date/Today measure["GMP%"] decimal Date/Today AVE dimension["Account"]["Daily"]==1 NBO_Date/Today measure["NBO"] decimal Date/Today SUM dimension["Account"]["Daily"]==1 Parcel_Account/Pod_Date/Today_1 measure["Parcel"] integer Account/Pod Date/Today SUM dimension["Account"]["Daily"]==1 Parcel_lastmonth measure["Parcel"] integer Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 GS_lastmonth measure["GS"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 GMP_lastmonth measure["GMP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 GSP_lastmonth measure["GSP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 GP_lastmonth measure["GP"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 eBay_lastmonth measure["eBay"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 eBay%_lastmonth measure["eBay%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==2 RRC_lastmonth measure["RRC"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 RRC%_lastmonth measure["RRC%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==2 Others_lastmonth measure["Others"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 GP%_lastmonth measure["GP%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==2 GMP%_lastmonth measure["GMP%"] decimal Account/Pod Date/Today AVE dimension["Account"]["Daily"]==2 NBO_lastmonth measure["NBO"] decimal Account/Pod Date/Today SUM dimension["Account"]["Daily"]==2 Parcel_total_lastmonth measure["Parcel"] integer Date/Today SUM dimension["Account"]["Daily"]==2 GS_total_lastmonth measure["GS"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 GMO_total_lastmonth measure["GMP"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 GSP_taotal_lastmonth measure["GSP"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 GP_total_lastmonth measure["GP"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 ebay_total_lastmonth measure["eBay"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 eBay%_total_lastmonth measure["eBay%"] decimal Date/Today AVE dimension["Account"]["Daily"]==2 RRC_total_lastmonth measure["RRC"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 RRC%_total_lastmonth measure["RRC%"] decimal Date/Today AVE dimension["Account"]["Daily"]==2 Others_total_lastmonth measure["Others"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 GP%_total_lastmonth measure["GP%"] decimal Date/Today AVE dimension["Account"]["Daily"]==2 GMP%_total_lastmonth measure["GMP%"] decimal Date/Today AVE dimension["Account"]["Daily"]==2 NBO_total_lastmonth measure["NBO"] decimal Date/Today SUM dimension["Account"]["Daily"]==2 0 NBO Monthly Currency $###0 NBO Monthly Accounts/Pod Monthly/orderDateMonthName #E5E5E5 Currency $###0 NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName Monthly/orderDateMonthName #BFBFBF Currency $###0 NBO Monthly_Monthly/orderDateMonthName center NBO #A52A2A Monthly Projection Currency $###0 Monthly Projection Accounts/Pod Monthly/orderDateMonthName #E5E5E5 Currency $###0 Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName Monthly/orderDateMonthName #BFBFBF Currency $###0 Monthly Projection_Monthly/orderDateMonthName center Monthly Projection #A52A2A Monthly Forecast Currency $###0 Monthly Forecast Accounts/Pod Monthly/orderDateMonthName #E5E5E5 Currency $###0 Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName Monthly/orderDateMonthName #BFBFBF Currency $###0 Monthly Forecast_Monthly/orderDateMonthName center Monthly Forecast #A52A2A center Grand Total #BFBFBF Accounts Accounts/Pod center Pod #A52A2A center Pod Total #E5E5E5 Accounts/Account center Account #A52A2A Monthly Monthly/orderDateMonthName center orderDateMonthName #A52A2A NBO Mouthly Data Cube orderDateMonthName dimension["Monthly"]["orderDateMonthName"] string Pod dimension["Accounts"]["Pod"] string NBO Monthly measure["NBO Monthly"] decimal Monthly Projection measure["Monthly Projection"] decimal Monthly Forecast measure["Monthly Forecast"] integer Account dimension["Accounts"]["Account"] string NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName measure["NBO Monthly"] decimal Accounts/Pod Monthly/orderDateMonthName sum Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName measure["Monthly Projection"] integer Accounts/Pod Monthly/orderDateMonthName sum Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName measure["Monthly Forecast"] integer Accounts/Pod Monthly/orderDateMonthName sum NBO Monthly_Monthly/orderDateMonthName measure["NBO Monthly"] decimal Monthly/orderDateMonthName sum Monthly Projection_Monthly/orderDateMonthName measure["Monthly Projection"] integer Monthly/orderDateMonthName sum Monthly Forecast_Monthly/orderDateMonthName measure["Monthly Forecast"] integer Monthly/orderDateMonthName sum