objectlist classname(kKPIContainer) keys(code)
  object props("lastbuild(\"2021-05-10T18:01:13.557\") code(\"POSibleKPI\") description(\"POSibleKPI\") ")
    objectlist propertyname(keys) keys(Code)
      object props("name(\"Store\") code(\"POSibleKPI-Store\") description(\"Store\") type(\"kStore\") ")
      endobject
      object props("name(\"Operator\") code(\"POSibleKPI-Operator\") description(\"SaleOperator\") type(\"kStoreOperator\") ")
      endobject
      object props("name(\"Date\") code(\"POSibleKPI-Date\") description(\"tkDate\") type(\"tkDate\") ")
      endobject
      object props("name(\"Hour\") code(\"POSibleKPI-Hour\") description(\"tkHour\") type(\"tkHour\") ")
      endobject
    endobjectlist
    objectlist propertyname(rules) keys(Code)
      object props("name(\"ReceiptNormalized\") calculated(\"0\") code(\"POSibleKPI-ReceiptNormalized\") sourceclass(\"kReceipt_Lines\") filter(\"field(product) in(cluster value(NORMALIZED) class(kProduct) key(code))\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"parentid.CashOperator\") code(\"POSibleKPI-ReceiptNormalized-POSibleKPI-Operator\") description(\"CashOperator\") containerkey(\"POSibleKPI-Operator\") ")
          endobject
          object props("reference(\"parentid.Store\") code(\"POSibleKPI-ReceiptNormalized-POSibleKPI-Store\") description(\"Store\") containerkey(\"POSibleKPI-Store\") ")
          endobject
          object props("reference(\"to('date',parentid.datetime)\") code(\"POSibleKPI-ReceiptNormalized-POSibleKPI-Date\") description(\"Date\") containerkey(\"POSibleKPI-Date\") ")
          endobject
          object props("reference(\"dbo.kfn_datepart('hh',parentid.datetime)\") code(\"POSibleKPI-ReceiptNormalized-POSibleKPI-Hour\") description(\"Hour\") containerkey(\"POSibleKPI-Hour\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"SalesAmountNormalized\") autogroup(\"0\") code(\"POSibleKPI-SalesAmountNormalized\") description(\"Importo Vendite Normalizzata\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Amount.Value)\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"SalesQuantityNormalized\") autogroup(\"0\") code(\"POSibleKPI-SalesQuantityNormalized\") description(\"Prodotti Normalizzati Venduti\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Quantity.Value)\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"Receipt\") calculated(\"0\") code(\"POSibleKPI-Receipt\") sourceclass(\"kReceipt_Lines\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"parentid.CashOperator\") code(\"POSibleKPI-Receipt-POSibleKPI-Operator\") description(\"CashOperator\") containerkey(\"POSibleKPI-Operator\") ")
          endobject
          object props("reference(\"parentid.Store\") code(\"POSibleKPI-Receipt-POSibleKPI-Store\") description(\"Store\") containerkey(\"POSibleKPI-Store\") ")
          endobject
          object props("reference(\"to('date',parentid.datetime)\") code(\"POSibleKPI-Receipt-POSibleKPI-Date\") description(\"Date\") containerkey(\"POSibleKPI-Date\") ")
          endobject
          object props("reference(\"dbo.kfn_datepart('hh',parentid.datetime)\") code(\"POSibleKPI-Receipt-POSibleKPI-Hour\") description(\"Hour\") containerkey(\"POSibleKPI-Hour\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"SalesAmount\") autogroup(\"0\") code(\"POSibleKPI-SalesAmount\") description(\"Importo Vendite\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Amount.Value)\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"SalesQuantity\") autogroup(\"0\") code(\"POSibleKPI-SalesQuantity\") description(\"Prodotti Venduti\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Quantity.Value)\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"SalesAmountNoVAT\") autogroup(\"0\") code(\"POSibleKPI-SalesAmountNoVAT\") description(\"Importo Netto\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),case(eq(parentid.VatInclusivePrices,0),Amount.Value,div(Amount.Value,add(1,div(VatCode.VATPercentage,100))))\") ")
          endobject
          object props("customtype(\"tkInteger\") name(\"ReceiptCount\") autogroup(\"0\") code(\"POSibleKPI-ReceiptCount\") description(\"Numero Scontrini\") groupingfunction(\"5\") enabled(\"1\") reference(\"case(eq(parentid.receipttype,1),ParentId,'*null*')\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"ReceiptPriceModifiers\") calculated(\"0\") code(\"POSibleKPI-ReceiptPriceModifiers\") description(\"Price Modifiers\") sourceclass(\"kReceipt_PriceModifiers\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"parentid.CashOperator\") code(\"POSibleKPI-ReceiptPriceModifiers-POSibleKPI-Operator\") description(\"CashOperator\") containerkey(\"POSibleKPI-Operator\") ")
          endobject
          object props("reference(\"parentid.Store\") code(\"POSibleKPI-ReceiptPriceModifiers-POSibleKPI-Store\") description(\"Store\") containerkey(\"POSibleKPI-Store\") ")
          endobject
          object props("reference(\"to('date',parentid.datetime)\") code(\"POSibleKPI-ReceiptPriceModifiers-POSibleKPI-Date\") description(\"Date\") containerkey(\"POSibleKPI-Date\") ")
          endobject
          object props("reference(\"dbo.kfn_datepart('hh',parentid.datetime)\") code(\"POSibleKPI-ReceiptPriceModifiers-POSibleKPI-Hour\") description(\"Hour\") containerkey(\"POSibleKPI-Hour\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"PriceModifiersAmount\") autogroup(\"0\") code(\"POSibleKPI-PriceModifiersAmount\") description(\"Importo Sconti\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Amount.Value)\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"ReceiptFidelity\") calculated(\"0\") code(\"POSibleKPI-ReceiptFidelity\") sourceclass(\"kReceipt_Lines\") filter(\"field(parentid.loyaltycustomer) nn('')\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"parentid.CashOperator\") code(\"POSibleKPI-ReceiptFidelity-POSibleKPI-Operator\") description(\"CashOperator\") containerkey(\"POSibleKPI-Operator\") ")
          endobject
          object props("reference(\"parentid.Store\") code(\"POSibleKPI-ReceiptFidelity-POSibleKPI-Store\") description(\"Store\") containerkey(\"POSibleKPI-Store\") ")
          endobject
          object props("reference(\"to('date',parentid.datetime)\") code(\"POSibleKPI-ReceiptFidelity-POSibleKPI-Date\") description(\"Date\") containerkey(\"POSibleKPI-Date\") ")
          endobject
          object props("reference(\"dbo.kfn_datepart('hh',parentid.datetime)\") code(\"POSibleKPI-ReceiptFidelity-POSibleKPI-Hour\") description(\"Hour\") containerkey(\"POSibleKPI-Hour\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"FidelitySalesAmount\") autogroup(\"0\") code(\"POSibleKPI-FidelitySalesAmount\") description(\"Importo Vendite a Clienti Fidelizzati\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Amount.Value)\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"FidelitySalesQauntity\") autogroup(\"0\") code(\"POSibleKPI-FidelitySalesQauntity\") description(\"Prodotti Venduti a Clienti Fidelizzati\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),Quantity.Value)\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"FidelitySalesAmountNoVAT\") autogroup(\"0\") code(\"POSibleKPI-FidelitySalesAmountNoVAT\") description(\"Importo Netto a Clienti Fidelizzati\") groupingfunction(\"1\") enabled(\"1\") reference(\"mult(case(eq(parentid.receipttype,1),1,-1),case(eq(parentid.VatInclusivePrices,0),Amount.Value,div(Amount.Value,add(1,div(VatCode.VATPercentage,100))))\") ")
          endobject
          object props("customtype(\"tkInteger\") name(\"AvgFidelityCustomer\") autogroup(\"0\") code(\"POSibleKPI-AvgFidelityCustomer\") description(\"Numero Clienti Fidelizzati\") groupingfunction(\"5\") enabled(\"1\") reference(\"case(eq(parentid.receipttype,1),parentid.loyaltycustomer,'*null*')\") ")
          endobject
          object props("customtype(\"tkInteger\") name(\"FidelityReceiptCount\") autogroup(\"0\") code(\"POSibleKPI-FidelityReceiptCount\") description(\"Numero Scontrini a Clienti Fidelizzati\") groupingfunction(\"5\") enabled(\"1\") reference(\"case(eq(parentid.receipttype,1),parentid,'*null*')\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"FidelityIncidence\") calculated(\"1\") code(\"POSibleKPI-FidelityIncidence\") sourceclass(\"kDataQuality_LoyaltyCustomer\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"FidelityReceiptIncidence\") code(\"POSibleKPI-FidelityReceiptIncidence\") description(\"Incidenza Scontrini Clienti Fidelizzati\") enabled(\"1\") reference(\"case(eq(sum(ReceiptCount),0),0,mult(100,div(to('float',sum(FidelityReceiptCount)),sum(ReceiptCount))))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"ReceiptAmountAvg\") calculated(\"1\") code(\"POSibleKPI-ReceiptAmountAvg\") description(\"ReceiptAmountAvg\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"AvgReceiptAmountNormalized\") code(\"POSibleKPI-AvgReceiptAmountNormalized\") description(\"Vendita Media Normalizzata\") enabled(\"1\") reference(\"case(eq(sum(ReceiptCount),0),0,div(sum(SalesAmountNormalized),sum(ReceiptCount)))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"UPT\") calculated(\"1\") code(\"POSibleKPI-UPT\") description(\"UPT\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"UPT\") code(\"POSibleKPI-UPT\") description(\"UPT\") enabled(\"1\") reference(\"case(eq(sum(ReceiptCount),0),0,div(sum(SalesQuantity),sum(ReceiptCount)))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"UPTNormalized\") calculated(\"1\") code(\"POSibleKPI-UPTNormalized\") description(\"UPTNormalized\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"NormalizedUPT\") code(\"POSibleKPI-NormalizedUPT\") description(\"UPT Normalizzata\") enabled(\"1\") reference(\"case(eq(sum(ReceiptCount),0),0,div(sum(SalesQuantityNormalized),sum(ReceiptCount)))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"ArticoloMedio\") calculated(\"1\") code(\"POSibleKPI-ArticoloMedio\") description(\"ArticoloMedio\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"AvgProductPrice\") code(\"POSibleKPI-AvgProductPrice\") description(\"Importo Medio Articolo\") enabled(\"1\") reference(\"case(eq(sum(SalesQuantity),0),0,div(sum(SalesAmount),sum(SalesQuantity)))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"Budget\") calculated(\"0\") code(\"POSibleKPI-Budget\") sourceclass(\"kPOSBudget_Lines\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"Parentid.Store\") code(\"POSibleKPI-Budget-POSibleKPI-Store\") description(\"Store\") containerkey(\"POSibleKPI-Store\") ")
          endobject
          object props("reference(\"Date\") code(\"POSibleKPI-Budget-POSibleKPI-Date\") description(\"Date\") containerkey(\"POSibleKPI-Date\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"BudgetQty\") autogroup(\"0\") code(\"POSibleKPI-BudgetQty\") description(\"BudgetQuantity\") groupingfunction(\"1\") enabled(\"1\") reference(\"Quantity.Value\") ")
          endobject
          object props("customtype(\"tkValue\") name(\"BudgetAmount\") autogroup(\"0\") code(\"POSibleKPI-BudgetAmount\") description(\"BudgetAmount\") groupingfunction(\"1\") enabled(\"1\") reference(\"Amount.Value\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"ConversionRate\") calculated(\"1\") code(\"POSibleKPI-ConversionRate\") description(\"ConversionRate\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"0\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkCurrency\") name(\"ConversionRate\") autogroup(\"1\") code(\"POSibleKPI-ConversionRate\") description(\"Numero Scontrini\\\\Ingressi\") enabled(\"1\") reference(\"case(eq(sum(incomingPeopleCount),0),0.0,mult(100.0,Div(sum(to('float',ReceiptCount)),sum(IncomingPeopleCount))))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"VenditaMediaNormalized\") calculated(\"1\") code(\"POSibleKPI-VenditaMediaNormalized\") description(\"VenditaMediaNormalized\") sourceclass(\"kDataQuality_AddressInfo\") enabled(\"1\") ")
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkValue\") name(\"ReceiptAmountAvgOldToRemove\") autogroup(\"1\") code(\"POSibleKPI-ReceiptAmountAvgOldToRemove\") description(\"ReceiptAmountAvg(Old) to be replaced\") enabled(\"1\") reference(\"case(eq(sum(ReceiptCount),0),0,div(sum(SalesAmountNormalized),sum(ReceiptCount)))\") ")
          endobject
        endobjectlist
      endobject
      object props("name(\"LoyaltyCustomers\") calculated(\"0\") code(\"POSibleKPI-LoyaltyCustomers\") sourceclass(\"kLoyaltyCustomer\") enabled(\"1\") ")
        objectlist propertyname(keys) keys(Code)
          object props("reference(\"To('date',EnrollmentDateTime)\") code(\"POSibleKPI-LoyaltyCustomers-POSibleKPI-Date\") description(\"Data Iscrizione\") containerkey(\"POSibleKPI-Date\") ")
          endobject
          object props("reference(\"dbo.kfn_datepart('hh',EnrollmentDateTime)\") code(\"POSibleKPI-LoyaltyCustomers-POSibleKPI-Hour\") description(\"Ora iscrizione\") containerkey(\"POSibleKPI-Hour\") ")
          endobject
          object props("reference(\"IssuedByStore\") code(\"POSibleKPI-LoyaltyCustomers-POSibleKPI-Store\") description(\"Negozio Emissione Tessera\") containerkey(\"POSibleKPI-Store\") ")
          endobject
        endobjectlist
        objectlist propertyname(values) keys(Code)
          object props("customtype(\"tkInteger\") name(\"NewFidelityCustomer\") autogroup(\"0\") code(\"POSibleKPI-NewFidelityCustomer\") description(\"Nuovi Clienti Fidelizzati\") groupingfunction(\"4\") enabled(\"1\") reference(\"id\") ")
          endobject
        endobjectlist
      endobject
    endobjectlist
  endobject
endobjectlist
