BISM TABULAR MODEL 分集(EXCEPT)一个实例
来源:互联网 发布:js重复绑定click事件 编辑:程序博客网 时间:2024/05/16 06:11
use ExcelExercisego--===== Create the test table CREATE TABLE Purchase ( PurchaseID INT IDENTITY(1,1), CustomerID INT, ProductCode CHAR(1) PRIMARY KEY CLUSTERED (PurchaseID) );--===== Populate the test table with known data. INSERT INTO Purchase (CustomerID, ProductCode)------- Customer #1 precisely meets the criteria. -- Bought 'A' and 'B' but not 'C'. SELECT 1, 'A' UNION ALL SELECT 1, 'B' UNION ALL------- Customer #2 also meets the criteria. -- Bought 'A' and 'B' and somthing else, -- but not 'C'. SELECT 2, 'A' UNION ALL SELECT 2, 'B' UNION ALL SELECT 2, 'D' UNION ALL------- Customer #3 also meets the criteria. -- Bought 'A' and 'B' and something else, -- but not 'C'. SELECT 3, 'A' UNION ALL SELECT 3, 'B' UNION ALL SELECT 3, 'D' UNION ALL SELECT 3, 'A' UNION ALL SELECT 3, 'D' UNION ALL------- Customer #4 doesn't meet the criteria. -- Bought 'A' and 'B' but also bought 'C'. SELECT 4, 'A' UNION ALL SELECT 4, 'B' UNION ALL SELECT 4, 'C' UNION ALL------- Customer #5 doesn't meet the criteria. -- Bought 'A' and 'B' and something else, -- but also bought 'C'. SELECT 5, 'A' UNION ALL SELECT 5, 'B' UNION ALL SELECT 5, 'A' UNION ALL SELECT 5, 'B' UNION ALL SELECT 5, 'C' UNION ALL SELECT 5, 'D' UNION ALL------- Customer #6 doesn't meet the criteria. -- Bought more than 1 of 'A' and something else -- but not 'B'. SELECT 6, 'A' UNION ALL SELECT 6, 'A' UNION ALL SELECT 6, 'D' UNION ALL SELECT 6, 'E' UNION ALL------- Customer #7 doesn't meet the criteria. -- Bought more than 1 of 'B' and something else -- but not 'A'. SELECT 7, 'B' UNION ALL SELECT 7, 'B' UNION ALL SELECT 7, 'D' UNION ALL SELECT 7, 'E';
对于这样的表,我们想要的顾客选择:
产品A和B,但不包括C.
在T-SQL中,可以用EXCEPT
SELECT CustomerID FROM Purchase WHERE ProductCode IN ('A','B') GROUP BY CustomerID HAVING COUNT(DISTINCT ProductCode) = 2 EXCEPT--===== Find Customers that bought "C". SELECT CustomerID FROM Purchase WHERE ProductCode IN ('C')
那么,在BISM TABULAR MODEL 如何实现呢?
1,导入数据
2,分别计算包含产品A,B,C
3,IF逻辑判断
4,透视表展示
- BISM TABULAR MODEL 分集(EXCEPT)一个实例
- SSAS Tabular model 多多关系一个实例
- Tabular Model下的ADOMD.NET
- Tabular Model下的ADOMD.NET
- 分集 ->
- 使用SQL Server Analysis Services Tabular Model建立分析模型
- QML中的Model View——一个ListView实例
- QML中的Model View——一个PathView实例
- QML中的Model View——一个ListView实例
- QML中的Model View——一个ListView实例
- QML中的Model View——一个PathView实例
- BISM - DIRECTQUERY OR VERTIPAQ
- SSAS Tabular
- EXCEPT
- Except
- backbone中的model实例
- Django Model实例
- 分集技术
- eclipse把java项目导出jar包的工具
- 也谈系统设计的一些原则
- js限制本地上传文件大小(支持ie6,7,8 firefox 谷歌)
- 三句话影响人的一生【转】
- linux 网络传输scp命令介绍
- BISM TABULAR MODEL 分集(EXCEPT)一个实例
- Web-Harvest(1)
- oracle连接由于防火墙设置导致超时的问题
- 关于自定义代码生成器
- jquery-1.4.2.min.js和jquery.js有什么区别
- 仿扣扣聊天工具(实现多对一)
- 即将毕业。。。鸭梨山大。。
- 关于QTableView和QTableWidget设置代理的相关问题
- 不要做沙和尚式的程序员