#TO REFRESH ERROR ON DRILL

building reports webintelligence
1

Hi ALl
I am getting a #TOREFRESH error on drill on a number. What could be the reason?

ajq

anushajq (BOB member since 2005-02-22)

2

Hi,

I too am facing the same problem. My universe is on top of an OLAP cube. Please let me know if you got any solution or workaround to this problem.

javi (BOB member since 2007-06-13)

3

Do you have Smart Measures?
If yes, you have to enable “Query on Drill” from the properties of the Webi report.

#TOREFRESH means that the new level showing up needs to recalculate measures in order to show correct results.

Astro :argentina: (BOB member since 2007-02-15)

4

Thanks for the prompt reply.

I’m not sure what is Smart Measures so probably I’m not using it since I have built the universe as well. However, I could see the option “query drill” already enabled under Document Properties.

Please note I’m using WebI Xi R3 and Oracle Hyperion Essbase cube (OLAP cube) as the data source in my universe.

javi (BOB member since 2007-06-13)

5

I am getting the same results but using Microsoft Analysis Services Cube as the data source.

landonld (BOB member since 2006-08-11)

6

I am having the same problem with #TOREFRESH…

I am using webi R3.1 with an SQL Server 2008 Anaylsis cube. The cube has a heirarchy.

Under Document prpoerties in Webi, the “Use Query Drill” is checked.

But, when I drill through the heirachy in webi to another level, the #TOREFRESH message is displayed in the numeric calculated fields from the cube.

Any help is appreciated.

Thanks

mountainman (BOB member since 2008-09-02)

7

Same error, different situation.

Just upgrade to:
BOE3.1, SP 2, FP 2.7
BOE3.1 SAP IK, FP 2 .7

Running a Web Intelligence report against a BEx cube. Query returns with correct data. When I add or remove few specific dimensional objects, the measures give me a #TOREFRESH error. I then refresh and I get new, correct data.

I hope I have to refresh ever time.

John Gresham :us: (BOB member since 2003-10-20)