Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Drillthrough using a view external to a cube

Author  Topic  gayatri Starting Member 2 Posts Posted - 2004-10-26 : 06:34:37 Hi, I have implemented drillthrough in a cube using an external view V1 (not part of the cube). I match fact_table.col1 to V1.col1 and display all the columns in V1. The drillthrough works fine except in one condition - While browsing the cube, if I select a dimension D1 in the row area and drill down to a level where L3 (hierarchy is L1 -> L2 -> L3) where the values at level L1 and L2 are null, then the drillthrough at that level does not return any rows. That is, if any of the ancestors of the level at which the drill through is executed is null, then the drillthrough does not return any rows. I executed the corresponding MDX query in the MDX sample application, and I get the required rows for that context. select {[D1].[All D1].[].[].[XXX]} on rows, {[Measures].[M1]} on columns from [CubeA] XXX is a value at level 3 of dim D1 for which drillthrough is executed. If this query is returning the correct rows, then why is the join of this resultset with V1 failing? Any ideas? Thanks, Gayatri