svn commit: r890830 [6/7] - in /ofbiz/trunk: applications/accounting/webapp
Locked
svn commit: r890830 [6/7] - in /ofbiz/trunk: applications/accounting/webapp
 
|
Added: ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReport.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReport.rptdesign?rev=890830&view=auto ============================================================================== --- ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReport.rptdesign (added) +++ ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReport.rptdesign Tue Dec 15 15:34:29 2009 @@ -0,0 +1,2540 @@ +<?xml version="1.0" encoding="UTF-8"?> +<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1"> + <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080226-1155></property> + <property name="units">in</property> + <property name="comments">Copyright (c) 2007 <<Your Company Name here>></property> + <html-property name="description">Creates a blank report with no predefined content.</html-property> + <list-property name="userProperties"> + <structure> + <property name="name">BIC_DataCube.BIC.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.BIC.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.BIC.width</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.BIC.height</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.width</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.height</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.Account.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.Account.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.Account.width</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.Account.height</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + </list-property> + <property name="BIC_DataCube.BIC.x">284</property> + <property name="BIC_DataCube.BIC.y">29</property> + <property name="BIC_DataCube.Account.NewTabularHierarchy1.x">70</property> + <property name="BIC_DataCube.Account.NewTabularHierarchy1.y">35</property> + <property name="BIC_DataCube.BIC.width">150</property> + <property name="BIC_DataCube.BIC.height">200</property> + <property name="BIC_DataCube.Account.NewTabularHierarchy1.width">150</property> + <property name="BIC_DataCube.Account.NewTabularHierarchy1.height">200</property> + <property name="SaleOrder_DataCube.Account.x">280</property> + <property name="SaleOrder_DataCube.Account.y">17</property> + <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x">32</property> + <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y">39</property> + <property name="SaleOrder_DataCube.Account.width">150</property> + <property name="SaleOrder_DataCube.Account.height">200</property> + <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width">150</property> + <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height">200</property> + <text-property name="displayName">Blank Report</text-property> + <property name="iconFile">/templates/blank_report.gif</property> + <parameters> + <scalar-parameter name="fromDate" id="310"> + <property name="valueType">static</property> + <property name="dataType">date</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="thruDate" id="311"> + <property name="valueType">static</property> + <property name="dataType">date</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + </parameters> + <data-sources> + <script-data-source name="OFbiz" id="6"/> + </data-sources> + <data-sets> + <script-data-set name="BIC" id="7"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">orderDateYearName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateWeekOfYear</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">orderDateDayName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">orderDateDescription</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">quantity</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GrossSales</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GrossMerchandizeSales</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GrossMerchandizeProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">GrossShippingProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">GrossProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">AverageMerchandizeProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">AverageGrossProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">AccountType</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">quantity</property> + <property name="displayName">quantity</property> + </structure> + <structure> + <property name="columnName">orderDateMonthName</property> + <property name="displayName">orderDateMonthName</property> + </structure> + <structure> + <property name="columnName">orderDateDayName</property> + <property name="displayName">orderDateDayName</property> + </structure> + <structure> + <property name="columnName">GrossSales</property> + <property name="displayName">GS</property> + </structure> + <structure> + <property name="columnName">GrossMerchandizeSales</property> + <property name="displayName">GMS</property> + </structure> + <structure> + <property name="columnName">GrossMerchandizeProfit</property> + <property name="displayName">GMP</property> + </structure> + <structure> + <property name="columnName">GrossShippingProfit</property> + <property name="displayName">GSP</property> + </structure> + <structure> + <property name="columnName">GrossProfit</property> + <property name="displayName">GP</property> + </structure> + <structure> + <property name="columnName">AverageMerchandizeProfit</property> + <property name="displayName">AMP</property> + </structure> + <structure> + <property name="columnName">AverageGrossProfit</property> + <property name="displayName">AGP</property> + </structure> + <structure> + <property name="columnName">orderDateWeekOfYear</property> + <property name="displayName">orderDateWeekOfYear</property> + </structure> + <structure> + <property name="columnName">orderDateDescription</property> + <property name="displayName">orderDateDescription</property> + </structure> + <structure> + <property name="columnName">AccountType</property> + <property name="displayName">AccountType</property> + </structure> + <structure> + <property name="columnName">Pod</property> + <property name="displayName">Pod</property> + </structure> + <structure> + <property name="columnName">Account</property> + <property name="displayName">Account</property> + </structure> + <structure> + <property name="columnName">SalesChannel</property> + <property name="displayName">SalesChannel</property> + </structure> + <structure> + <property name="columnName">orderDateYearName</property> + <property name="displayName">orderDateYearName</property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">orderDateYearName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateWeekOfYear</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">orderDateDayName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">orderDateDescription</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">quantity</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GrossSales</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GrossMerchandizeSales</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GrossMerchandizeProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">GrossShippingProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">GrossProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">AverageMerchandizeProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">AverageGrossProfit</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">AccountType</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFbiz</property> + <method name="open"><![CDATA[importPackage(Packages.org.ofbiz.minilang) +importPackage(Packages.org.ofbiz.minilang.method) +importPackage(Packages.org.ofbiz.base.util) +importPackage(Packages.org.eclipse.birt.report.engine.api) + +appContext = reportContext.getAppContext(); +classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY); +starschemas = null; +try +{ + fromDate = params["fromDate"].value; + thruDate = params["thruDate"].value; + methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE); + methodContext.putEnv("fromDate", fromDate); + methodContext.putEnv("thruDate", thruDate); + SimpleMethod.runSimpleMethod("component://order/script/org/ofbiz/order/reports/SalesReportEvent.xml", "getOrder", methodContext); + starschemas = methodContext.getEnv("starschemas"); +} +catch (e) +{ + Debug.logError(e,""); +} + +currentRow = 0; +totalRows = 0; +account_type1 = "VV"; +account_type2 = "B2B"; +pod1 = "English Pod"; +pod2 = "Latin Pod"; +account_VV_AU = "VV-AU"; +account_VV_CA = "VV-CA"; +account_VV_IE = "VV-IE"; +account_VV_SG = "VV-SG"; +account_VV_UK = "VV-UK"; +account_VV_US = "VV-US"; +account_VV_DE = "VV-DE"; +account_VV_ES = "VV-ES"; +account_VV_FR = "VV-FR"; +account_VV_IT = "VV-IT"; +account_B2B_AU = "B2B-AU"; +account_B2B_CA = "B2B-CA"; +account_B2B_IE = "B2B-IE"; +account_B2B_SG = "B2B-SG"; +account_B2B_UK = "B2B-UK"; +account_B2B_US = "B2B-US"; +account_B2B_DE = "B2B-DE"; +account_B2B_ES = "B2B-ES"; +account_B2B_FR = "B2B-FR"; +account_B2B_IT = "B2B-IT"; + +if (starschemas) +{ + totalRows = starschemas.size(); +}]]></method> + <method name="fetch"><![CDATA[if (currentRow >= 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"); + + 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 == "VV_AU_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_AU; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_CA_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_CA; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_IE_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_IE; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_SG_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_SG; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_UK_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_UK; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_US_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod1; + row["Account"] = account_VV_US; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_DE_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod2; + row["Account"] = account_VV_DE; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_ES_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod2; + row["Account"] = account_VV_ES; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_FR_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod2; + row["Account"] = account_VV_FR; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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 == "VV_IT_SALES_CHANNEL") + { + row["AccountType"] = account_type1; + row["Pod"] = pod2; + row["Account"] = account_VV_IT; + row["SalesChannel"] = salesChannelEnumId; + row["orderDateYearName"] = orderDateYearName; + 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["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["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["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["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["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["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["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["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["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["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;]]></method> + </script-data-set> + </data-sets> + <cubes> + <tabular-cube name="BIC_DataCube" id="419"> + <property name="defaultMeasureGroup">Summary Field1</property> + <property name="dimensions"> + <tabular-dimension name="Date" id="1473"> + <property name="defaultHierarchy">NewTabularHierarchy</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy" id="1474"> + <property name="levels"> + <tabular-level name="orderDateYearName" id="1815"> + <property name="dataType">string</property> + <property name="columnName">orderDateYearName</property> + </tabular-level> + <tabular-level name="orderDateWeekOfYear" id="1475"> + <property name="dataType">string</property> + <property name="columnName">orderDateWeekOfYear</property> + </tabular-level> + <tabular-level name="orderDateDescription" id="1476"> + <property name="dataType">string</property> + <property name="columnName">orderDateDescription</property> + </tabular-level> + <tabular-level name="orderDateDayName" id="1477"> + <property name="dataType">string</property> + <property name="columnName">orderDateDayName</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + <tabular-dimension name="Account" id="1478"> + <property name="defaultHierarchy">NewTabularHierarchy1</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy1" id="1479"> + <property name="levels"> + <tabular-level name="AccountType" id="1480"> + <property name="dataType">string</property> + <property name="columnName">AccountType</property> + </tabular-level> + <tabular-level name="Pod" id="1481"> + <property name="dataType">string</property> + <property name="columnName">Pod</property> + </tabular-level> + <tabular-level name="Account" id="1482"> + <property name="dataType">string</property> + <property name="columnName">Account</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + </property> + <property name="measureGroups"> + <tabular-measure-group name="Summary Field1" id="435"> + <property name="measures"> + <tabular-measure name="quantity" id="436"> + <expression name="measureExpression">dataSetRow["quantity"]</expression> + <property name="dataType">integer</property> + </tabular-measure> + <tabular-measure name="GrossSales" id="437"> + <expression name="measureExpression">dataSetRow["GrossSales"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GrossMerchandizeSales" id="438"> + <expression name="measureExpression">dataSetRow["GrossMerchandizeSales"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GrossMerchandizeProfit" id="439"> + <expression name="measureExpression">dataSetRow["GrossMerchandizeProfit"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GrossShippingProfit" id="440"> + <expression name="measureExpression">dataSetRow["GrossShippingProfit"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GrossProfit" id="441"> + <expression name="measureExpression">dataSetRow["GrossProfit"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="AverageMerchandizeProfit" id="442"> + <property name="function">sum</property> + <property name="isCalculated">false</property> + <expression name="measureExpression">dataSetRow["GrossMerchandizeProfit"]/dataSetRow["quantity"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="AverageGrossProfit" id="443"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["GrossProfit"]/dataSetRow["quantity"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + </property> + </tabular-measure-group> + </property> + <property name="dataSet">BIC</property> + </tabular-cube> + </cubes> + <styles> + <style name="crosstab-cell" id="4"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + <style name="crosstab" id="5"> + <property name="backgroundColor">#4D4D4D</property> + <property name="textUnderline">none</property> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + <style name="NewStyle" id="176"> + <property name="backgroundColor">#C0C0C0</property> + </style> + <style name="NewStyle2" id="177"> + <property name="borderBottomColor">#808080</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#808080</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#808080</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#808080</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="marginTop">1pt</property> + <property name="marginLeft">1pt</property> + <property name="marginBottom">1pt</property> + <property name="marginRight">1pt</property> + </style> + </styles> + <page-setup> + <simple-master-page name="Simple MasterPage" id="2"> + <property name="type">us-legal</property> + <property name="orientation">landscape</property> + <property name="topMargin">1in</property> + <property name="leftMargin">1.25in</property> + <property name="bottomMargin">1in</property> + <property name="rightMargin">1.25in</property> + <page-footer> + <text id="3"> + <property name="contentType">html</property> + <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> + </text> + </page-footer> + </simple-master-page> + </page-setup> + <body> + <text id="194"> + <property name="contentType">html</property> + <text-property name="content"><![CDATA[<CENTER> +<H4><B>Sale Report<B></H4> +</CENTER>]]></text-property> + </text> + <extended-item extensionName="Crosstab" id="1483"> + <property name="emptyCellValue">0</property> + <property name="measures"> + <extended-item extensionName="MeasureView" id="1494"> + <property name="measure">quantity</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1495"> + <property name="content"> + <data name="quantity" id="1497"> + <property name="textAlign">left</property> + <property name="resultSetColumn">quantity</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1969"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1970"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">quantity_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1985"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1986"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">quantity_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2001"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2002"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">quantity_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1496"> + <property name="content"> + <label id="1498"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">Sold Qty</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1499"> + <property name="measure">GrossSales</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1500"> + <property name="content"> + <data name="GrossSales" id="1502"> + <property name="textAlign">left</property> + <property name="resultSetColumn">GrossSales</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1971"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1972"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossSales_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1987"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1988"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossSales_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2003"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2004"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossSales_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1501"> + <property name="content"> + <label id="1503"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">GS</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1504"> + <property name="measure">GrossMerchandizeSales</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1505"> + <property name="content"> + <data name="GrossMerchandizeSales" id="1507"> + <property name="resultSetColumn">GrossMerchandizeSales</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1973"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1974"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeSales_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1989"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1990"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeSales_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2005"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2006"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeSales_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1506"> + <property name="content"> + <label id="1508"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">GMS</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1509"> + <property name="measure">GrossMerchandizeProfit</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1510"> + <property name="content"> + <data name="GrossMerchandizeProfit" id="1512"> + <property name="resultSetColumn">GrossMerchandizeProfit</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1975"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1976"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeProfit_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1991"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1992"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeProfit_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2007"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2008"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossMerchandizeProfit_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1511"> + <property name="content"> + <label id="1513"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">GMP</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1514"> + <property name="measure">GrossShippingProfit</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1515"> + <property name="content"> + <data name="GrossShippingProfit" id="1517"> + <property name="resultSetColumn">GrossShippingProfit</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1977"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1978"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossShippingProfit_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1993"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1994"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossShippingProfit_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2009"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2010"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossShippingProfit_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1516"> + <property name="content"> + <label id="1518"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">GSP</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1519"> + <property name="measure">GrossProfit</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1520"> + <property name="content"> + <data name="GrossProfit" id="1522"> + <property name="resultSetColumn">GrossProfit</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1979"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1980"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossProfit_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1995"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1996"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossProfit_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2011"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2012"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">GrossProfit_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1521"> + <property name="content"> + <label id="1523"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">GP</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1524"> + <property name="measure">AverageMerchandizeProfit</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1525"> + <property name="content"> + <data name="AverageMerchandizeProfit" id="1527"> + <property name="resultSetColumn">AverageMerchandizeProfit</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1981"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1982"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageMerchandizeProfit_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1997"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1998"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageMerchandizeProfit_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2013"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2014"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageMerchandizeProfit_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1526"> + <property name="content"> + <label id="1528"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">AMP</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="MeasureView" id="1529"> + <property name="measure">AverageGrossProfit</property> + <property name="detail"> + <extended-item extensionName="CrosstabCell" id="1530"> + <property name="content"> + <data name="AverageGrossProfit" id="1532"> + <property name="resultSetColumn">AverageGrossProfit</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregations"> + <extended-item extensionName="AggregationCell" id="1983"> + <property name="aggregationOnRow">Account/AccountType</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="1984"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageGrossProfit_Account/AccountType_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="1999"> + <property name="aggregationOnRow">Account/Pod</property> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2000"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageGrossProfit_Account/Pod_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + <extended-item extensionName="AggregationCell" id="2015"> + <property name="aggregationOnColumn">Date/orderDateDescription</property> + <property name="content"> + <data id="2016"> + <property name="fontWeight">bold</property> + <property name="resultSetColumn">AverageGrossProfit_Date/orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + <property name="header"> + <extended-item extensionName="CrosstabCell" id="1531"> + <property name="content"> + <label id="1533"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">AGP</text-property> + </label> + </property> + </extended-item> + </property> + </extended-item> + </property> + <property name="rows"> + <extended-item extensionName="CrosstabView" id="1489"> + <property name="grandTotal"> + <extended-item extensionName="CrosstabCell" id="1589"> + <property name="content"> + <label id="1606"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">Grand Total</text-property> + </label> + </property> + <property name="backgroundColor">#FFFFFF</property> + </extended-item> + </property> + <property name="views"> + <extended-item extensionName="DimensionView" id="1543"> + <property name="dimension">Account</property> + <property name="levels"> + <extended-item extensionName="LevelView" name="NewLevel View1" id="1544"> + <property name="level">Account/AccountType</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1545"> + <property name="content"> + <data name="AccountType" id="1546"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">AccountType</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregationHeader"> + <extended-item extensionName="CrosstabCell" id="1553"> + <property name="content"> + <label id="1570"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">Total</text-property> + </label> + </property> + <property name="backgroundColor">#FFFFFF</property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="LevelView" name="NewLevel View3" id="1547"> + <property name="level">Account/Pod</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1548"> + <property name="content"> + <data name="Pod" id="1549"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">Pod</property> + </data> + </property> + </extended-item> + </property> + <property name="aggregationHeader"> + <extended-item extensionName="CrosstabCell" id="1571"> + <property name="content"> + <label id="1588"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">Total</text-property> + </label> + </property> + <property name="backgroundColor">#FFFFFF</property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="LevelView" name="NewLevel View4" id="1550"> + <property name="level">Account/Account</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1551"> + <property name="content"> + <data name="Account" id="1552"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">Account</property> + </data> + </property> + </extended-item> + </property> + </extended-item> + </property> + </extended-item> + </property> + </extended-item> + </property> + <property name="columns"> + <extended-item extensionName="CrosstabView" id="1484"> + <property name="views"> + <extended-item extensionName="DimensionView" id="1864"> + <property name="dimension">Date</property> + <property name="levels"> + <extended-item extensionName="LevelView" name="NewLevel View" id="1865"> + <property name="level">Date/orderDateYearName</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1866"> + <property name="content"> + <data name="orderDateYearName" id="1915"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">orderDateYearName</property> + </data> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="LevelView" name="NewLevel View2" id="1916"> + <property name="level">Date/orderDateWeekOfYear</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1917"> + <property name="content"> + <data name="orderDateWeekOfYear" id="1966"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">orderDateWeekOfYear</property> + </data> + </property> + </extended-item> + </property> + </extended-item> + <extended-item extensionName="LevelView" name="NewLevel View5" id="1967"> + <property name="level">Date/orderDateDescription</property> + <property name="member"> + <extended-item extensionName="CrosstabCell" id="1968"> + <property name="content"> + <data name="orderDateDescription" id="2017"> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <property name="resultSetColumn">orderDateDescription</property> + </data> + </property> + </extended-item> + </property> + </extended-item> + </property> + </extended-item> + </property> + </extended-item> + </property> + <property name="backgroundColor">#FFFFFF</property> + <property name="cube">BIC_DataCube</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">quantity</property> + <expression name="expression">measure["quantity"]</expression> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="name">GrossSales</property> + <expression name="expression">measure["GrossSales"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">GrossMerchandizeSales</property> + <expression name="expression">measure["GrossMerchandizeSales"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">GrossMerchandizeProfit</property> + <expression name="expression">measure["GrossMerchandizeProfit"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">GrossShippingProfit</property> + <expression name="expression">measure["GrossShippingProfit"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">GrossProfit</property> + <expression name="expression">measure["GrossProfit"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">AverageMerchandizeProfit</property> + <expression name="expression">measure["AverageMerchandizeProfit"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">AverageGrossProfit</property> + <expression name="expression">measure["AverageGrossProfit"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">AccountType</property> + <expression name="expression">dimension["Account"]["AccountType"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">Pod</property> + <expression name="expression">dimension["Account"]["Pod"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">Account</property> + <expression name="expression">dimension["Account"]["Account"]</expression> + <property name="dataType">string</property> + </structure> + <structure> [... 907 lines stripped ...] |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |