svn commit: r1055774 [3/5] - in /ofbiz/trunk: applications/accounting/data/ applications/order/ applications/order/entitydef/ applications/order/script/org/
Locked
svn commit: r1055774 [3/5] - in /ofbiz/trunk: applications/accounting/data/ applications/order/ applications/order/entitydef/ applications/order/script/org/
 
|
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 ...] |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |