Return-Path: <user-return-1660-archive-asf-public=cust-asf.ponee.io@kylin.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 14664200C1B
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Tue, 14 Feb 2017 15:36:32 +0100 (CET)
Received: by cust-asf.ponee.io (Postfix)
	id 0E7AB160B5F; Tue, 14 Feb 2017 14:36:32 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 69F2D160B52
	for <archive-asf-public@cust-asf.ponee.io>; Tue, 14 Feb 2017 15:36:30 +0100 (CET)
Received: (qmail 51267 invoked by uid 500); 14 Feb 2017 14:36:29 -0000
Mailing-List: contact user-help@kylin.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@kylin.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@kylin.apache.org>
List-Post: <mailto:user@kylin.apache.org>
List-Id: <user.kylin.apache.org>
Reply-To: user@kylin.apache.org
Delivered-To: mailing list user@kylin.apache.org
Received: (qmail 51251 invoked by uid 99); 14 Feb 2017 14:36:29 -0000
Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2017 14:36:29 +0000
Received: from mail-ot0-f180.google.com (mail-ot0-f180.google.com [74.125.82.180])
	by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 38D8F1A00A2
	for <user@kylin.apache.org>; Tue, 14 Feb 2017 14:36:29 +0000 (UTC)
Received: by mail-ot0-f180.google.com with SMTP id 65so94196893otq.2
        for <user@kylin.apache.org>; Tue, 14 Feb 2017 06:36:29 -0800 (PST)
X-Gm-Message-State: AMke39nLG2f1MGu6UBg/v3mQbz/z4CNMUfH+WUq8P6MPJITwmeHXxeYhAUNz/RqRRXCM/UFpAbxjMOQJMVAZUQ==
X-Received: by 10.157.15.103 with SMTP id 94mr15921599ott.104.1487082987860;
 Tue, 14 Feb 2017 06:36:27 -0800 (PST)
MIME-Version: 1.0
Received: by 10.74.153.125 with HTTP; Tue, 14 Feb 2017 06:35:47 -0800 (PST)
In-Reply-To: <62AF2D9BCDE35E4DBC186721298D0F7B014F7E6A@MBX28.360buyAD.local>
References: <62AF2D9BCDE35E4DBC186721298D0F7B014F7E6A@MBX28.360buyAD.local>
From: ShaoFeng Shi <shaofengshi@apache.org>
Date: Tue, 14 Feb 2017 22:35:47 +0800
X-Gmail-Original-Message-ID: <CANfpUcuX_092K+p0-C_xTOKjpEnG6sLY-ZmZ3SR4WNnkw6tyQw@mail.gmail.com>
Message-ID: <CANfpUcuX_092K+p0-C_xTOKjpEnG6sLY-ZmZ3SR4WNnkw6tyQw@mail.gmail.com>
Subject: =?UTF-8?B?UmU6IOWFs+S6jmt5bGlu5p+l6K+i6Zeu6aKY5ZKo6K+i?=
To: user <user@kylin.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c0368523e408105487e7de6
archived-at: Tue, 14 Feb 2017 14:36:32 -0000

--94eb2c0368523e408105487e7de6
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Kaisen made several performance improvement on the bitmap measure; You can
check http://mt.sohu.com/20170113/n478613681.shtml if haven't.

BTW, these improvements will be included in the 2.0 release;

2017-02-14 11:05 GMT+08:00 =E4=BB=87=E5=90=8C=E5=BF=83 <qiutongxin@jd.com>:

