1>记录数(重复)
Fact Ry Jb.dim(zzzh,sfzh) + MOLAP / cube + usage + fact(degenerate dimension)/IgnoreUnrelatedDimension=false >>> drillthrough OK
2>记录数(重复)
Fact Ry Jb.dim(zzzh,sfzh) + ROLAP / cube + usage + fact(degenerate dimension)/IgnoreUnrelatedDimension=false >>> drillthrough error
The selected action cannot be completed because of the following error.
This error may have occurred because the definition for the action is not valid. Verify the definition using the Actions view. (Microsoft SQL Server Management Studio)
3>记录数(重复)
Fact Ry Jb.dim(zzzh,sfzh) + ROLAP / cube + usage + fact(degenerate dimension)/IgnoreUnrelatedDimension=false / KeyDuplicate=IgnoreError >>> drillthrough OK
4>记录数(重复) 或 distinct count
Fact Ry Jb.dim(zzzh,sfzh) + ROLAP / cube + usage + fact(degenerate dimension) 或 many-to-many relationship/IgnoreUnrelatedDimension=false / KeyDuplicate=IgnoreError >>> drillthrough OK
在distinct count上drill through的结果集,包含重复sfzh
5>Fact Ry Jb.dim(zzzh,sfzh) + ROLAP 不会加大 cube size
6>Fact 拆2个表 : sfzh + 详细信息 附加表