Skip to Content
Former Member
Apr 14, 2009 at 05:28 PM

#TOREFRESH with OLAP Universe



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.