Example of a Business Panels Configuration File<?xml version="1.0" encoding="UTF-8"?> <configuration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ENOSHOStoreStudio_BusinessPanelsConfiguration.xsd"> <includes> <!-- Standart Merch3D formulas --> <include file="Merch3D_Formulas.js" type="formula"/> <!-- Specific js files --> <include file="groupSample.js" type="group"/> <include file="rendererSample.js" type="renderer"/> <include file="formulaSample.js" type="formula"/> </includes> <fields> <!-- Standard Store Data --> <field fieldid="ean" id="PRODUCT_ID"/> <field fieldid="tree" id="CDT" formulagroup="MOST" type="string"/> <field fieldid="element" id="ELT" formulagroup="MOST" type="string"/> <field fieldid="unitcount" id="UNIT_COUNT" formulagroup="SUM" type="float"/> <field fieldid="itemcount" id="ITEM_COUNT" formulagroup="SUM" type="float"/> <field fieldid="vcount" id="V_COUNT" formulagroup="SUM" type="float"/> <field fieldid="hcount" id="H_COUNT" formulagroup="SUM" type="float"/> <field fieldid="dcount" id="D_COUNT" formulagroup="SUM" type="float"/> <field fieldid="dmaxcount" id="D_MAX_COUNT" formulagroup="SUM" type="float"/> <field fieldid="targetedStock" id="TARGETEDSTOCK" formula="Merch3D_TargetedStock" formulagroup="SUM" type="float"/> <field fieldid="workingDaysCount" id="ASSORT_WORKING_DAYS_COUNT" formulagroup="MIN" type="float"/> <field fieldid="outerQuantityRatio" id="ASSORT_OUTER_QUANTITY_RATIO" formulagroup="MIN" type="float"/> <field fieldid="stockDaysMin" id="RULES_STOCKDAY_MIN" formulagroup="MIN" type="float"/> <field fieldid="stockDaysMax" id="RULES_STOCKDAY_MAX" formulagroup="MIN" type="float"/> <field fieldid="stock" id="stock" formulagroup="SUM" type="float"/> <field fieldid="stockWeight" formula="stockWeight" formulagroup="SUM" type="float"/> <!-- linearMeters is used by standard merch3D formulas : do not change the fieldId --> <field fieldid="linearMeters" id="linearMeters" formulagroup="SUM" type="float"/> <field fieldid="linearMetersWeight" formula="linearMetersWeight" formulagroup="SUM" type="float"/> <!-- Surfaces --> <field fieldid="vSurface" id="V_SURFACE" formulagroup="SUM" type="float"/> <field fieldid="hSurface" id="H_SURFACE" formulagroup="SUM" type="float"/> <!-- Product Data --> <field fieldid="title" id="TITLE" formulagroup="MOST" type="string"/> <field fieldid="price" select="attribute[RecommendedPublicPrice]" target="product" type="float" formulagroup="AVG"/> <field fieldid="pcb" select="attribute[PCB]" target="product" type="float"/> <field fieldid="supplier" select="attribute[ShopperSupplier]" target="product" formulagroup="MOST" type="string"/> <field fieldid="brand" select="attribute[SHOAtt_Brand]" target="product" formulagroup="MOST" type="string"/> <field fieldid="color" select="attribute[SHOAtt_Color]" target="product" formulagroup="MOST" type="string"/> <field fieldid="consumerunits" select="attribute[ShopperConsumerUnits]" formulagroup="SUM" target="representation" type="float"/> <field fieldid="state" select="current" target="product" formulagroup="MOST" type="string"/> <!-- JPO --> <field fieldid="subassortment" id="SHOProductSubAssortmentCustomAttribute" target="product"/> <!-- PositionCoefficients and product position --> <field fieldid="merch_Coefficient" formula="Merch3D_PositionCoefficient" localisedtitleid="BUS_COEFF_MERCH_FORMULA" formulagroup="MIN" type="float" refers="coefficient"/> <field fieldid="myCoefficientPosition" formula="MyCoefficientPositionFormula" localisedtitleid="BUS_POSITION_COEFF_MYFORMULA" type="float" formulagroup="MIN" refers="coefficient"/> <field fieldid="coefficient" id="POSITION_COEFFICIENT" formulagroup="MIN" type="float"/> <field fieldid="x" id="H_POSITION" formulagroup="MIN" type="float"/> <field fieldid="y" id="V_POSITION" formulagroup="MIN" type="float"/> <field fieldid="z" id="D_POSITION" formulagroup="MIN" type="float"/> <!-- Position of the parent support --> <field fieldid="ySupport" id="V_POSITION" formulagroup="MIN" target="support" type="float"/> <!-- Business Data --> <!-- average sales number is used by standard merch3D formulas : do not change the fieldId --> <field fieldid="average_sales_number" id="average_sales_number" formulagroup="SUM" type="float"/> <field fieldid="gross_margin_sale" id="gross_margin_sale" formulagroup="SUM" type="float"/> <field fieldid="sales_number" id="sales_number" formulagroup="SUM" type="float"/> <field fieldid="average_price_vat" id="average_price_vat" formulagroup="AVG" type="float"/> <field fieldid="average_price" id="average_price" formulagroup="AVG" type="float"/> <field fieldid="average_purchase_price_vat" id="average_purchase_price_vat" formulagroup="AVG" type="float"/> <field fieldid="average_purchase_price" id="average_purchase_price" formulagroup="AVG" type="float"/> <!-- business data Formulas : undefined without business data --> <field fieldid="daysOfStock" id="DAYSOFSTOCK" formula="Merch3D_DaysOfStock" formulagroup="SUM" type="float"/> <field fieldid="average_sales_by_Linear" formula="average_sales_by_Linear" localisedtitleid="BUS_AV_SALES_NUM_BY_LINEAR" formulagroup="SUM" type="float"/> <field fieldid="margin_by_Linear" formula="margin_by_Linear" localisedtitleid="BUS_MARGIN_BY_LINEAR" formulagroup="AVG" type="float"/> <!-- Others formulas --> <field fieldid="maximalcapacity" formula="maximalcapacity" formulagroup="SUM" type="float"/> <field fieldid="capacity" formula="capacity" formulagroup="SUM" type="float"/> <field fieldid="fillingratio" formula="fillingratio" formulagroup="AVG" type="float"/> </fields> <interface3d> <!-- Configuration of the available imports and their config. --> <imports> <import context="server" requestInterval="15" checked="true"> <attribute data="dateRange"/> <attribute data="storesGroups"/> <attribute data="subsEAN"/> </import> <import context="excelFile"/> </imports> <!-- Configuration of the attributes group list. --> <attributes> <field fieldid="supplier"/> <field fieldid="brand"/> <field fieldid="color"/> </attributes> <!-- Configuration of the indicators groups. --> <!-- Be careful that at least one group has to be defined --> <groups> <group groupid="group1" localisedtitleid="BUSINESS_GROUP_DATA" available="all" default="true"> <field fieldid="stock"/> <field fieldid="targetedStock"/> <field fieldid="linearMeters"/> <field fieldid="vSurface"/> <field fieldid="hSurface"/> <field fieldid="ySupport"/> <field fieldid="pcb"/> <field fieldid="itemcount"/> <field fieldid="vcount"/> <field fieldid="hcount"/> <field fieldid="dcount"/> <field fieldid="dmaxcount"/> <field fieldid="tree"/> </group> <group groupid="group2" localisedtitleid="BUSINESS_GROUP_ENOVIA" available="storestudio"> <field fieldid="title"/> <field fieldid="supplier"/> <field fieldid="brand"/> <field fieldid="color"/> <field fieldid="price"/> <field fieldid="pcb"/> <field fieldid="consumerunits"/> <field fieldid="state"/> </group> <group groupid="group3" localisedtitleid="BUSINESS_GROUP_STOCK" available="all"> <field fieldid="stock"/> <field fieldid="targetedStock"/> <field fieldid="daysOfStock"/> <field fieldid="capacity"/> <field fieldid="maximalcapacity"/> <field fieldid="fillingratio"/> <field fieldid="pcb"/> </group> <group groupid="group4" localisedtitleid="BUSINESS_GROUP_SALES" available="all"> <field fieldid="average_sales_number"/> <field fieldid="average_sales_by_Linear"/> <field fieldid="gross_margin_sale"/> <field fieldid="margin_by_Linear"/> </group> <group groupid="group5" localisedtitleid="BUSINESS_GROUP_PRICES" available="storestudio"> <field fieldid="price"/> <field fieldid="average_price_vat"/> <field fieldid="average_price"/> <field fieldid="average_purchase_price_vat"/> <field fieldid="average_purchase_price"/> </group> <group groupid="group6" localisedtitleid="BUSINESS_GROUP_PRICES" available="3dplay"> <field fieldid="price"/> <field fieldid="average_price"/> <field fieldid="average_purchase_price"/> </group> </groups> </interface3d> <reporting> <views> <grid viewid="view1" localisedtitleid="REPORTING_ELT_VIEW"> <tree> <field fieldid="element"/> </tree> <field fieldid="title"/> <field fieldid="brand"/> <field fieldid="stock"/> <field fieldid="targetedStock"/> <field fieldid="linearMeters"/> <field fieldid="coefficient"/> </grid> <grid viewid="view2" localisedtitleid="REPORTING_CDT_VIEW"> <tree> <field fieldid="tree"/> </tree> <field fieldid="title"/> <field fieldid="linearMeters"/> <field fieldid="linearMetersWeight" renderer="weightRenderer"/> <field fieldid="stock"/> <field fieldid="stockWeight" renderer="weightRenderer"/> </grid> <grid viewid="view3" localisedtitleid="REPORTING_SUPPLIER_VIEW"> <tree> <field fieldid="supplier"/> </tree> <field fieldid="title"/> <field fieldid="subassortment"/> <field fieldid="itemcount"/> <field fieldid="hcount"/> <field fieldid="vcount"/> <field fieldid="dcount"/> <field fieldid="dmaxcount"/> </grid> <bar viewid="bar1" localisedtitleid="REPORTING_ELT_BAR"> <field fieldid="element"/> <field fieldid="unitcount"/> <field fieldid="maximalcapacity"/> <field fieldid="stock"/> </bar> <pie viewid="pie1" localisedtitleid="REPORTING_SUPPLIER_PIE"> <field fieldid="supplier"/> <field fieldid="linearMeters"/> </pie> </views> <exports> <excel exportid="export1" localisedtitleid="REPORTING_EXPORT_SAMPLE"> <field fieldid="ean"/> <field fieldid="tree" maxlevel="3"/> <field fieldid="title"/> <field fieldid="price"/> <field fieldid="pcb"/> <field fieldid="supplier"/> <field fieldid="brand"/> <field fieldid="consumerunits"/> <field fieldid="subassortment"/> <field fieldid="element"/> <field fieldid="unitcount"/> <field fieldid="itemcount"/> <field fieldid="hcount"/> <field fieldid="vcount"/> <field fieldid="dcount"/> <field fieldid="dmaxcount"/> <field fieldid="linearMeters"/> <field fieldid="linearMetersWeight"/> <field fieldid="stock"/> <field fieldid="stockWeight"/> <field fieldid="maximalcapacity"/> </excel> <excel exportid="export2" localisedtitleid="REPORTING_EXPORT_SAMPLE_WITH_TEMP" templatefile="sampleExportTemplate.xls"> <field fieldid="ean"/> <field fieldid="tree" maxlevel="3"/> <field fieldid="title"/> <field fieldid="price"/> <field fieldid="pcb"/> <field fieldid="supplier"/> <field fieldid="brand"/> <field fieldid="consumerunits"/> <field fieldid="subassortment"/> <field fieldid="element"/> <field fieldid="unitcount"/> <field fieldid="itemcount"/> <field fieldid="hcount"/> <field fieldid="vcount"/> <field fieldid="dcount"/> <field fieldid="dmaxcount"/> <field fieldid="linearMeters"/> <field fieldid="linearMetersWeight"/> <field fieldid="stock"/> <field fieldid="stockWeight"/> <field fieldid="maximalcapacity"/> </excel> </exports> </reporting> </configuration> |