You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ha...@apache.org on 2011/01/06 08:37:46 UTC
svn commit: r1055774 [3/5] - in /ofbiz/trunk: applications/accounting/data/
applications/order/ applications/order/entitydef/
applications/order/script/org/ofbiz/order/olap/
applications/order/script/org/ofbiz/order/reports/
applications/order/serviced...
Added: ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReportMonth.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReportMonth.rptdesign?rev=1055774&view=auto
==============================================================================
--- ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReportMonth.rptdesign (added)
+++ ofbiz/trunk/applications/order/webapp/ordermgr/reports/SalesReportMonth.rptdesign Thu Jan 6 07:37:45 2011
@@ -0,0 +1,1990 @@
+<?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.20" id="1">
+ <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447></property>
+ <property name="units">in</property>
+ <property name="comments">Copyright (c) 2007 <<Your Company Name here>></property>
+ <html-property name="description">Creates a blank report with no predefined content.</html-property>
+ <list-property name="userProperties">
+ <structure>
+ <property name="name">BIC_DataCube.BIC.x</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.BIC.y</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.x</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.y</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.BIC.width</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.BIC.height</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.width</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">BIC_DataCube.Account.NewTabularHierarchy1.height</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.Account.x</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.Account.y</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.Account.width</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.Account.height</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ <structure>
+ <property name="name">SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height</property>
+ <property name="type">integer</property>
+ <property name="isVisible">false</property>
+ </structure>
+ </list-property>
+ <property name="BIC_DataCube.BIC.x">284</property>
+ <property name="BIC_DataCube.BIC.y">29</property>
+ <property name="BIC_DataCube.Account.NewTabularHierarchy1.x">70</property>
+ <property name="BIC_DataCube.Account.NewTabularHierarchy1.y">35</property>
+ <property name="BIC_DataCube.BIC.width">150</property>
+ <property name="BIC_DataCube.BIC.height">200</property>
+ <property name="BIC_DataCube.Account.NewTabularHierarchy1.width">150</property>
+ <property name="BIC_DataCube.Account.NewTabularHierarchy1.height">200</property>
+ <property name="SaleOrder_DataCube.Account.x">280</property>
+ <property name="SaleOrder_DataCube.Account.y">17</property>
+ <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x">32</property>
+ <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y">39</property>
+ <property name="SaleOrder_DataCube.Account.width">150</property>
+ <property name="SaleOrder_DataCube.Account.height">200</property>
+ <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width">150</property>
+ <property name="SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height">200</property>
+ <text-property name="displayName">Blank Report</text-property>
+ <property name="iconFile">/templates/blank_report.gif</property>
+ <property name="layoutPreference">auto layout</property>
+ <parameters>
+ <scalar-parameter name="fromDate" id="310">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">date</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ <scalar-parameter name="thruDate" id="311">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">date</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ <scalar-parameter name="reportBy" id="2051">
+ <property name="valueType">static</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ <scalar-parameter name="thruWeek" id="2052">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">integer</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ <scalar-parameter name="thruMonth" id="2053">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">integer</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ <scalar-parameter name="thisYear" id="2729">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">integer</property>
+ <property name="distinct">true</property>
+ <property name="paramType">simple</property>
+ <property name="controlType">text-box</property>
+ <structure name="format">
+ <property name="category">Unformatted</property>
+ </structure>
+ </scalar-parameter>
+ </parameters>
+ <data-sources>
+ <script-data-source name="OFbiz" id="6"/>
+ </data-sources>
+ <data-sets>
+ <script-data-set name="BIC" id="7">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">Brand</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">Pod</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">Account</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">orderDateMonthOfYear</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">orderDateMonthName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">quantity</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">GS</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">GMS</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">GMP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">GSP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">GP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">Brand</property>
+ <text-property name="displayName">Brand</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">Pod</property>
+ <text-property name="displayName">Pod</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">Account</property>
+ <text-property name="displayName">Account</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">orderDateYearName</property>
+ <text-property name="displayName">orderDateYearName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">orderDateMonthOfYear</property>
+ <text-property name="displayName">orderDateMonthOfYear</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">orderDateMonthName</property>
+ <text-property name="displayName">orderDateMonthName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">quantity</property>
+ <text-property name="displayName">quantity</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">GS</property>
+ <text-property name="displayName">GS</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">GMS</property>
+ <text-property name="displayName">GMS</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">GMP</property>
+ <text-property name="displayName">GMP</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">GSP</property>
+ <text-property name="displayName">GSP</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">GP</property>
+ <text-property name="displayName">GP</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">Brand</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">Pod</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">Account</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">orderDateMonthOfYear</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">orderDateMonthName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">quantity</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">GS</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">GMS</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">GMP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">GSP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">GP</property>
+ <property name="dataType">integer</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFbiz</property>
+ <method name="open"><![CDATA[importPackage(Packages.org.ofbiz.minilang)
+importPackage(Packages.org.ofbiz.minilang.method)
+importPackage(Packages.org.ofbiz.base.util)
+importPackage(Packages.org.eclipse.birt.report.engine.api)
+
+appContext = reportContext.getAppContext();
+classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY);
+starschemas = null;
+try
+{
+ reportBy = params["reportBy"].value;
+ fromDate = params["fromDate"].value;
+ thruDate = params["thruDate"].value;
+ thruWeek = params["thruWeek"].value;
+ thruMonth = params["thruMonth"].value;
+ thisYear = params["thisYear"].value;
+ methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE);
+ methodContext.putEnv("reportBy", reportBy);
+ methodContext.putEnv("fromDate", fromDate);
+ methodContext.putEnv("thruDate", thruDate);
+ methodContext.putEnv("thruWeek", thruWeek);
+ methodContext.putEnv("thruMonth", thruMonth);
+ methodContext.putEnv("thisYear", thisYear);
+ SimpleMethod.runSimpleMethod("component://order/script/org/ofbiz/order/reports/SalesReportEvent.xml", "getOrder", methodContext);
+ starschemas = methodContext.getEnv("starschemas");
+}
+catch (e)
+{
+ Debug.logError(e,"");
+}
+
+currentRow = 0;
+totalRows = 0;
+
+if (starschemas)
+{
+ totalRows = starschemas.size();
+}]]></method>
+ <method name="fetch"><![CDATA[if (currentRow >= totalRows - 1) return false;
+{
+ starschema = starschemas.get(currentRow);
+ orderDateDescription = starschema.getString("orderDateDescription");
+ orderDateDayName = starschema.getString("orderDateDayName");
+ orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth");
+ orderDateMonthName = starschema.getString("orderDateMonthName");
+ orderDateYearName = starschema.getString("orderDateYearName");
+ orderDateWeekOfYear = starschema.getString("orderDateWeekOfYear");
+ orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay");
+ orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear");
+
+ brand = starschema.getString("brand");
+ pod = starschema.getString("pod");
+ account = starschema.getString("account");
+
+ quantity = starschema.getString("quantity");
+ GS = starschema.getString("GS");
+ GMS = starschema.getString("GMS");
+ GMP = starschema.getString("GMP");
+ GSP = starschema.getString("GSP");
+ GP = starschema.getString("GP");
+
+ row["Brand"] = brand;
+ row["Pod"] = pod;
+ row["Account"] = account;
+ row["orderDateYearName"] = orderDateYearName;
+ row["orderDateMonthOfYear"] = orderDateMonthOfYear;
+ row["orderDateMonthName"] = orderDateMonthName;
+ row["quantity"] = quantity;
+ row["GS"] = GS;
+ row["GMS"] = GMS;
+ row["GMP"] = GMP;
+ row["GSP"] = GSP;
+ row["GP"] = GP;
+
+ currentRow ++;
+}
+
+return true;]]></method>
+ </script-data-set>
+ </data-sets>
+ <cubes>
+ <tabular-cube name="BIC_DataCube" id="419">
+ <property name="dimensions">
+ <tabular-dimension name="Date" id="1473">
+ <property name="defaultHierarchy">NewTabularHierarchy</property>
+ <property name="hierarchies">
+ <tabular-hierarchy name="NewTabularHierarchy" id="1474">
+ <property name="levels">
+ <tabular-level name="orderDateYearName" id="1815">
+ <property name="dataType">string</property>
+ <property name="columnName">orderDateYearName</property>
+ </tabular-level>
+ <tabular-level name="orderDateMonthOfYear" id="2023">
+ <property name="dataType">string</property>
+ <property name="columnName">orderDateMonthOfYear</property>
+ </tabular-level>
+ <tabular-level name="orderDateMonthName" id="2019">
+ <property name="dataType">string</property>
+ <property name="columnName">orderDateMonthName</property>
+ </tabular-level>
+ </property>
+ </tabular-hierarchy>
+ </property>
+ </tabular-dimension>
+ <tabular-dimension name="Account" id="2036">
+ <property name="defaultHierarchy">NewTabularHierarchy1</property>
+ <property name="hierarchies">
+ <tabular-hierarchy name="NewTabularHierarchy1" id="2037">
+ <property name="levels">
+ <tabular-level name="Brand" id="2038">
+ <property name="dataType">string</property>
+ <property name="columnName">Brand</property>
+ </tabular-level>
+ <tabular-level name="Pod" id="2039">
+ <property name="dataType">string</property>
+ <property name="columnName">Pod</property>
+ </tabular-level>
+ <tabular-level name="Account" id="2040">
+ <property name="dataType">string</property>
+ <property name="columnName">Account</property>
+ </tabular-level>
+ </property>
+ </tabular-hierarchy>
+ </property>
+ </tabular-dimension>
+ </property>
+ <property name="measureGroups">
+ <tabular-measure-group name="Summary Field" id="2041">
+ <property name="measures">
+ <tabular-measure name="quantity" id="2042">
+ <expression name="measureExpression">dataSetRow["quantity"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ <tabular-measure name="GS" id="2581">
+ <expression name="measureExpression">dataSetRow["GS"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ <tabular-measure name="GMS" id="2582">
+ <expression name="measureExpression">dataSetRow["GMS"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ <tabular-measure name="GMP" id="2583">
+ <expression name="measureExpression">dataSetRow["GMP"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ <tabular-measure name="GSP" id="2584">
+ <expression name="measureExpression">dataSetRow["GSP"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ <tabular-measure name="GP" id="2585">
+ <expression name="measureExpression">dataSetRow["GP"]</expression>
+ <property name="dataType">integer</property>
+ </tabular-measure>
+ </property>
+ </tabular-measure-group>
+ </property>
+ <property name="dataSet">BIC</property>
+ </tabular-cube>
+ </cubes>
+ <styles>
+ <style name="crosstab-cell" id="4">
+ <property name="borderBottomColor">#CCCCCC</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">1pt</property>
+ <property name="borderLeftColor">#CCCCCC</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">1pt</property>
+ <property name="borderRightColor">#CCCCCC</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">1pt</property>
+ <property name="borderTopColor">#CCCCCC</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">1pt</property>
+ </style>
+ <style name="crosstab" id="5">
+ <property name="backgroundColor">#4D4D4D</property>
+ <property name="textUnderline">none</property>
+ <property name="borderBottomColor">#CCCCCC</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">1pt</property>
+ <property name="borderLeftColor">#CCCCCC</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">1pt</property>
+ <property name="borderRightColor">#CCCCCC</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">1pt</property>
+ <property name="borderTopColor">#CCCCCC</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">1pt</property>
+ </style>
+ <style name="NewStyle" id="176">
+ <property name="backgroundColor">#C0C0C0</property>
+ </style>
+ <style name="NewStyle2" id="177">
+ <property name="borderBottomColor">#808080</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#808080</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#808080</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#808080</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="marginTop">1pt</property>
+ <property name="marginLeft">1pt</property>
+ <property name="marginBottom">1pt</property>
+ <property name="marginRight">1pt</property>
+ </style>
+ </styles>
+ <page-setup>
+ <simple-master-page name="Simple MasterPage" id="2">
+ <property name="type">us-legal</property>
+ <property name="orientation">landscape</property>
+ <property name="topMargin">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="fontFamily">sans-serif</property>
+ <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="2018">
+ <property name="fontFamily">sans-serif</property>
+ <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">Sales Report Monthly</text-property>
+ </label>
+ <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="2586">
+ <property name="measures">
+ <extended-item extensionName="MeasureView" id="2588">
+ <property name="measure">quantity</property>
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2589">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2590">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">quantity_Account/Account_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2661">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2662">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">quantity_Account/Brand_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2679">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2680">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">quantity_Account/Pod_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2697">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2698">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">quantity_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2591">
+ <property name="content">
+ <label id="2592">
+ <text-property name="text">Sold Qty</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="MeasureView" id="2603">
+ <property name="measure">GMP</property>
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2604">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2605">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GMP_Account/Account_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2667">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2668">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GMP_Account/Brand_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2685">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2686">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GMP_Account/Pod_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2703">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2704">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GMP_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2606">
+ <property name="content">
+ <label id="2607">
+ <text-property name="text">GMP$</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="MeasureView" id="2608">
+ <property name="measure">GSP</property>
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2609">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2610">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GSP_Account/Account_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2669">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2670">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GSP_Account/Brand_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2687">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2688">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GSP_Account/Pod_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2705">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2706">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GSP_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2611">
+ <property name="content">
+ <label id="2612">
+ <text-property name="text">GSP$</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="MeasureView" id="2613">
+ <property name="measure">GP</property>
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2614">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2615">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GP_Account/Account_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2671">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2672">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GP_Account/Brand_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2689">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2690">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GP_Account/Pod_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2707">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2708">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0</property>
+ </structure>
+ <property name="resultSetColumn">GP_Date/orderDateMonthName</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2616">
+ <property name="content">
+ <label id="2617">
+ <text-property name="text">GP$</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="ComputedMeasureView" name="GMP%" id="2640">
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2641">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data name="GMP%1" id="2644">
+ <structure name="numberFormat">
+ <property name="category">Percent</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="2673">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2718">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Brand_GMP%</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2691">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2716">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Pod_GMP%</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2709">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2719">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Grand_GMP%</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2642">
+ <property name="content">
+ <label id="2643">
+ <text-property name="text">GMP%</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="ComputedMeasureView" name="GP%" id="2645">
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2646">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data name="GP%1" id="2649">
+ <structure name="numberFormat">
+ <property name="category">Percent</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="2674">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2721">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Brand_GP%</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2692">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2720">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Pod_GP%</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2710">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2722">
+ <structure name="numberFormat">
+ <property name="category">Percent</property>
+ <property name="pattern">#,##0%</property>
+ </structure>
+ <property name="resultSetColumn">Grand_GP%</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2647">
+ <property name="content">
+ <label id="2648">
+ <text-property name="text">GP%</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="ComputedMeasureView" name="AMP" id="2650">
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2651">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data name="AMP1" id="2654">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">AMP</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2675">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2724">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Brand_AMP</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2693">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2723">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Pod_AMP</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2711">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2725">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Grand_AMP</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2652">
+ <property name="content">
+ <label id="2653">
+ <text-property name="text">AMP</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="ComputedMeasureView" name="AGP" id="2655">
+ <property name="detail">
+ <extended-item extensionName="AggregationCell" id="2656">
+ <property name="aggregationOnRow">Account/Account</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEBCD</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data name="AGP1" id="2659">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">AGP</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="aggregations">
+ <extended-item extensionName="AggregationCell" id="2676">
+ <property name="aggregationOnRow">Account/Brand</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#87CEFA</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2727">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Brand_AGP</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2694">
+ <property name="aggregationOnRow">Account/Pod</property>
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#B0C4DE</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2726">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Pod_AGP</property>
+ </data>
+ </property>
+ </extended-item>
+ <extended-item extensionName="AggregationCell" id="2712">
+ <property name="aggregationOnColumn">Date/orderDateMonthName</property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#6495ED</property>
+ <property name="textAlign">center</property>
+ <property name="content">
+ <data id="2728">
+ <structure name="numberFormat">
+ <property name="category">Fixed</property>
+ <property name="pattern">#,##0.0</property>
+ </structure>
+ <property name="resultSetColumn">Grand_AGP</property>
+ </data>
+ </property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2657">
+ <property name="content">
+ <label id="2658">
+ <text-property name="text">AGP</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ </property>
+ <property name="rows">
+ <extended-item extensionName="CrosstabView" id="2629">
+ <property name="grandTotal">
+ <extended-item extensionName="CrosstabCell" id="2696">
+ <property name="content">
+ <label id="2713">
+ <text-property name="text">Grand Total</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ </extended-item>
+ </property>
+ <property name="views">
+ <extended-item extensionName="DimensionView" id="2630">
+ <property name="dimension">Account</property>
+ <property name="levels">
+ <extended-item extensionName="LevelView" name="NewLevel View3" id="2631">
+ <property name="level">Account/Brand</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2632">
+ <property name="content">
+ <data name="Brand" id="2633">
+ <property name="resultSetColumn">Brand</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ </extended-item>
+ </property>
+ <property name="aggregationHeader">
+ <extended-item extensionName="CrosstabCell" id="2660">
+ <property name="content">
+ <label id="2715">
+ <text-property name="text">Total</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="LevelView" name="NewLevel View4" id="2634">
+ <property name="level">Account/Pod</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2635">
+ <property name="content">
+ <data name="Pod" id="2636">
+ <property name="resultSetColumn">Pod</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ </extended-item>
+ </property>
+ <property name="aggregationHeader">
+ <extended-item extensionName="CrosstabCell" id="2678">
+ <property name="content">
+ <label id="2714">
+ <text-property name="text">Total</text-property>
+ </label>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="LevelView" name="NewLevel View5" id="2637">
+ <property name="level">Account/Account</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2638">
+ <property name="content">
+ <data name="Account" id="2639">
+ <property name="resultSetColumn">Account</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">small</property>
+ <property name="fontWeight">bold</property>
+ <property name="backgroundColor">#F5F5DC</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ </property>
+ </extended-item>
+ </property>
+ <property name="grandTotalLocation">after</property>
+ </extended-item>
+ </property>
+ <property name="columns">
+ <extended-item extensionName="CrosstabView" id="2618">
+ <property name="views">
+ <extended-item extensionName="DimensionView" id="2619">
+ <property name="dimension">Date</property>
+ <property name="levels">
+ <extended-item extensionName="LevelView" name="NewLevel View" id="2620">
+ <property name="level">Date/orderDateYearName</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2621">
+ <property name="content">
+ <data name="orderDateYearName" id="2622">
+ <property name="resultSetColumn">orderDateYearName</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEFD5</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="LevelView" name="NewLevel View1" id="2623">
+ <property name="level">Date/orderDateMonthOfYear</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2624">
+ <property name="content">
+ <data name="orderDateMonthOfYear" id="2625">
+ <property name="resultSetColumn">orderDateMonthOfYear</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#FFEFD5</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ <extended-item extensionName="LevelView" name="NewLevel View2" id="2626">
+ <property name="level">Date/orderDateMonthName</property>
+ <property name="member">
+ <extended-item extensionName="CrosstabCell" id="2627">
+ <property name="content">
+ <data name="orderDateMonthName" id="2628">
+ <property name="resultSetColumn">orderDateMonthName</property>
+ </data>
+ </property>
+ <property name="fontFamily">sans-serif</property>
+ <property name="backgroundColor">#ECE9D8</property>
+ <property name="textAlign">center</property>
+ </extended-item>
+ </property>
+ </extended-item>
+ </property>
+ </extended-item>
+ </property>
+ <property name="grandTotalLocation">after</property>
+ </extended-item>
+ </property>
+ <property name="header">
+ <extended-item extensionName="CrosstabCell" id="2587"/>
+ </property>
+ <property name="backgroundColor">#FFFFFF</property>
+ <property name="cube">BIC_DataCube</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">quantity</property>
+ <expression name="expression">measure["quantity"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">GS</property>
+ <expression name="expression">measure["GS"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">GMS</property>
+ <expression name="expression">measure["GMS"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">GMP</property>
+ <expression name="expression">measure["GMP"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">GSP</property>
+ <expression name="expression">measure["GSP"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">GP</property>
+ <expression name="expression">measure["GP"]</expression>
+ <property name="dataType">integer</property>
+ <property name="aggregateFunction">SUM</property>
+ </structure>
+ <structure>
+ <property name="name">orderDateYearName</property>
[... 513 lines stripped ...]