I have been fighting this for a couple days now, and not able to find anything online (for this service pack). Anyone have any thoughts on where to look?
Problem:
I try a drill through action. I try from Excel or SSMS.
Execute
DRILLTHROUGH MAXROWS 200000
SELECT FROM [myCube]
Returned result
Executing the query ...
Infinite recursion detected. The loop of dependencies is: .
Execution complete
I am running 2005, SP4 on both boxes:
9.00.5069.00 (X64) Aug 22 2012 18:02:46 for the Analysis services engine.
9.00.5000.00 (X64) Dec 10 2010 10:38:40 for the data source server.
I have seen the KB article and fix for SP3 where SP4 should have.
I have 163 attributes from the same dimension, that all originate from the same relational database table in a straight table select in the data source view.