> =E5=A4=A7=E5=AE=B6=E5=A5=BD=EF=BC=9A
>
> =E7=9B=AE=E5=89=8D=E5=9C=A8=E4=BD=BF=E7=94=A8=E4=B8=AD=E9=81=87=E5=88=B0=
=E4=B8=80=E4=B8=AAkylin=E6=9F=A5=E8=AF=A2=E6=85=A2=E7=9A=84=E5=9C=BA=E6=99=
=AF:
>
> Cube  =E8=AE=BE=E8=AE=A1=E5=A6=82=E4=B8=8B=EF=BC=9A
>
> {
>
>   "uuid": "dfb77a08-f51d-4088-b559-1da67c28a068",
>
>   "last_modified": 1486997875953,
>
>   "version": "1.6.0",
>
>   "name": "insu_t",
>
>   "model_name": "insu_jdmall_model_test",
>
>   "description": "",
>
>   "null_string": null,
>
>   "dimensions": [
>
>     {
>
>       "name": "BRAND",
>
>       "table": "DMT.DMT_KYLIN_JDMALL_ORDR_DTL_I_D",
>
>       "column": "BRAND_CD",
>
>       "derived": null
>
>     },
>
>     {
>
>       "name": "DT",
>
>       "table": "DMT.DMT_KYLIN_JDMALL_ORDR_DTL_I_D",
>
>       "column": "DT",
>
>       "derived": null
>
>     },
>
>     {
>
>       "name": "DIM.DIM_DAY_DERIVED",
>
>       "table": "DIM.DIM_DAY",
>
>       "column": null,
>
>       "derived": [
>
>         "DIM_DAY_NAME",
>
>         "DIM_WEEK_NAME",
>
>         "DIM_MONTH_NAME"
>
>       ]
>
>     },
>
>     {
>
>       "name": "FIRST",
>
>      "table": "DIM.DIM_ITEM_GEN_THIRD_CATE_D",
>
>       "column": "ITEM_FIRST_CATE_NAME",
>
>       "derived": null
>
>     },
>
>     {
>
>       "name": "SECOND",
>
>       "table": "DIM.DIM_ITEM_GEN_THIRD_CATE_D",
>
>       "column": "ITEM_SECOND_CATE_NAME",
>
>       "derived": null
>
>     },
>
>     {
>
>       "name": "THIRD",
>
>       "table": "DIM.DIM_ITEM_GEN_THIRD_CATE_D",
>
>       "column": "ITEM_THIRD_CATE_NAME",
>
>       "derived": null
>
>     }
>
>   ],
>
>   "measures": [
>
>     {
>
>       "name": "_COUNT_",
>
>       "function": {
>
>         "expression": "COUNT",
>
>         "parameter": {
>
>           "type": "constant",
>
>           "value": "1",
>
>           "next_parameter": null
>
>         },
>
>         "returntype": "bigint"
>
>       },
>
>       "dependent_measure_ref": null
>
>     },
>
>     {
>
>       "name": "QTTY",
>
>       "function": {
>
>         "expression": "SUM",
>
>         "parameter": {
>
>           "type": "column",
>
>           "value": "SALE_QTTY",
>
>           "next_parameter": null
>
>         },
>
>         "returntype": "bigint"
>
>       },
>
>       "dependent_measure_ref": null
>
>     },
>
>     {
>
>       "name": "BEFORE",
>
>       "function": {
>
>         "expression": "SUM",
>
>         "parameter": {
>
>           "type": "column",
>
>           "value": "BEFORE_PREFR_AMOUNT",
>
>           "next_parameter": null
>
>         },
>
>         "returntype": "decimal(25,4)"
>
>       },
>
>       "dependent_measure_ref": null
>
>     },
>
>     {
>
>       "name": "USER",
>
>       "function": {
>
>         "expression": "SUM",
>
>         "parameter": {
>
>           "type": "column",
>
>           "value": "USER_ACTUAL_PAY_AMOUNT",
>
>           "next_parameter": null
>
>         },
>
>        "returntype": "decimal(25,4)"
>
>       },
>
>       "dependent_measure_ref": null
>
>     },
>
>     {
>
>       "name": "SALE",
>
>       "function": {
>
>         "expression": "COUNT_DISTINCT",
>
>         "parameter": {
>
>           "type": "column",
>
>           "value": "SALE_ORD_ID",
>
>           "next_parameter": null
>
>         },
>
>         "returntype": "bitmap"
>
>       },
>
>       "dependent_measure_ref": null
>
>     }
>
>   ],
>
>   "dictionaries": [],
>
>   "rowkey": {
>
>     "rowkey_columns": [
>
>       {
>
>         "column": "BRAND_CD",
>
>         "encoding": "dict",
>
>         "isShardBy": false
>
>       },
>
>       {
>
>         "column": "DT",
>
>         "encoding": "dict",
>
>         "isShardBy": false
>
>       },
>
>       {
>
>         "column": "ITEM_FIRST_CATE_NAME",
>
>         "encoding": "dict",
>
>         "isShardBy": false
>
>       },
>
>       {
>
>         "column": "ITEM_SECOND_CATE_NAME",
>
>         "encoding": "dict",
>
>         "isShardBy": false
>
>       },
>
>       {
>
>         "column": "ITEM_THIRD_CATE_NAME",
>
>         "encoding": "dict",
>
>         "isShardBy": false
>
>       }
>
>     ]
>
>   },
>
>   "hbase_mapping": {
>
>     "column_family": [
>
>       {
>
>         "name": "F1",
>
>         "columns": [
>
>           {
>
>             "qualifier": "M",
>
>             "measure_refs": [
>
>               "_COUNT_",
>
>               "QTTY",
>
>               "BEFORE",
>
>               "USER"
>
>             ]
>
>           }
>
>         ]
>
>       },
>
>       {
>
>         "name": "F2",
>
>         "columns": [
>
>           {
>
>             "qualifier": "M",
>
>             "measure_refs": [
>
>               "SALE"
>
>             ]
>
>           }
>
>         ]
>
>       }
>
>     ]
>
>   },
>
>   "aggregation_groups": [
>
>     {
>
>       "includes": [
>
>         "BRAND_CD",
>
>         "DT",
>
>         "ITEM_FIRST_CATE_NAME",
>
>         "ITEM_SECOND_CATE_NAME",
>
>         "ITEM_THIRD_CATE_NAME"
>
>       ],
>
>       "select_rule": {
>
>         "hierarchy_dims": [],
>
>         "mandatory_dims": [],
>
>         "joint_dims": []
>
>       }
>
>     }
>
>   ],
>
>   "signature": "Kl5sPTVN78bEYTGKoUOsWg=3D=3D",
>
>   "notify_list": [],
>
>   "status_need_notify": [
>
>     "ERROR",
>
>     "DISCARDED",
>
>     "SUCCEED"
>
>   ],
>
>   "partition_date_start": 1483747200000,
>
>   "partition_date_end": 3153600000000,
>
>   "auto_merge_time_ranges": [
>
>     604800000,
>
>     2419200000
>
>   ],
>
>   "retention_range": 0,
>
>   "engine_type": 2,
>
>   "storage_type": 2,
>
>   "override_kylin_properties": {
>
>     "kylin.hbase.region.cut": "1"
>
>   }
>
> }
>
>
>
> =E6=95=B0=E6=8D=AE=E9=87=8F=E6=98=AF14=E5=A4=A9=E7=9A=84=E6=95=B0=E6=8D=
=AE=EF=BC=8Csale_ord_id=E7=9A=84=E5=9F=BA=E6=95=B0=E6=98=AF1.5=E4=BA=BF
>
> Select dt,item_second_cate_name,count(distinct sale_ord_id),sum(sale_qtty=
)
>
> from DMT.DMT_KYLIN_JDMALL_ORDR_DTL_I_D a
>
> left join dim.dim_day b on a.dt =3D b.dim_day_txdate
>
> left join DIM.DIM_ITEM_GEN_THIRD_CATE_D c on a.item_third_cate_cd =3D
> c.item_third_cate_id
>
> group by dt,item_second_cate_name;
>
>
>
> =E8=BF=99=E6=9D=A1=E8=AF=AD=E5=8F=A5=E6=89=A7=E8=A1=8C=E6=97=B6=E9=97=B4=
=E6=98=AF37=E7=A7=92,=E5=8E=BB=E6=8E=89count(distinct sale_ord_id)=E5=90=8E=
=E6=9F=A5=E8=AF=A2=E6=97=B60.07=E7=A7=92
>
> dt,item_second_cate_name =E9=83=BD=E6=98=AFnormal=E7=BB=B4=E5=BA=A6=EF=BC=
=8C=E4=BB=8E=E7=BB=93=E6=9E=9C=E7=9C=8B=E6=98=AFcount_distinct
> =E5=BA=A6=E9=87=8F=E5=AF=BC=E8=87=B4=E7=9A=84=E6=85=A2=E6=9F=A5=E8=AF=A2=
=EF=BC=8C=E8=AF=B7=E9=97=AE=E8=BF=99=E4=B8=AA=E6=9C=89=E4=BB=80=E4=B9=88=E4=
=BC=98=E5=8C=96=E7=9A=84=E5=BB=BA=E8=AE=AE=E5=90=97=EF=BC=9F
>
>
>
> =E8=B0=A2=E8=B0=A2=EF=BC=81
>
>
>
>
>
>
>



