on 07-30-2009 5:30 AM
有谁知道在universe designer sql语句用COUNT呢?
用户要求知道某个区域有多少销售额?但是他想知道有多少个客户发生了这些销售额,要统计出多少个客户在BW里面实现很麻烦,所以想在BO里面实现?请大家说说是否有好办法?有universe designer sql语句的使用说明吗?
想知道有多少个客户发生了这些销售额 ?
应该是需要非重复计算的count了吧.即一个客户即使发生多个销售,也算一个客户吧.
SQL用Distinct Count
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
可以在universe desinger中使用count。
也可以在报表中计算。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
只能用SQL·不能用BW的数据源进行类SQL的编写
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.