We are on XI 3.1, using using an OLAP universe (Analysis Services 2005). I have a cross tab report and when I start drilling down on the rows, if the column starts at Level 1 of the underlying cube, I get #TOREFRESH as I'm drilling down on the report. If the column starts at a lower level in the hierarchy, I can drill all the way down on the row dimension without gettting #TOREFRESH at all.
What causes this behavior and is there anyway to prevent it? For the end user it's frustrating to have to keep refreshing the data to drill down through the report.