Hi all,
I recently built a cube named c1, use 2 columns as dimensions ,”rule_name”,”
PARTNER_GAIN_PAY_PT_DOC_CNT”, also use ” sum(PARTNER_GAIN_PAY_PT_DOC_CNT)” as
measure. C1 was built successfully.
So, I made a query sql to test, that is “select
rule_name,PARTNER_GAIN_PAY_PT_DOC_CNT
,count(*),sum(PARTNER_GAIN_PAY_PT_DOC_CNT) from
CUB_PARTNER_GAIN_PAY_PT_PRE0_AT0_S where rule_name='1号店3C产品' group by
rule_name,PARTNER_GAIN_PAY_PT_DOC_CNT;”, but the result is not probably exactly.
RULE_NAME PARTNER... EXPR$2 EXPR$3
1号店3C产品 1860 30 1860
1号店3C产品 700 2 700
1号店3C产品 7410 38 7410
1号店3C产品 2940 60 2940
In my opinion,”count(*)” means the amount of records with the same rule_name
and PARTNER_GAIN_PAY_PT_DOC_CNT, so I think sum(PARTNER…) equals
Count(*) * PARTNER_GAIN_PAY_PT_DOC_CNT, but the truth is not , I wonder if
there is something wrong with my understanding?
Insight snapshot as below:
[cid:[email protected]]
********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If
you have received this email in error or are not the intended recipient, please
immediately notify the sender and delete this message from your computer. Any
use, distribution, or copying of this email other than by the intended
recipient is strictly prohibited. All messages sent to and from us may be
monitored to ensure compliance with internal policies and to protect our
business.
Emails are not secure and cannot be guaranteed to be error free as they can be
intercepted, amended, lost or destroyed, or contain viruses. Anyone who
communicates with us by email is taken to accept these risks.
收发邮件者请注意：
本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************
