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

#TOREFRESH with OLAP Universe

23 Views

Hi,

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.

Thanks,

Jonathan