SQL 2000 Anlaysis Services
Oracle 9i back end database


When drill through is requested in the cube, simetimes not all the joins are
being done for the dimensions in the cube. What would cause this? Is there
a limit to the number of joins for the drill through? If you use the filter
to add the missing joins, you can work around it. Is there a way to avoid
having to do the filter joins?

Thanks,
--
Sue

According to this Microsoft Support article, the problem occurs when the
Cube Schema is optimized. AFAIK, you have to specify joins in the filter
as a work-around:

http://support.microsoft.com/default...port.microsoft.
com:80/support/kb/articles/q306/1/91.asp&NoWebContent=1
Is Optimized

Article ID : 306191
Last Review : June 28, 2004
Revision : 2.0

This article was previously published under Q306191

SYMPTOMS
Drillthrough queries in Analysis Services may return more rows than
expected if the cube schema is optimized and the drillthrough query data
set includes columns from a dimension table that had it's join removed
by the schema optimization process.

CAUSE
Missing joins in the WHERE clause cause the drillthrough query to return
more rows than expected.

WORKAROUND
To work around this problem, explicitly specify the missing joins on the
Filter tab of the Drillthrough options for the cube in the Cube Editor
or for the partition in the Partition Wizard.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***