--=20
Best regards,

Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B

--94eb2c0368523e408105487e7de6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Kaisen made several performance improvement on the bitmap =
measure; You can check=C2=A0<a href=3D"http://mt.sohu.com/20170113/n4786136=
81.shtml">http://mt.sohu.com/20170113/n478613681.shtml</a> if haven&#39;t.<=
div><br></div><div>BTW, these improvements will be included in the 2.0 rele=
ase;</div></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">2=
017-02-14 11:05 GMT+08:00 =E4=BB=87=E5=90=8C=E5=BF=83 <span dir=3D"ltr">&lt=
;<a href=3D"mailto:qiutongxin@jd.com" target=3D"_blank">qiutongxin@jd.com</=
a>&gt;</span>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang=3D"ZH-CN" link=3D"blue" vlink=3D"purple">
<div class=3D"m_1825867879813298375WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-family:=E5=AE=8B=E4=BD=93">=E5=
=A4=A7=E5=AE=B6=E5=A5=BD=EF=BC=9A</span><span lang=3D"EN-US"><u></u><u></u>=
</span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21.0pt"><span style=3D"font-fam=
ily:=E5=AE=8B=E4=BD=93">=E7=9B=AE=E5=89=8D=E5=9C=A8=E4=BD=BF=E7=94=A8=E4=B8=
=AD=E9=81=87=E5=88=B0=E4=B8=80=E4=B8=AA</span><span lang=3D"EN-US">kylin</s=
pan><span style=3D"font-family:=E5=AE=8B=E4=BD=93">=E6=9F=A5=E8=AF=A2=E6=85=
=A2=E7=9A=84=E5=9C=BA=E6=99=AF</span><span lang=3D"EN-US">:<u></u><u></u></=
span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21.0pt"><span lang=3D"EN-US">Cu=
be =C2=A0</span><span style=3D"font-family:=E5=AE=8B=E4=BD=93">=E8=AE=BE=E8=
=AE=A1=E5=A6=82=E4=B8=8B=EF=BC=9A</span><span lang=3D"EN-US"><u></u><u></u>=
</span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">{<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;uuid&quot;: &quot;dfb77a08-f51d-4088-b559-<wbr>1da67c2=
8a068&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;last_modified&quot;: 1486997875953,<u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;version&quot;: &quot;1.6.0&quot;,<u></u><u></u></span>=
</p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;name&quot;: &quot;insu_t&quot;,<u></u><u></u></span></=
p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;model_name&quot;: &quot;insu_jdmall_model_test&quot;,<=
u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;description&quot;: &quot;&quot;,<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;null_string&quot;: null,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;dimensions&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;BRAND&quot;,=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;table&quot;: &quot;DMT.DMT_KYL=
IN_JDMALL_ORDR_<wbr>DTL_I_D&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quot;BRAND_CD&q=
uot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: null<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;DT&quot;,<u>=
</u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;table&quot;: &quot;DMT.DMT_KYL=
IN_JDMALL_ORDR_<wbr>DTL_I_D&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quot;DT&quot;,<=
u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: null<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;DIM.DIM_DAY_=
DERIVED&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;table&quot;: &quot;DIM.DIM_DAY=
&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: null,<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: [<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;DIM_DAY_NAME&quot;=
,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;DIM_WEEK_NAME&quot=
;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;DIM_MONTH_NAME&quo=
t;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;FIRST&quot;,=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0&quot;table&quot;: &quot;DIM.DIM_ITEM=
_GEN_THIRD_CATE_<wbr>D&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quot;ITEM_FIRST=
_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: null<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;SECOND&quot;=
,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;table&quot;: &quot;DIM.DIM_ITE=
M_GEN_THIRD_CATE_<wbr>D&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quot;ITEM_SECON=
D_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: null<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;THIRD&quot;,=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;table&quot;: &quot;DIM.DIM_ITE=
M_GEN_THIRD_CATE_<wbr>D&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quot;ITEM_THIRD=
_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;derived&quot;: null<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;measures&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;_COUNT_&quot=
;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;function&quot;: {<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;expression&quot;: =
&quot;COUNT&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;parameter&quot;: {=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;type&q=
uot;: &quot;constant&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;value&=
quot;: &quot;1&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;next_p=
arameter&quot;: null<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;returntype&quot;: =
&quot;bigint&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;dependent_measure_ref&quot;: n=
ull<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;QTTY&quot;,<=
u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;function&quot;: {<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0&quot;expression&quot;: =
&quot;SUM&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;parameter&quot;: {=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;type&q=
uot;: &quot;column&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;value&=
quot;: &quot;SALE_QTTY&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;next_p=
arameter&quot;: null<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;returntype&quot;: =
&quot;bigint&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;dependent_measure_ref&quot;: n=
ull<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;BEFORE&quot;=
,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;function&quot;: {<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;expression&quot;: =
&quot;SUM&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;parameter&quot;: {=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;type&q=
uot;: &quot;column&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;value&=
quot;: &quot;BEFORE_PREFR_AMOUNT&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;next_p=
arameter&quot;: null<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;returntype&quot;: =
&quot;decimal(25,4)&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0&quot;dependent_measure_ref&quot;: n=
ull<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;USER&quot;,<=
u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;function&quot;: {<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;expression&quot;: =
&quot;SUM&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;parameter&quot;: {=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;type&q=
uot;: &quot;column&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;value&=
quot;: &quot;USER_ACTUAL_PAY_AMOUNT&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;next_p=
arameter&quot;: null<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0&quot;returntype&quot;: &=
quot;decimal(25,4)&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;dependent_measure_ref&quot;: n=
ull<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;SALE&quot;,<=
u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;function&quot;: {<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;expression&quot;: =
&quot;COUNT_DISTINCT&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;parameter&quot;: {=
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;type&q=
uot;: &quot;column&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;value&=
quot;: &quot;SALE_ORD_ID&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;next_p=
arameter&quot;: null<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span><=
/p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;returntype&quot;: =
&quot;bitmap&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;dependent_measure_ref&quot;: n=
ull<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;dictionaries&quot;: [],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;rowkey&quot;: {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;rowkey_columns&quot;: [<u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quo=
t;BRAND_CD&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0&quot;encoding&quot;: &q=
uot;dict&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;isShardBy&quot;: f=
alse<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quo=
t;DT&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;encoding&quot;: &q=
uot;dict&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;isShardBy&quot;: f=
alse<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quo=
t;ITEM_FIRST_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;encoding&quot;: &q=
uot;dict&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;isShardBy&quot;: f=
alse<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quo=
t;ITEM_SECOND_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;encoding&quot;: &q=
uot;dict&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;isShardBy&quot;: f=
alse<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;column&quot;: &quo=
t;ITEM_THIRD_CATE_NAME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;encoding&quot;: &q=
uot;dict&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;isShardBy&quot;: f=
alse<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 ]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;hbase_mapping&quot;: {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;column_family&quot;: [<u></u><u></u></span=
></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;=
F1&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;columns&quot;: [<u=
></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
&quot;qualifier&quot;: &quot;M&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
&quot;measure_refs&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 &quot;_COUNT_&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 &quot;QTTY&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 &quot;BEFORE&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0&quot;USER&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ]<u></u><u></u></span></=
p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;name&quot;: &quot;=
F2&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;columns&quot;: [<u=
></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
&quot;qualifier&quot;: &quot;M&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
&quot;measure_refs&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 &quot;SALE&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ]<u></u><u></u></span></=
p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 ]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 },<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;aggregation_groups&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 {<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;includes&quot;: [<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;BRAND_CD&quot;,<u>=
</u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;DT&quot;,<u></u><u=
></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;ITEM_FIRST_CATE_NA=
ME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;ITEM_SECOND_CATE_N=
AME&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;ITEM_THIRD_CATE_NA=
ME&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;select_rule&quot;: {<u></u><u>=
</u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;hierarchy_dims&quo=
t;: [],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;mandatory_dims&quo=
t;: [],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;joint_dims&quot;: =
[]<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;signature&quot;: &quot;Kl5sPTVN78bEYTGKoUOsWg=3D=3D&qu=
ot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;notify_list&quot;: [],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;status_need_notify&quot;: [<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;ERROR&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;DISCARDED&quot;,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;SUCCEED&quot;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;partition_date_start&quot;: 1483747200000,<u></u><u></=
u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;partition_date_end&quot;: 3153600000000,<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;auto_merge_time_ranges&quot;: [<u></u><u></u></span></=
p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 604800000,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 2419200000<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 ],<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;retention_range&quot;: 0,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;engine_type&quot;: 2,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;storage_type&quot;: 2,<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 &quot;override_kylin_properties&quot;: {<u></u><u></u></span=
></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0=C2=A0=C2=A0 &quot;kylin.hbase.region.cut&quot;: &quot;1&quot=
;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">=C2=A0 }<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">}<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#33333=
3">=E6=95=B0=E6=8D=AE=E9=87=8F=E6=98=AF</span><span lang=3D"EN-US" style=3D=
"font-size:10.0pt;font-family:Consolas;color:#333333">14</span><span style=
=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#333333">=E5=A4=
=A9=E7=9A=84=E6=95=B0=E6=8D=AE=EF=BC=8C</span><span lang=3D"EN-US" style=3D=
"font-size:10.0pt;font-family:Consolas;color:#333333">sale_ord_id</span><sp=
an style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#333333">=
=E7=9A=84=E5=9F=BA=E6=95=B0=E6=98=AF</span><span lang=3D"EN-US" style=3D"fo=
nt-size:10.0pt;font-family:Consolas;color:#333333">1.5</span><span style=3D=
"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#333333">=E4=BA=BF</=
span><span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;co=
lor:#333333"><u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">Select dt,item_second_cate_name,<wbr>count(distinct sale_ord_id),su=
m(sale_qtty)<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">from DMT.DMT_KYLIN_JDMALL_ORDR_DTL_<wbr>I_D a
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">left join dim.dim_day b on a.dt =3D b.dim_day_txdate
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">left join DIM.DIM_ITEM_GEN_THIRD_CATE_D c on a.item_third_cate_cd =
=3D c.item_third_cate_id
<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">group by dt,item_second_cate_name;<u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#33333=
3">=E8=BF=99=E6=9D=A1=E8=AF=AD=E5=8F=A5=E6=89=A7=E8=A1=8C=E6=97=B6=E9=97=B4=
=E6=98=AF</span><span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:=
Consolas;color:#333333">37</span><span style=3D"font-size:10.0pt;font-famil=
y:=E5=AE=8B=E4=BD=93;color:#333333">=E7=A7=92</span><span lang=3D"EN-US" st=
yle=3D"font-size:10.0pt;font-family:Consolas;color:#333333">,</span><span s=
tyle=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#333333">=E5=
=8E=BB=E6=8E=89</span><span lang=3D"EN-US" style=3D"font-size:10.0pt;font-f=
amily:Consolas;color:#333333">count(distinct
 sale_ord_id)</span><span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=
=E4=BD=93;color:#333333">=E5=90=8E=E6=9F=A5=E8=AF=A2=E6=97=B6</span><span l=
ang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#333333"=
>0.07</span><span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;=
color:#333333">=E7=A7=92</span><span lang=3D"EN-US" style=3D"font-size:10.0=
pt;font-family:Consolas;color:#333333"><u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333">dt,item_second_cate_name
</span><span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color=
:#333333">=E9=83=BD=E6=98=AF</span><span lang=3D"EN-US" style=3D"font-size:=
10.0pt;font-family:Consolas;color:#333333">normal</span><span style=3D"font=
-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#333333">=E7=BB=B4=E5=BA=
=A6=EF=BC=8C=E4=BB=8E=E7=BB=93=E6=9E=9C=E7=9C=8B=E6=98=AF</span><span lang=
=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#333333">co=
unt_distinct</span><span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=
=BD=93;color:#333333"><wbr>=E5=BA=A6=E9=87=8F=E5=AF=BC=E8=87=B4=E7=9A=84=E6=
=85=A2=E6=9F=A5=E8=AF=A2=EF=BC=8C=E8=AF=B7=E9=97=AE=E8=BF=99=E4=B8=AA=E6=9C=
=89=E4=BB=80=E4=B9=88=E4=BC=98=E5=8C=96=E7=9A=84=E5=BB=BA=E8=AE=AE=E5=90=97=
=EF=BC=9F</span><span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:=
Consolas;color:#333333"><u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span style=3D"font-size:10.0pt;font-family:=E5=AE=8B=E4=BD=93;color:#33333=
3">=E8=B0=A2=E8=B0=A2=EF=BC=81</span><span lang=3D"EN-US" style=3D"font-siz=
e:10.0pt;font-family:Consolas;color:#333333"><u></u><u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" align=3D"left" style=3D"margin-bottom:7.5pt;text-ali=
gn:left;background:white;word-break:break-all">
<span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:Consolas;color:#=
333333"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21.0pt"><span lang=3D"EN-US"><u=
></u>=C2=A0<u></u></span></p>
</div>
</div>

</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv><div dir=3D"ltr">Best regards,<div><br></div><div>Shaofeng Shi =E5=8F=B2=
=E5=B0=91=E9=94=8B</div><div><br></div></div></div></div></div>
</div>

--94eb2c0368523e408105487e7de6--