#TOREFRESH ISSUE IN WEBI

[Former Member]

Hi All,

I am in the process of creating Webi reports on top of BEx queries.I have been exploring ways to resolve the #TOREFRESH issue in Webi Reports.My analysis,till now is

" default behavior is ,whenever we make the grain of the report to be more than the grain of the query(this is in the context of creating a Webi report directly on top of BEx), we would get the #ToRefresh in the measure cells(When the u201Cgrouping setu201D containing the value is not available in the data provider(BO micro cube)) .Refreshing the query resolves the issue"

This doesn't look like a user friendly option to me.

SAP BOBJ SERVER:SBOP BI Platform Servers 4.0 SP02 Patch 12

SAP BI RELEASE:701 SP9

Any help would be highly appreciated.Thanks in advance.

Regards

Amit P

Edited by: Amithpathak on Feb 28, 2012 12:57 AM

[Former Member · Accepted solution]

Hi

In other way

Create a universe on top of BEX query and change the data delagated to sum for each key figures in universe .

so that this issue will be solved

Regards

Sunil

[IngoH · Accepted solution]

Hello Sunil,

there is no Universe on top of a BEx query.

The option outlined previously to configure the auto refresh in BI 4.1 is the solution.

BI 4.1 goes into RampUp in May 2013 - so this month

regards

Ingo Hilgefort

[Former Member]

Check the filters. Sometimes the query filters make corrupt the refresh of the graphs. Remove them and check.

Regards

Sebastián.-

[Former Member]

Hi,

following note fits Henry's comments from above:

1758513 - How to enable Auto-Refresh option for Web Intelligence Document for BI 4.0 SP04

After applying the note, following option will become available under CMC-> Application -> Web Intelligence:

Afterwards you can modify the corresponding property in the report:

Best regards,

Victor

[giriraj_harapanahalli]

We applied this patch (SAP Notes), it now works when I create new webi, but if I schedule an instance it still shows same error.

[Former Member]

Hi,

what's about this note

1758513 - How to enable Auto-Refresh option for Web Intelligence Document for BI 4.0 SP04

.. Victor mentioned.. is it available anywhere.. or better.. what is the content of it.

I wanna also activate the function "Automatic refresh when needed" but i don't know how to enable this function because i can't open the mentioned note.

Thanks for advices!

Regards,

Oli

[Former Member]

Hi,

you have to wait for BO 4.1:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/03/10/what-is-new-with-web-i...

Best regards,

Victor

[Former Member]

Hi Victor,

I am facing the same issue...i checked for the same from CMC but unable to find that avoid refresh option there under web i (application). I am using BO 4.0 SP 6.

I tried opening that note aswell but i gave me an error that note not been released.

Can you please advise on this...

[Former Member]

Hi Amit,

We will be receiving #TOREFRESH error when we use the OLAP Universe based on BW query or CUBE. It will be an issue when we schedule the report and we need to refresh again, if we get this error.

Resolution

1. We can ensure number of objects in the query panel should be used in the block at the report level
2. At Universe, apply the Sum, and the properties to set the correct projection instead of Database delegated
3. Report level variable by applying Sum ()

[former_member188911]

If it was that easy Henry or others would have given this advice.

Remains valid my previous communication

"In some cases there is no automated solution for having the sets of queries refreshed and this warning comes out however with the help of case studies the developers can improve this whenever possible. 

Hence the request to please open a specific CSS message so we can investigate and submit to development if necessary."

Thanks

[former_member226862]

More details about this particular enhancement in FP3 would certainly help.

When you referenced "Per Document" - do you mean "Per WEBI report"? If so then we could work with this assuming that #TOREFRESH feature could be turned on/off per WEBI report.

[Henry_Banks]

I have been asking product for 6 months, they aren't forthcoming . I'll keep up that line of enquiry

Yes, per document. (.wid file) the term 'report' is strictly speaking, the tab itself inside a document.

Regards,

H

[Former Member]

Henry,

We are now on FP 3 Patch 4 and still face this issue with #TOREFRESH showing up while using input controls with Webi reports using BICS. Each time a manual refresh is required to get the data after the selection of input controls. Any updates on this issue would be helpful.

Thanks.

[former_member188911]

Hello,

in some cases there is no automated solution for having the sets of queries refreshed and this warning comes out however with the help of case studies the developers can improvet this whenever possible.

Hence the request to please open a specific CSS message so we can investigate and submit to development if necessary.

Thanks!

Simone

[former_member226862]

Henry - are you saying that with FP3 WEBI will always refresh data from data source if there is anything changed on report? There are not going to be option at the report level to tun on/off #TOREFRESH?

Now that I understand differences between 'Reading' and 'Design' mode I do not mind seeing #TOREFRESH (and it even makes sense to see #TOREFRESH) messages when I add new/delete unused dimensions from query object. However if changing input control values will trigger automatic data-source refresh - our users will not be pleased.

[Henry_Banks]

Hi,

Yes, and therein lies our quandry: a solution for half the population becomes a undesirable hinderance for the other.

As i understand it, although details are sketchy, this automation of the #torefresh will be driven by a per-document configuration file which will need to be administered. (not by end- users)

Regards,

H

[former_member226862]

Here is work-around that we used to eliminate #TOREFRESH from displaying in 'Reading' mode. We added sum function to measure columns.If measure column was '=[Order Qty] it was changed to =Sum([Order Qty]).

Depending on information displayed in some instances we needed to add dimension information within Sum function. For example - one of the formulas we used looks something like this = Sum([Order Qty] in ([Dim 1];[Dim2]))

This workaround does not eliminate #TOREFRESH in design mode when new dimensions are added/deleted to/from query object. There is no work-around when number of dimensions are changed in query object.

However this workaround worked perfectly to eliminate #TOREFRESH from displaying when we added Input controls filtering to the report.

[Henry_Banks]

Hi,

The #TOREFRESH story will change during FeaturePack03 codeline

- BICS measures will not automatically default to 'delegated aggregation'. (SUM will be used, if appropriate)

- =#TOREFRESH will be automated, so that it doesn't show #TOREFRESH and actually refreshes without notifiying the user.

(risk here is that users will complain "my report timed out, all i did was drag-drop calday")

Regards,

H

[Former Member]

Hi Henry,

Thanks for that.Any idea when FeaturePack03 codeline is expected to come out.

Regards

Amit P

[Former Member]

HI Amithpathak,

1.Open webi document in design mode.

2.left side panel you see Document--->Properties.

3.Uncheck query stripping.

For you reference

http://wiki.sdn.sap.com/wiki/display/BOBJ/OptimizequerywithQueryStrippinginWeb+Intelligence

above document is screenshot of 3.1.

but similar in 4.0 try navigate.