I was trying to create an MDX drillthrough this morning in my SSAS 2005 cube, and I got this error:
Errors from the SQL query module: The attribute 'Applicant Name' in the dimension 'Dim Candidate' is outside the granularity of the measure group 'Fact Requisitions' and cannot be returned as a column.
I only got one result from Google for that error message and it wasn't helpful at all. After trying a million different things with partitions and actions and whatnot, I finally figured out the problem: I was trying to return drillthrough data from a fact table other than the one containing the default measure. Once I threw in a measure (in the SELECT part of the query, not the RETURN) from the non-default fact table, everything worked great!