#TO REFRESH Error In Webi report

[Former Member]

Hi All,

PFA..Error Screenshot

For some of my reports am getting #To Refresh error in some columns(Measures)

1) when i click on Refresh button am not getting #To Refresh Error therefore am getting the values

2) when i Drag any objects in to report am getting the same error and similarly if i delete any column from the report am getting the same error.

Kindly help me to overcome from this error.

Thanks in Advance.

Thanks & Regards,

Bharatkumar V

[CdnConnection · Accepted solution]

Kumar,

     This is a know issue with WebI when using BICS connection.  The problem is that Query stripping is checked off by default when creating Query against BICS.  There a better option in BI 4.1 w/ SP1 but BI 4.x you need UN-check Query stripping, see below.

Regards,

Ajay

[Former Member · Accepted solution]

Hi Ajay,

I checked the same  by default it's off

[CdnConnection · Accepted solution]

Kumar,

     What patch version of BI 4.0 are you running?   This could be another issue that was resolved by SP6.

Regards,

Ajay

[Former Member · Accepted solution]

Hi Ajay,

We are using BI4.0 with SP6 and Patch 6.1 .

Thanks & Regards,

Bharatkumar V