cancel
Showing results for 
Search instead for 
Did you mean: 

#TOREFRESH with OLAP Universe

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Jonathan,

#TOREFRESH appears in a Web Intelligence Report when the measure used in the query has a projection function set to Database Delegated (Smart Measure) in the universe and Scope of Analysis is set to a specified level in the Web Intelligence Report. Thus, when the user drills through in the report, Web Intelligence needs to delegate the calculation to the database and hence needs to connect to database but Scope of Analysis stops it from going to the database. (Because scope of analysis brings in all data to a level set right at the time of first query and not during each drill). This is by design.

Resolution:

To avoid #TOREFRESH, you can remove the scope of analysis option in Web Intelligence Report. By doing so, each time when a drill operation is performed, a new query is performed and the Database Delegated measure will be able to delegate the calculation of function to the database.

Reference: SAP Internal

Hope this helps.

Cheers,

Subhodeep

Former Member
0 Kudos

Hi Subhodeep

We have the exact same issue with an OLAP universe.

When I look at the Scope of Analysis pane I can see the dimensions I use for drill down (alternate hierarchy created in the universe) but Scope Level was already set to NONE.

I tried changing it to custom, or to 3 LEVELs and it didn't make a difference.

How exactly can you remove the Scope of Analysis all together?

Thank you

Sabine