You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ha...@apache.org on 2009/12/15 16:34:30 UTC
svn commit: r890830 [6/7] - in /ofbiz/trunk:
applications/accounting/webapp/accounting/WEB-INF/
applications/accounting/webapp/accounting/WEB-INF/actions/payment/
applications/accounting/webapp/accounting/payment/report/
applications/accounting/widget/...
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 ...]