Google Git
Sign in
apache / ofbiz / refs/tags/RemovingPOS / . / specialpurpose / birt / webapp / ordermgr / reports / NetBeforeOverheadReport.rptdesign
blob: 10fa2e4011064a3260680140e16cc9d1477beb7e [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<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 &lt;2.2.2.v20080226-1155></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;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">NBO Cube.NBO.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Cube.NBO.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Cube.Account.NewTabularHierarchy1.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Cube.Account.NewTabularHierarchy1.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Cube.NBO.width</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Cube.NBO.height</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Data Cube.NBO.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Data Cube.NBO.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Date Data Cube.NBO.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Date Data Cube.NBO.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Mouthly Data Cube.NBO_Monthly.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">NBO Mouthly Data Cube.NBO_Monthly.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
</list-property>
<property name="NBO Cube.NBO.x">261</property>
<property name="NBO Cube.NBO.y">35</property>
<property name="NBO Cube.Account.NewTabularHierarchy1.x">10</property>
<property name="NBO Cube.Account.NewTabularHierarchy1.y">172</property>
<property name="NBO Cube.NBO.width">150</property>
<property name="NBO Cube.NBO.height">200</property>
<property name="NBO Data Cube.NBO.x">135</property>
<property name="NBO Data Cube.NBO.y">80</property>
<property name="NBO Date Data Cube.NBO.x">135</property>
<property name="NBO Date Data Cube.NBO.y">80</property>
<property name="NBO Mouthly Data Cube.NBO_Monthly.x">135</property>
<property name="NBO Mouthly Data Cube.NBO_Monthly.y">80</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<parameters>
<scalar-parameter name="productStoreId" id="4755">
<property name="valueType">static</property>
<property name="dataType">string</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="DateDay" id="226">
<property name="valueType">static</property>
<property name="dataType">string</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="DateMonth" id="8">
<property name="valueType">static</property>
<property name="dataType">integer</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="DateYear" id="4754">
<property name="valueType">static</property>
<property name="dataType">integer</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="NunberDate" id="1122">
<property name="valueType">static</property>
<property name="dataType">integer</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="NBO_Month" id="238">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</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">orderDateDateValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Parcel</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">GS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">GMS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GMP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GSP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">eBay</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">eBay%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">RRC</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">RRC%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">Others</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">GP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">GMP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">Monthly Projection</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Monthly Forecast</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">Daily</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">Date</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">Month</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">MonthName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">Today</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">SalesChannel</property>
<property name="displayName">SalesChannel</property>
</structure>
<structure>
<property name="columnName">orderDateMonthName</property>
<property name="displayName">orderDateMonthName</property>
</structure>
<structure>
<property name="columnName">orderDateDateValue</property>
<property name="displayName">orderDateDateValue</property>
</structure>
<structure>
<property name="columnName">Parcel</property>
<property name="displayName">Parcel</property>
</structure>
<structure>
<property name="columnName">GS</property>
<property name="displayName">GS</property>
</structure>
<structure>
<property name="columnName">GMS</property>
<property name="displayName">GMS</property>
</structure>
<structure>
<property name="columnName">GMP</property>
<property name="displayName">GMP</property>
</structure>
<structure>
<property name="columnName">GSP</property>
<property name="displayName">GSP</property>
</structure>
<structure>
<property name="columnName">GP</property>
<property name="displayName">GP</property>
</structure>
<structure>
<property name="columnName">eBay</property>
<property name="displayName">eBay</property>
</structure>
<structure>
<property name="columnName">eBay%</property>
<property name="displayName">eBay%</property>
</structure>
<structure>
<property name="columnName">RRC</property>
<property name="displayName">RRC</property>
</structure>
<structure>
<property name="columnName">RRC%</property>
<property name="displayName">RRC%</property>
</structure>
<structure>
<property name="columnName">Others</property>
<property name="displayName">Others</property>
</structure>
<structure>
<property name="columnName">GP%</property>
<property name="displayName">GP%</property>
</structure>
<structure>
<property name="columnName">GMP%</property>
<property name="displayName">GMP%</property>
</structure>
<structure>
<property name="columnName">NBO</property>
<property name="displayName">NBO</property>
</structure>
<structure>
<property name="columnName">Daily</property>
<property name="displayName">Daily</property>
</structure>
<structure>
<property name="columnName">Monthly Projection</property>
<property name="displayName">Monthly Projection</property>
</structure>
<structure>
<property name="columnName">Monthly Forecast</property>
<property name="displayName">Monthly Forecast</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">Date</property>
<property name="displayName">Date</property>
</structure>
<structure>
<property name="columnName">Month</property>
<property name="displayName">Month</property>
</structure>
<structure>
<property name="columnName">MonthName</property>
<property name="displayName">MonthName</property>
</structure>
<structure>
<property name="columnName">Today</property>
<property name="displayName">Today</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</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">orderDateDateValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Parcel</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">GS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">GMS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GMP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GSP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">eBay</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">eBay%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">RRC</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">RRC%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">Others</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">GP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">GMP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">Monthly Projection</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Monthly Forecast</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">Daily</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">Date</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">Month</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">MonthName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">Today</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">OFbiz</property>
<method name="open"><![CDATA[importPackage(Packages.org.apache.ofbiz.minilang)
importPackage(Packages.org.apache.ofbiz.minilang.method)
importPackage(Packages.org.apache.ofbiz.base.util)
importPackage(Packages.org.eclipse.birt.report.engine.api)
appContext = reportContext.getAppContext();
classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY);
starschemas = null;
try
{
productStoreId = params["productStoreId"].value;
DateMonth = params["DateMonth"].value;
DateYear = params["DateYear"].value;
methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE);
methodContext.putEnv("productStoreId", productStoreId);
methodContext.putEnv("DateMonth", DateMonth);
methodContext.putEnv("DateYear", DateYear);
SimpleMethod.runSimpleMethod("component://order/minilang/reports/NetBeforeOverheadEvent.xml", "getOrder", methodContext);
starschemas = methodContext.getEnv("starschemas");
}
catch (e)
{
Debug.logError(e,"");
}
DateMonth = 12;
currentRow = 0;
totalRows = 0;
pod1 = "English";
pod2 = "Latin";
account_B2C_AU = "B2C-AU";
account_B2C_CA = "B2C-CA";
account_B2C_IE = "B2C-IE";
account_B2C_SG = "B2C-SG";
account_B2C_UK = "B2C-UK";
account_B2C_US = "B2C-US";
account_B2C_DE = "B2C-DE";
account_B2C_ES = "B2C-ES";
account_B2C_FR = "B2C-FR";
account_B2C_IT = "B2C-IT";
if (starschemas)
{
totalRows = starschemas.size();
}]]></method>
<method name="fetch"><![CDATA[if (currentRow >= totalRows) return false;
{
starschema = starschemas.get(currentRow);
orderDateDateValue = starschema.getString("orderDateDateValue");
orderDateDayName = starschema.getString("orderDateDayName");
orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear");
orderDateDescription = starschema.getString("orderDateDescription");
quantity = starschema.getString("quantity");
GS = starschema.getString("GrossSales");
GMS = starschema.getString("GrossMerchandizeSales");
GMP = starschema.getString("GrossMerchandizeProfit");
GSP = starschema.getString("GrossShippingProfit");
GP = starschema.getString("GrossProfit");
eBay = starschema.getString("eBay");
RRC = starschema.getString("RRC");
Others = starschema.getString("OtherFree");
NBO = starschema.getString("NBO");
salesChannelEnumId = starschema.getString("salesChannelEnumId");
if (orderDateMonthOfYear == DateMonth)
{
row["Daily"] = 1;
}
else
{
row["Daily"] = 2;
}
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
currentRow ++;
}
return true;]]></method>
</script-data-set>
<script-data-set name="NBO_Date" id="2898">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">orderDateDayOfMonth</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">orderDateMonthName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">orderDateYearName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">orderDateDateValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">Parcel</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GMS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GMP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">GSP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">GP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">eBay</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">eBay%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">RRC</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">RRC%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">Others</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">GP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">GMP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Date</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">SalesChannel</property>
<property name="displayName">SalesChannel</property>
</structure>
<structure>
<property name="columnName">orderDateDayOfMonth</property>
<property name="displayName">orderDateDayOfMonth</property>
</structure>
<structure>
<property name="columnName">orderDateMonthName</property>
<property name="displayName">orderDateMonthName</property>
</structure>
<structure>
<property name="columnName">orderDateYearName</property>
<property name="displayName">orderDateYearName</property>
</structure>
<structure>
<property name="columnName">orderDateDateValue</property>
<property name="displayName">orderDateDateValue</property>
</structure>
<structure>
<property name="columnName">Parcel</property>
<property name="displayName">Parcel</property>
</structure>
<structure>
<property name="columnName">GS</property>
<property name="displayName">GS</property>
</structure>
<structure>
<property name="columnName">GMS</property>
<property name="displayName">GMS</property>
</structure>
<structure>
<property name="columnName">GMP</property>
<property name="displayName">GMP</property>
</structure>
<structure>
<property name="columnName">GSP</property>
<property name="displayName">GSP</property>
</structure>
<structure>
<property name="columnName">eBay</property>
<property name="displayName">eBay</property>
</structure>
<structure>
<property name="columnName">RRC</property>
<property name="displayName">RRC</property>
</structure>
<structure>
<property name="columnName">Others</property>
<property name="displayName">Others</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">Date</property>
<property name="displayName">Date</property>
</structure>
<structure>
<property name="columnName">NBO</property>
<property name="displayName">NBO</property>
</structure>
<structure>
<property name="columnName">eBay%</property>
<property name="displayName">eBay%</property>
</structure>
<structure>
<property name="columnName">RRC%</property>
<property name="displayName">RRC%</property>
</structure>
<structure>
<property name="columnName">GP%</property>
<property name="displayName">GP%</property>
</structure>
<structure>
<property name="columnName">GMP%</property>
<property name="displayName">GMP%</property>
</structure>
<structure>
<property name="columnName">GP</property>
<property name="displayName">GP</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">orderDateDayOfMonth</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">orderDateMonthName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">orderDateYearName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">orderDateDateValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">Parcel</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GMS</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GMP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">GSP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">GP</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">eBay</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">eBay%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">RRC</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">RRC%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">Others</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">GP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">GMP%</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Date</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">OFbiz</property>
<method name="open"><![CDATA[importPackage(Packages.org.apache.ofbiz.minilang)
importPackage(Packages.org.apache.ofbiz.minilang.method)
importPackage(Packages.org.apache.ofbiz.base.util)
importPackage(Packages.org.eclipse.birt.report.engine.api)
appContext = reportContext.getAppContext();
classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY);
starschemas = null;
try
{
productStoreId = params["productStoreId"].value;
DateDay = params["DateDay"].value;
methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE);
methodContext.putEnv("productStoreId", productStoreId);
methodContext.putEnv("DateDay", DateDay);
SimpleMethod.runSimpleMethod("component://order/minilang/reports/NetBeforeOverheadDateEvent.xml", "getOrder", methodContext);
Date_starschemas = methodContext.getEnv("Date_starschemas");
}
catch (e)
{
Debug.logError(e,"");
}
currentRow = 0;
totalRows = 0;
pod1 = "English";
pod2 = "Latin";
account_B2C_AU = "B2C-AU";
account_B2C_CA = "B2C-CA";
account_B2C_IE = "B2C-IE";
account_B2C_SG = "B2C-SG";
account_B2C_UK = "B2C-UK";
account_B2C_US = "B2C-US";
account_B2C_DE = "B2C-DE";
account_B2C_ES = "B2C-ES";
account_B2C_FR = "B2C-FR";
account_B2C_IT = "B2C-IT";
if (Date_starschemas)
{
totalRows = Date_starschemas.size();
}]]></method>
<method name="fetch"><![CDATA[if (currentRow >= totalRows) return false;
{
Date_starschema = Date_starschemas.get(currentRow);
orderDateDateValue = Date_starschema.getString("orderDateDateValue");
orderDateDayName = Date_starschema.getString("orderDateDayName");
orderDateDayOfMonth = Date_starschema.getString("orderDateDayOfMonth");
orderDateMonthName = Date_starschema.getString("orderDateMonthName");
orderDateYearName = Date_starschema.getString("orderDateYearName");
orderDateYearMonthDay = Date_starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = Date_starschema.getString("orderDateMonthOfYear");
orderDateDescription = Date_starschema.getString("orderDateDescription");
quantity = Date_starschema.getString("quantity");
GS = Date_starschema.getString("GrossSales");
GMS = Date_starschema.getString("GrossMerchandizeSales");
GMP = Date_starschema.getString("GrossMerchandizeProfit");
GSP = Date_starschema.getString("GrossShippingProfit");
GP = Date_starschema.getString("GrossProfit");
eBay = Date_starschema.getString("eBay");
RRC = Date_starschema.getString("RRC");
Others = Date_starschema.getString("OtherFree");
NBO = Date_starschema.getString("NBO");
salesChannelEnumId = Date_starschema.getString("salesChannelEnumId");
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["Date"] = orderDateYearMonthDay;
}
currentRow ++;
}
return true;]]></method>
</script-data-set>
<script-data-set name="NBO_Monthly" id="4650">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</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">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CountDate</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Monthly Forecast</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">SalesChannel</property>
<property name="displayName">SalesChannel</property>
</structure>
<structure>
<property name="columnName">orderDateMonthName</property>
<property name="displayName">orderDateMonthName</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">NBO</property>
<property name="displayName">NBO</property>
</structure>
<structure>
<property name="columnName">CountDate</property>
<property name="displayName">CountDate</property>
</structure>
<structure>
<property name="columnName">Monthly Forecast</property>
<property name="displayName">Monthly Forecast</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SalesChannel</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">Pod</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Account</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">NBO</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CountDate</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Monthly Forecast</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">OFbiz</property>
<method name="open"><![CDATA[importPackage(Packages.org.apache.ofbiz.minilang)
importPackage(Packages.org.apache.ofbiz.minilang.method)
importPackage(Packages.org.apache.ofbiz.base.util)
importPackage(Packages.org.eclipse.birt.report.engine.api)
appContext = reportContext.getAppContext();
classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY);
starschemas = null;
try
{
productStoreId = params["productStoreId"].value;
DateMonth = params["DateMonth"].value;
DateYear = params["DateYear"].value;
methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE);
methodContext.putEnv("productStoreId", productStoreId);
methodContext.putEnv("DateMonth", DateMonth);
methodContext.putEnv("DateYear", DateYear);
SimpleMethod.runSimpleMethod("component://order/minilang/reports/NetBeforeOverheadMonthlyEvent.xml", "getOrder", methodContext);
starschemas = methodContext.getEnv("starschemas");
}
catch (e)
{
Debug.logError(e,"");
}
currentRow = 0;
totalRows = 0;
pod1 = "English";
pod2 = "Latin";
account_B2C_AU = "B2C-AU";
account_B2C_CA = "B2C-CA";
account_B2C_IE = "B2C-IE";
account_B2C_SG = "B2C-SG";
account_B2C_UK = "B2C-UK";
account_B2C_US = "B2C-US";
account_B2C_DE = "B2C-DE";
account_B2C_ES = "B2C-ES";
account_B2C_FR = "B2C-FR";
account_B2C_IT = "B2C-IT";
if (starschemas)
{
totalRows = starschemas.size();
}]]></method>
<method name="fetch"><![CDATA[if (currentRow >= totalRows) return false;
{
starschema = starschemas.get(currentRow);
salesChannelEnumId = starschema.getString("salesChannelEnumId");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
NBO = starschema.getString("NBO");
CountDate = starschema.getString("CountDate");
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
currentRow ++;
}
return true;]]></method>
</script-data-set>
</data-sets>
<cubes>
<tabular-cube name="NBO Month Data Cube" id="1263">
<property name="defaultMeasureGroup">NBO Summary Field</property>
<property name="dimensions">
<tabular-dimension name="Date" id="1264">
<property name="isTimeType">false</property>
<property name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy" id="1265">
<property name="levels">
<tabular-level name="Today" id="2399">
<property name="dataType">string</property>
<property name="columnName">Today</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Account" id="1267">
<property name="defaultHierarchy">NewTabularHierarchy1</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy1" id="1268">
<property name="levels">
<tabular-level name="Pod" id="1270">
<property name="dataType">string</property>
<property name="columnName">Pod</property>
</tabular-level>
<tabular-level name="Account" id="1271">
<property name="dataType">string</property>
<property name="columnName">Account</property>
</tabular-level>
<tabular-level name="Daily" id="1783">
<property name="dataType">integer</property>
<property name="levelType">dynamic</property>
<list-property name="attributes">
<structure>
<property name="name">orderDateMonthName</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="columnName">Daily</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="NBO Summary Field" id="1733">
<property name="measures">
<tabular-measure name="Parcel" id="1734">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["Parcel"]</expression>
<property name="dataType">integer</property>
</tabular-measure>
<tabular-measure name="GS" id="1735">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["GS"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GMP" id="1737">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["GMP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GSP" id="1738">
<property name="function">average</property>
<property name="isCalculated">false</property>
<expression name="measureExpression">dataSetRow["GSP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GP" id="1739">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["GP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="eBay" id="1953">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["eBay"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="eBay%" id="2218">
<property name="function">average</property>
<expression name="measureExpression">(dataSetRow["eBay"]/dataSetRow["GP"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="RRC" id="1955">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["RRC"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="RRC%" id="2274">
<property name="function">average</property>
<property name="isCalculated">false</property>
<expression name="measureExpression">(dataSetRow["RRC"]/dataSetRow["GP"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="Others" id="1957">
<property name="function">average</property>
<property name="isCalculated">false</property>
<expression name="measureExpression">dataSetRow["Others"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GP%" id="2285">
<property name="function">average</property>
<expression name="measureExpression">(dataSetRow["GP"]/dataSetRow["GS"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GMP%" id="2286">
<property name="function">average</property>
<expression name="measureExpression">(dataSetRow["GMP"]/dataSetRow["GMS"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="NBO" id="2287">
<property name="function">average</property>
<expression name="measureExpression">dataSetRow["NBO"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">NBO_Month</property>
</tabular-cube>
<tabular-cube name="NBO Date Data Cube" id="3883">
<property name="defaultMeasureGroup">NBO_Today Summary Field</property>
<property name="dimensions">
<tabular-dimension name="Date_Today" id="3884">
<property name="defaultHierarchy">NewTabularHierarchy2</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy2" id="3885">
<property name="levels">
<tabular-level name="orderDateDateValue" id="3886">
<property name="dataType">string</property>
<property name="columnName">orderDateDateValue</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Account_Today" id="3887">
<property name="defaultHierarchy">NewTabularHierarchy3</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy3" id="3888">
<property name="levels">
<tabular-level name="Pod" id="3889">
<property name="dataType">string</property>
<property name="columnName">Pod</property>
</tabular-level>
<tabular-level name="Account" id="3890">
<property name="dataType">string</property>
<property name="columnName">Account</property>
</tabular-level>
<tabular-level name="Date" id="3891">
<property name="dataType">string</property>
<property name="columnName">Date</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="NBO_Today Summary Field" id="3892">
<property name="measures">
<tabular-measure name="Parcel1" id="3893">
<expression name="measureExpression">dataSetRow["Parcel"]</expression>
<property name="dataType">integer</property>
</tabular-measure>
<tabular-measure name="GS1" id="3894">
<expression name="measureExpression">dataSetRow["GS"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GMP1" id="4051">
<expression name="measureExpression">dataSetRow["GMP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GSP1" id="4052">
<expression name="measureExpression">dataSetRow["GSP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GP1" id="4053">
<expression name="measureExpression">dataSetRow["GP"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="eBay1" id="4054">
<expression name="measureExpression">dataSetRow["eBay"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="eBay%1" id="4055">
<expression name="measureExpression">(dataSetRow["eBay"]/dataSetRow["GP"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="RRC1" id="4056">
<expression name="measureExpression">dataSetRow["RRC"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="RRC%1" id="4057">
<expression name="measureExpression">(dataSetRow["RRC"]/dataSetRow["GP"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="Others1" id="4058">
<expression name="measureExpression">dataSetRow["Others"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GP%1" id="4059">
<expression name="measureExpression">(dataSetRow["GP"]/dataSetRow["GS"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="GMP%1" id="4060">
<expression name="measureExpression">(dataSetRow["GMP"]/dataSetRow["GMS"])</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="NBO1" id="4061">
<expression name="measureExpression">dataSetRow["NBO"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">NBO_Date</property>
</tabular-cube>
<tabular-cube name="NBO Mouthly Data Cube" id="4651">
<property name="defaultMeasureGroup">NBO MonthlySummary Field</property>
<property name="dimensions">
<tabular-dimension name="Monthly" id="4656">
<property name="defaultHierarchy">NewTabularHierarchy6</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy6" id="4657">
<property name="levels">
<tabular-level name="orderDateMonthName" id="4658">
<property name="dataType">string</property>
<property name="columnName">orderDateMonthName</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Accounts" id="4659">
<property name="defaultHierarchy">NewTabularHierarchy7</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy7" id="4660">
<property name="levels">
<tabular-level name="Pod" id="4661">
<property name="dataType">string</property>
<property name="columnName">Pod</property>
</tabular-level>
<tabular-level name="Account" id="4662">
<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="NBO MonthlySummary Field" id="4663">
<property name="measures">
<tabular-measure name="NBO Monthly" id="4664">
<property name="function">sum</property>
<expression name="measureExpression">dataSetRow["NBO"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="Monthly Projection" id="4666">
<expression name="measureExpression">(dataSetRow["NBO"]/dataSetRow["CountDate"])*params["NunberDate"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
<tabular-measure name="Monthly Forecast" id="4667">
<expression name="measureExpression">dataSetRow["Monthly Forecast"]</expression>
<property name="dataType">decimal</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">NBO_Monthly</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="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>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.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>
<label id="2410">
<property name="fontSize">xx-large</property>
<property name="fontWeight">normal</property>
<property name="paddingTop">1pt</property>
<property name="paddingBottom">20pt</property>
<property name="textAlign">center</property>
<text-property name="text">Net Before Overhead</text-property>
</label>
<extended-item extensionName="Crosstab" id="3988">
<property name="emptyCellValue">0</property>
<property name="measures">
<extended-item extensionName="MeasureView" id="3999">
<property name="measure">Parcel1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4000">
<property name="content">
<data name="Parcel1" id="4002">
<property name="resultSetColumn">Parcel1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4123">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4124">
<property name="resultSetColumn">Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4151">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4152">
<property name="resultSetColumn">Parcel1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4001">
<property name="content">
<label id="4003">
<property name="textAlign">center</property>
<text-property name="text">Parcel</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4062">
<property name="measure">GS1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4063">
<property name="content">
<data name="GS1" id="4065">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4125">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4126">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4153">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4154">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4064">
<property name="content">
<label id="4066">
<property name="textAlign">center</property>
<text-property name="text">GS</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4067">
<property name="measure">GMP1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4068">
<property name="content">
<data name="GMP1" id="4070">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4127">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4128">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4155">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4156">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4069">
<property name="content">
<label id="4071">
<property name="textAlign">center</property>
<text-property name="text">GMP</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4072">
<property name="measure">GSP1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4073">
<property name="content">
<data name="GSP1" id="4075">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4129">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4130">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4157">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4158">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4074">
<property name="content">
<label id="4076">
<property name="textAlign">center</property>
<text-property name="text">GSP</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4077">
<property name="measure">GP1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4078">
<property name="content">
<data name="GP1" id="4080">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4131">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4132">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4159">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4160">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4079">
<property name="content">
<label id="4081">
<property name="textAlign">center</property>
<text-property name="text">GP</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4082">
<property name="measure">eBay1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4083">
<property name="content">
<data name="eBay1" id="4085">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4133">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4134">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4161">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4162">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4084">
<property name="content">
<label id="4086">
<property name="textAlign">center</property>
<text-property name="text">eBay</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4087">
<property name="measure">eBay%1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4088">
<property name="content">
<data name="eBay%1" id="4090">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4135">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4136">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4163">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4164">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4089">
<property name="content">
<label id="4091">
<property name="textAlign">center</property>
<text-property name="text">eBay%</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4092">
<property name="measure">RRC1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4093">
<property name="content">
<data name="RRC1" id="4095">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4137">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4138">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4165">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4166">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4094">
<property name="content">
<label id="4096">
<property name="textAlign">center</property>
<text-property name="text">RRC</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4097">
<property name="measure">RRC%1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4098">
<property name="content">
<data name="RRC%1" id="4100">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">RRC%1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4139">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4140">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4167">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4168">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">RRC%1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4099">
<property name="content">
<label id="4101">
<property name="textAlign">center</property>
<text-property name="text">RRC%</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4102">
<property name="measure">Others1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4103">
<property name="content">
<data name="Others1" id="4105">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4141">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4142">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4169">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4170">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4104">
<property name="content">
<label id="4106">
<property name="textAlign">center</property>
<text-property name="text">Others</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4107">
<property name="measure">GP%1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4108">
<property name="content">
<data name="GP%1" id="4110">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4143">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4144">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4171">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4172">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4109">
<property name="content">
<label id="4111">
<property name="textAlign">center</property>
<text-property name="text">GP%</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4112">
<property name="measure">GMP%1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4113">
<property name="content">
<data name="GMP%1" id="4115">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4145">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4146">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4173">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4174">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4114">
<property name="content">
<label id="4116">
<property name="textAlign">center</property>
<text-property name="text">GMP%</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4117">
<property name="measure">NBO1</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4118">
<property name="content">
<data name="NBO1" id="4120">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO1</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4147">
<property name="aggregationOnRow">Account_Today/Pod</property>
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4148">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4175">
<property name="aggregationOnColumn">Date_Today/orderDateDateValue</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4176">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO1_Date_Today/orderDateDateValue</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4119">
<property name="content">
<label id="4121">
<property name="textAlign">center</property>
<text-property name="text">NBO</text-property>
</label>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="3989">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell" id="4150">
<property name="content">
<label id="4177">
<property name="textAlign">center</property>
<text-property name="text">Grand Total</text-property>
</label>
</property>
<property name="backgroundColor">#BFBFBF</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView" id="3990">
<property name="dimension">Account_Today</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View4" id="3991">
<property name="level">Account_Today/Pod</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="3992">
<property name="content">
<data name="Pod1" id="3993">
<property name="textAlign">center</property>
<property name="resultSetColumn">Pod</property>
</data>
</property>
<property name="backgroundColor">#FFFF00</property>
<property name="verticalAlign">middle</property>
</extended-item>
</property>
<property name="aggregationHeader">
<extended-item extensionName="CrosstabCell" id="4122">
<property name="content">
<label id="4149">
<property name="textAlign">center</property>
<text-property name="text">Pod Total</text-property>
</label>
</property>
<property name="backgroundColor">#E5E5E5</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="LevelView" name="NewLevel View6" id="4039">
<property name="level">Account_Today/Account</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="4040">
<property name="content">
<data name="Account1" id="4041">
<property name="textAlign">center</property>
<property name="resultSetColumn">Account</property>
</data>
</property>
<property name="backgroundColor">#FFFF00</property>
<property name="verticalAlign">middle</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="LevelView" name="NewLevel View7" id="4042">
<property name="level">Account_Today/Date</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="4043">
<property name="content">
<data name="Date" id="4044">
<property name="textAlign">center</property>
<property name="resultSetColumn">Date</property>
</data>
</property>
<property name="backgroundColor">#FFFF00</property>
<property name="verticalAlign">middle</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="3994">
<property name="views">
<extended-item extensionName="DimensionView" id="3995">
<property name="dimension">Date_Today</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View5" id="3996">
<property name="level">Date_Today/orderDateDateValue</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="3997">
<property name="content">
<data name="orderDateDateValue" id="3998">
<property name="textAlign">center</property>
<property name="resultSetColumn">orderDateDateValue</property>
</data>
</property>
<property name="backgroundColor">#FFFF00</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">NBO Date Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Pod</property>
<expression name="expression">dimension["Account_Today"]["Pod"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">orderDateDateValue</property>
<expression name="expression">dimension["Date_Today"]["orderDateDateValue"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Parcel1</property>
<expression name="expression">measure["Parcel1"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Account</property>
<expression name="expression">dimension["Account_Today"]["Account"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Date</property>
<expression name="expression">"Today"</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">GS1</property>
<expression name="expression">measure["GS1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GMP1</property>
<expression name="expression">measure["GMP1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GSP1</property>
<expression name="expression">measure["GSP1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GP1</property>
<expression name="expression">measure["GP1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">eBay1</property>
<expression name="expression">measure["eBay1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">eBay%1</property>
<expression name="expression">measure["eBay%1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">RRC1</property>
<expression name="expression">measure["RRC1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">RRC%1</property>
<expression name="expression">measure["RRC%1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Others1</property>
<expression name="expression">measure["Others1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GP%1</property>
<expression name="expression">measure["GP%1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GMP%1</property>
<expression name="expression">measure["GMP%1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">NBO1</property>
<expression name="expression">measure["NBO1"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["Parcel1"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GS1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GS1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GMP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GMP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GSP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GSP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GP1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">eBay1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["eBay1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["eBay%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">RRC1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["RRC1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["RRC%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Others1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["Others1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GP%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GP%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GMP%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">NBO1_Account_Today/Pod_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["NBO1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account_Today/Pod</value>
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Parcel1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["Parcel1"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GS1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GS1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GMP1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GMP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GSP1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GSP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GP1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GP1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">eBay1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["eBay1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">eBay%1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["eBay%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">RRC1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["RRC1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">RRC%1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["RRC%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Others1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["Others1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GP%1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GP%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">GMP%1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["GMP%1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">NBO1_Date_Today/orderDateDateValue</property>
<expression name="expression">measure["NBO1"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date_Today/orderDateDateValue</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
</list-property>
</extended-item>
<extended-item extensionName="Crosstab" id="2001">
<property name="emptyCellValue">0</property>
<property name="measures">
<extended-item extensionName="MeasureView" id="2305">
<property name="measure">Parcel</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2306">
<property name="content">
<data name="Parcel" id="2308">
<property name="resultSetColumn">Parcel</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2804">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2805">
<property name="resultSetColumn">Parcel_Account/Pod_Date/Today_1</property>
</data>
<data id="2864">
<property name="resultSetColumn">Parcel_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2834">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2835">
<property name="resultSetColumn">Parcel_Date/Today</property>
</data>
<data id="2878">
<property name="resultSetColumn">Parcel_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2307">
<property name="content">
<label id="2309">
<property name="textAlign">center</property>
<text-property name="text">Parcel</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2310">
<property name="measure">GS</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2311">
<property name="content">
<data name="GS" id="2313">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2806">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2807">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS_Account/Pod_Date/Today</property>
</data>
<data id="2865">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2836">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2837">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS_Date/Today</property>
</data>
<data id="2879">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GS_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2312">
<property name="content">
<label id="2314">
<property name="textAlign">center</property>
<text-property name="text">GS</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2320">
<property name="measure">GMP</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2321">
<property name="content">
<data name="GMP" id="2323">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2810">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2811">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP_Account/Pod_Date/Today</property>
</data>
<data id="2866">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2840">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2841">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMP_Date/Today</property>
</data>
<data id="2880">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GMO_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2322">
<property name="content">
<label id="2324">
<property name="textAlign">center</property>
<text-property name="text">GMP</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2325">
<property name="measure">GSP</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2326">
<property name="content">
<data name="GSP" id="2328">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2812">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2813">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP_Account/Pod_Date/Today</property>
</data>
<data id="2867">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2842">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2843">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP_Date/Today</property>
</data>
<data id="2881">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GSP_taotal_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2327">
<property name="content">
<label id="2329">
<property name="textAlign">center</property>
<text-property name="text">GSP</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2330">
<property name="measure">GP</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2331">
<property name="content">
<data name="GP" id="2333">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2814">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2815">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP_Account/Pod_Date/Today</property>
</data>
<data id="2868">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2844">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2845">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP_Date/Today</property>
</data>
<data id="2882">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">GP_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2332">
<property name="content">
<label id="2334">
<property name="textAlign">center</property>
<text-property name="text">GP</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2335">
<property name="measure">eBay</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2336">
<property name="content">
<data name="eBay" id="2338">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2816">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2817">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay_Account/Pod_Date/Today</property>
</data>
<data id="2869">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2846">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2847">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">eBay_Date/Today</property>
</data>
<data id="2883">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">ebay_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2337">
<property name="content">
<label id="2339">
<property name="textAlign">center</property>
<text-property name="text">eBay</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2340">
<property name="measure">eBay%</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2341">
<property name="content">
<data name="eBay%" id="2343">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2818">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2819">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%_Account/Pod_Date/Today</property>
</data>
<data id="2870">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2848">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2849">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%_Date/Today</property>
</data>
<data id="2884">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">eBay%_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2342">
<property name="content">
<label id="2344">
<property name="textAlign">center</property>
<text-property name="text">eBay%</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2345">
<property name="measure">RRC</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2346">
<property name="content">
<data name="RRC" id="2348">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2820">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2821">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC_Account/Pod_Date/Today</property>
</data>
<data id="2871">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2850">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2851">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC_Date/Today</property>
</data>
<data id="2885">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">RRC_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2347">
<property name="content">
<label id="2349">
<property name="textAlign">center</property>
<text-property name="text">RRC</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2350">
<property name="measure">RRC%</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2351">
<property name="content">
<data name="RRC%" id="2353">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">RRC%</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2822">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2823">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">RRC%_Account/Pod_Date/Today</property>
</data>
<data id="2872">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">RRC%_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2852">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2853">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">RRC%_Date/Today</property>
</data>
<data id="2886">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">RRC%_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2352">
<property name="content">
<label id="2354">
<property name="textAlign">center</property>
<text-property name="text">RRC%</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2355">
<property name="measure">Others</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2356">
<property name="content">
<data name="Others" id="2358">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2824">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2825">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others_Account/Pod_Date/Today</property>
</data>
<data id="2873">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2854">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2855">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others_Date/Today</property>
</data>
<data id="2887">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Others_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2357">
<property name="content">
<label id="2359">
<property name="textAlign">center</property>
<text-property name="text">Others</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2360">
<property name="measure">GP%</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2361">
<property name="content">
<data name="GP%" id="2363">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2826">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2827">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">GP%_Account/Pod_Date/Today</property>
</data>
<data id="2874">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0%</property>
</structure>
<property name="resultSetColumn">GP%_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2856">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2857">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%_Date/Today</property>
</data>
<data id="2888">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GP%_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2362">
<property name="content">
<label id="2364">
<property name="textAlign">center</property>
<text-property name="text">GP%</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2365">
<property name="measure">GMP%</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2366">
<property name="content">
<data name="GMP%" id="2368">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2828">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2829">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%_Account/Pod_Date/Today</property>
</data>
<data id="2875">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2858">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2859">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%_Date/Today</property>
</data>
<data id="2889">
<structure name="numberFormat">
<property name="category">Percent</property>
<property name="pattern">###0.0%</property>
</structure>
<property name="resultSetColumn">GMP%_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2367">
<property name="content">
<label id="2369">
<property name="textAlign">center</property>
<text-property name="text">GMP%</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="2370">
<property name="measure">NBO</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="2371">
<property name="content">
<data name="NBO" id="2373">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="2830">
<property name="aggregationOnRow">Account/Pod</property>
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="2831">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO_Account/Pod_Date/Today</property>
</data>
<data id="2876">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO_lastmonth</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="2860">
<property name="aggregationOnColumn">Date/Today</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="2861">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO_Date/Today</property>
</data>
<data id="2890">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO_total_lastmonth</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="2372">
<property name="content">
<label id="2374">
<property name="textAlign">center</property>
<text-property name="text">NBO</text-property>
</label>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="2047">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell" id="2833">
<property name="content">
<label id="2862">
<property name="textAlign">center</property>
<text-property name="text">Grand Total Avg this month</text-property>
</label>
<label id="2877">
<property name="textAlign">center</property>
<text-property name="text">Grand Total Avg last month</text-property>
</label>
</property>
<property name="backgroundColor">#BFBFBF</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView" id="2048">
<property name="dimension">Account</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View" id="2049">
<property name="level">Account/Pod</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="2050">
<property name="content">
<data name="Pod" id="2051">
<property name="marginTop">0pt</property>
<property name="paddingTop">1pt</property>
<property name="textAlign">center</property>
<property name="pageBreakBefore">auto</property>
<property name="resultSetColumn">Pod</property>
</data>
</property>
<property name="backgroundColor">#1E90FF</property>
<property name="verticalAlign">middle</property>
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<expression name="testExpr">data["Pod"]</expression>
<expression name="value1">English</expression>
<property name="backgroundColor">#FFFF00</property>
</structure>
</list-property>
</extended-item>
</property>
<property name="aggregationHeader">
<extended-item extensionName="CrosstabCell" id="2803">
<property name="content">
<label id="2832">
<property name="textAlign">center</property>
<text-property name="text">Pod Total Avg this month</text-property>
</label>
<label id="2863">
<property name="textAlign">center</property>
<text-property name="text">Pod Total Avg last month</text-property>
</label>
</property>
<property name="backgroundColor">#E5E5E5</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="LevelView" name="NewLevel View1" id="2375">
<property name="level">Account/Account</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="2376">
<property name="content">
<data name="Account" id="2377">
<property name="marginTop">0pt</property>
<property name="paddingTop">1pt</property>
<property name="textAlign">center</property>
<property name="resultSetColumn">Account</property>
</data>
</property>
<property name="backgroundColor">#1E90FF</property>
<property name="verticalAlign">middle</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="LevelView" name="NewLevel View2" id="2378">
<property name="level">Account/Daily</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="2379">
<property name="content">
<data name="Daily" id="2380">
<property name="textAlign">center</property>
<property name="resultSetColumn">Show_Daily</property>
</data>
</property>
<property name="backgroundColor">#1E90FF</property>
<property name="width">67px</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="2400">
<property name="views">
<extended-item extensionName="DimensionView" id="2401">
<property name="dimension">Date</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View3" id="2402">
<property name="level">Date/Today</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="2403">
<property name="content">
<data name="Today" id="2404">
<property name="textAlign">center</property>
<property name="resultSetColumn">Today</property>
</data>
</property>
<property name="backgroundColor">#1E90FF</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">NBO Month Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Pod</property>
<expression name="expression">dimension["Account"]["Pod"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Parcel</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">GS</property>
<expression name="expression">measure["GS"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GMP</property>
<expression name="expression">measure["GMP"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GSP</property>
<expression name="expression">measure["GSP"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GP</property>
<expression name="expression">measure["GP"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">eBay</property>
<expression name="expression">measure["eBay"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">eBay%</property>
<expression name="expression">measure["eBay%"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">RRC</property>
<expression name="expression">measure["RRC"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">RRC%</property>
<expression name="expression">measure["RRC%"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Others</property>
<expression name="expression">measure["Others"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GP%</property>
<expression name="expression">measure["GP%"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GMP%</property>
<expression name="expression">measure["GMP%"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">NBO</property>
<expression name="expression">measure["NBO"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Account</property>
<expression name="expression">dimension["Account"]["Account"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Daily</property>
<expression name="expression">dimension["Account"]["Daily"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Today</property>
<expression name="expression">"Average this month and last month"</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Show_Daily</property>
<expression name="expression">if(dimension["Account"]["Daily"]==1)
{
"Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3)
}
else if(dimension["Account"]["Daily"]==2)
{
"Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3)
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Parcel_Account/Pod_Date/Today</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GS_Account/Pod_Date/Today</property>
<expression name="expression">measure["GS"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GMP_Account/Pod_Date/Today</property>
<expression name="expression">measure["GMP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GSP_Account/Pod_Date/Today</property>
<expression name="expression">measure["GSP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GP_Account/Pod_Date/Today</property>
<expression name="expression">measure["GP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">eBay_Account/Pod_Date/Today</property>
<expression name="expression">measure["eBay"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">eBay%_Account/Pod_Date/Today</property>
<expression name="expression">measure["eBay%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">RRC_Account/Pod_Date/Today</property>
<expression name="expression">measure["RRC"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">RRC%_Account/Pod_Date/Today</property>
<expression name="expression">measure["RRC%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">Others_Account/Pod_Date/Today</property>
<expression name="expression">measure["Others"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GP%_Account/Pod_Date/Today</property>
<expression name="expression">measure["GP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GMP%_Account/Pod_Date/Today</property>
<expression name="expression">measure["GMP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">NBO_Account/Pod_Date/Today</property>
<expression name="expression">measure["NBO"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">Parcel_Date/Today</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GS_Date/Today</property>
<expression name="expression">measure["GS"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GMP_Date/Today</property>
<expression name="expression">measure["GMP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GSP_Date/Today</property>
<expression name="expression">measure["GSP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GP_Date/Today</property>
<expression name="expression">measure["GP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">eBay_Date/Today</property>
<expression name="expression">measure["eBay"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">eBay%_Date/Today</property>
<expression name="expression">measure["eBay%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">RRC_Date/Today</property>
<expression name="expression">measure["RRC"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">RRC%_Date/Today</property>
<expression name="expression">measure["RRC%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">Others_Date/Today</property>
<expression name="expression">measure["Others"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GP%_Date/Today</property>
<expression name="expression">measure["GP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">GMP%_Date/Today</property>
<expression name="expression">measure["GMP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">NBO_Date/Today</property>
<expression name="expression">measure["NBO"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">Parcel_Account/Pod_Date/Today_1</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==1</expression>
</structure>
<structure>
<property name="name">Parcel_lastmonth</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GS_lastmonth</property>
<expression name="expression">measure["GS"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GMP_lastmonth</property>
<expression name="expression">measure["GMP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GSP_lastmonth</property>
<expression name="expression">measure["GSP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GP_lastmonth</property>
<expression name="expression">measure["GP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">eBay_lastmonth</property>
<expression name="expression">measure["eBay"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">eBay%_lastmonth</property>
<expression name="expression">measure["eBay%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">RRC_lastmonth</property>
<expression name="expression">measure["RRC"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">RRC%_lastmonth</property>
<expression name="expression">measure["RRC%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">Others_lastmonth</property>
<expression name="expression">measure["Others"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GP%_lastmonth</property>
<expression name="expression">measure["GP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GMP%_lastmonth</property>
<expression name="expression">measure["GMP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">NBO_lastmonth</property>
<expression name="expression">measure["NBO"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Account/Pod</value>
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">Parcel_total_lastmonth</property>
<expression name="expression">measure["Parcel"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GS_total_lastmonth</property>
<expression name="expression">measure["GS"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GMO_total_lastmonth</property>
<expression name="expression">measure["GMP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GSP_taotal_lastmonth</property>
<expression name="expression">measure["GSP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GP_total_lastmonth</property>
<expression name="expression">measure["GP"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">ebay_total_lastmonth</property>
<expression name="expression">measure["eBay"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">eBay%_total_lastmonth</property>
<expression name="expression">measure["eBay%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">RRC_total_lastmonth</property>
<expression name="expression">measure["RRC"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">RRC%_total_lastmonth</property>
<expression name="expression">measure["RRC%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">Others_total_lastmonth</property>
<expression name="expression">measure["Others"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GP%_total_lastmonth</property>
<expression name="expression">measure["GP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">GMP%_total_lastmonth</property>
<expression name="expression">measure["GMP%"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">AVE</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
<structure>
<property name="name">NBO_total_lastmonth</property>
<expression name="expression">measure["NBO"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Date/Today</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<expression name="filterExpr">dimension["Account"]["Daily"]==2</expression>
</structure>
</list-property>
</extended-item>
<extended-item extensionName="Crosstab" id="4668">
<property name="emptyCellValue">0</property>
<property name="measures">
<extended-item extensionName="MeasureView" id="4679">
<property name="measure">NBO Monthly</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4680">
<property name="content">
<data name="NBO Monthly" id="4682">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO Monthly</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4698">
<property name="aggregationOnRow">Accounts/Pod</property>
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4699">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4706">
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4707">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">NBO Monthly_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4681">
<property name="content">
<label id="4683">
<property name="textAlign">center</property>
<text-property name="text">NBO</text-property>
</label>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4684">
<property name="measure">Monthly Projection</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4685">
<property name="content">
<data name="Monthly Projection1" id="4687">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Projection</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4700">
<property name="aggregationOnRow">Accounts/Pod</property>
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4701">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4708">
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4709">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Projection_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4686">
<property name="content">
<label id="4688">
<property name="textAlign">center</property>
<text-property name="text">Monthly Projection</text-property>
</label>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="MeasureView" id="4689">
<property name="measure">Monthly Forecast</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="4690">
<property name="content">
<data name="Monthly Forecast1" id="4692">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Forecast</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="4702">
<property name="aggregationOnRow">Accounts/Pod</property>
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#E5E5E5</property>
<property name="content">
<data id="4703">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="4710">
<property name="aggregationOnColumn">Monthly/orderDateMonthName</property>
<property name="backgroundColor">#BFBFBF</property>
<property name="content">
<data id="4711">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$###0</property>
</structure>
<property name="resultSetColumn">Monthly Forecast_Monthly/orderDateMonthName</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="4691">
<property name="content">
<label id="4693">
<property name="textAlign">center</property>
<text-property name="text">Monthly Forecast</text-property>
</label>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="4674">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell" id="4705">
<property name="content">
<label id="4712">
<property name="textAlign">center</property>
<text-property name="text">Grand Total</text-property>
</label>
</property>
<property name="backgroundColor">#BFBFBF</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView" id="4675">
<property name="dimension">Accounts</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View12" id="4676">
<property name="level">Accounts/Pod</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="4677">
<property name="content">
<data name="Pod3" id="4678">
<property name="textAlign">center</property>
<property name="resultSetColumn">Pod</property>
</data>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
<property name="aggregationHeader">
<extended-item extensionName="CrosstabCell" id="4697">
<property name="content">
<label id="4704">
<property name="textAlign">center</property>
<text-property name="text">Pod Total</text-property>
</label>
</property>
<property name="backgroundColor">#E5E5E5</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="LevelView" name="NewLevel View13" id="4694">
<property name="level">Accounts/Account</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="4695">
<property name="content">
<data name="Account3" id="4696">
<property name="textAlign">center</property>
<property name="resultSetColumn">Account</property>
</data>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="4669">
<property name="views">
<extended-item extensionName="DimensionView" id="4670">
<property name="dimension">Monthly</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View11" id="4671">
<property name="level">Monthly/orderDateMonthName</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="4672">
<property name="content">
<data name="orderDateMonthName1" id="4673">
<property name="textAlign">center</property>
<property name="resultSetColumn">orderDateMonthName</property>
</data>
</property>
<property name="backgroundColor">#A52A2A</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">NBO Mouthly Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">orderDateMonthName</property>
<expression name="expression">dimension["Monthly"]["orderDateMonthName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Pod</property>
<expression name="expression">dimension["Accounts"]["Pod"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NBO Monthly</property>
<expression name="expression">measure["NBO Monthly"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Monthly Projection</property>
<expression name="expression">measure["Monthly Projection"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Monthly Forecast</property>
<expression name="expression">measure["Monthly Forecast"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Account</property>
<expression name="expression">dimension["Accounts"]["Account"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName</property>
<expression name="expression">measure["NBO Monthly"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Accounts/Pod</value>
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName</property>
<expression name="expression">measure["Monthly Projection"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Accounts/Pod</value>
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName</property>
<expression name="expression">measure["Monthly Forecast"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Accounts/Pod</value>
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">NBO Monthly_Monthly/orderDateMonthName</property>
<expression name="expression">measure["NBO Monthly"]</expression>
<property name="dataType">decimal</property>
<simple-property-list name="aggregateOn">
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Monthly Projection_Monthly/orderDateMonthName</property>
<expression name="expression">measure["Monthly Projection"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Monthly Forecast_Monthly/orderDateMonthName</property>
<expression name="expression">measure["Monthly Forecast"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Monthly/orderDateMonthName</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
</list-property>
</extended-item>
</body>
</report>