SQL Server 2008 Analysis Services(OLAP) - drill through

来源：互联网发布：物料破碎网络peixun 编辑：程序博客网时间：2024/05/07 04:00

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

http://www.sqldev.org/sql-server-analysis-services/drilthrough-on-ssas-2008-not-working-when-rolap-but-fine-when-molap-11903.shtml

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

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/825d1dc2-1aee-485c-a34a-31a2fe70e1fd

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4a4ba1e6-00e5-43d7-9520-a09055252d68

5>Fact Ry Jb.dim(zzzh,sfzh) + ROLAP 不会加大 cube size

6>Fact 拆2个表： sfzh + 详细信息附加表