SQL Server 2008 Analysis Services(OLAP) - drill through

 

 

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 + 详细信息 附加表