#TOREFRESH Error in WEBI4.0

[Former Member]

Hello,

We have created webi report on BEx using BICS connection. We have Region and country input controls. Initial display of all the Key Figures coming from BEx are fine. But when we select few countries using inputcontrol then all KF's are displaying #TOREFRESH error then we need to refresh again.

Because of high volume data, report was taking long time to execute so we are scheduling report. But we need to refresh report again because of above error. So again it will take long time and no use of scheduling...

I know these are smart measures but any workaround for #TOREFRESH for KFs instead of refresh option????

Version using: BI4.0 SP4 Patch3.

[Former Member · Accepted solution]

Hi Suri,

In fact, "#TOREFRESH" is shown for measures whose values are calculated by the BEx datasource on which the Webi report is based when the measure has changed. 

When an input control changes the data that needs to be shown, Webi is not able to display the data for those measures without going back to the BEx data source to get the updated value being shown in the measure.  

An Enhancement Request about refreshing data automatically when "#TOREFRESH" has been posted in "Idea Place" . 

The link for this is as follows: https://cw.sdn.sap.com/cw/ideas/4104

The title of the idea was "Provide option to automatically refresh data if "#TOREFRESH" is displayed".  Since this is an idea for a future product enhancement, it is not something that is currently available for the Webi product. 

In the comments for this thread, somebody had brought up input controls and "#TOREFRESH".  and I noticed that a separate idea had been made for that.  The link for that idea is as follows:

https://cw.sdn.sap.com/cw/ideas/9226

Otherwise I suggest that you follow the reply of sunil kumar.

Regards,

Amine.

[Former Member · Accepted solution]

Hi Sunil kumar,

I am in bit confusion with your below comment in your post...... 

"""yes it is possible either using IDT or UDT in 4.0 on top of bex queries there you have to change the aggregation to sum instead of data base delegated"""

how can we create Universe on top of BEx query using IDT. Could you please provide some steps..

This was already discussed in many posts and confirmed that we can access BEx query only with BICS connection, but we can't create universe on BEx using IDT..

[Former Member · Accepted solution]

hi

sorry for above comments ,

1)You can create BICS connection in IDT and can be accessed directly using webi(no business layer ;It is said in docs that we can create BL in IDT but we cant)

2)we can connect to  Bex Query Using UDT only !!

3)Using Jco connector we can create a Bex query universe in multi source enabled  environment but it is not recommended it degrades your performance

And finally for your problem

you can create UDT unverse on top of bex and make the KF from Db delegated to Sum

Please close the thread if you found the answers to your questions

Regards

sunil

[former_member184594]

Hello Suri,

This issue is fixed with BO 4.0 SP4 and above for aggregation type SUM key figures. If you are concerned about performance of your report, you should go with BICS connection instead of OLAP universe or multi source enabled universe.

Using OLAP universes (created in UDT) is an old way and performance will not be good.

Check the link below about the differences of connections you can use in BO 4.0 and pros and cons ıf these connection types.

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/07/19/bics-vs-bapi-vs-df-rel...

[former_member189638]

Instead of directly using the KF in your report did you try using a formula instead SUM(KF)??

[Former Member]

Hello,

there is a fix delivered in SP04 Patch 4.5 for the #torefresh message when scheduling a report, see following SAP Note:

1759831 - When a Webi report is scheduled to "PDF" or "Webi" format, some of the
information that is returned shows up in the resulting document as
"#TOREFRESH".

Best regards,

Victor

[Former Member]

Hi Victor,

My issue is not related to scheduling.....

When we select few countries from inputcontrol then instead of aggregate and show the results for those countries it is displaying #TOREFRESH for all the measure coming from BEx.

So in above case, user needs to refresh again. I am looking for any workaround to avoid #TOREFRESH and avoid re refresh report....

Thank you...

[Former Member]

Hi

#Torefresh error occurs when the key figures are database detlegated

what you have to do is

1) aggregate the key figures at bex query level by using sum function

or

2)install the latest sevice pack sp05

or

3) create universe on top of bex query and change the key figure database delegated to sum function and use this universe to develop reports

hope this helps u

Regards

sunil

[Former Member]

If your key figure is additive, then you can get away with it using the proposal made by Sunil and Rakesh.

Else you can try to include different hidden tables using a different set of dimensions and the key figures needed.

Best regards

[Former Member]

Hi sunil,

By default it is sum only in Bex query level. Could you please specify where exactly we need to change it to sum in BEx?

Will it be resolved with SP5? I mean we have any document in which it was mentioned?

Hi Victor,

It is not clear to me about including different hidden tables. Could you please more specific in below scenario.

We have the data with KFs and object Category, We have input controls on Country. When we select few countries using input control Country then all the KFs are displaying #TOREFRESH. If we include Country and hide it then report data is not aggregating at Category level.

Hi Rakesh,

If we use SUM(KF) also no effect...

note: All KFs are Calculated and Restricted KFs

[Former Member]

Hi

under CMC-> Application -> Web Intelligence:

Afterwards you can modify the corresponding property in the report:

or

Its better try 3rd option i suggested ,it  works

Hope this helps

Regards

sunil

[Former Member]

As an example start with an example by inserting ony two characteristics (Category, Country) and one key figure (KF1) in the webi query.

-Insert a table with category, KF1

-Insert Input Control on Category.

-Insert one table with category, country and KF1->hide it

-Insert one table with country and KF1->hide it

-Insert one table with category and KF1->hide it

-Can you use the input control now without seeing #torefresh?

Then post the results of your test.

[Former Member]

Hi Anil,

As you said above option is in SP5? I am not able to find in SP4 patch5...

And is 3rd option possible using IDT in BI4.0?

Thank you,

[Former Member]

Hi Given,

I have mentioned only 3 objects for test.. But we have many objects in report. So we need to create tables with all combinations of dimensions with KF and hide to avoid #torefresh???

Thanks,

[Former Member]

well, did you test? and if yes, did it work with the simple test?

[Former Member]

hi

yes it is possible either using IDT or UDT in 4.0 on top of bex queries there you have to change the aggregation to sum instead of data base delegated

and for the service pack

one of the moderator says it is possible in sp4 FP3 so finaally if you are in latest  patch level SP5 patch 4 some of the issues will be solved right ?

Hope this helps you 

Regards

sunil

[Former Member]

Hi,

unfortunately you cannot create a universe on top of a BEx query with IDT.

Auto-Refresh: The plan is to include this option in a future release, unfortunately you cannot use this today.

The screenshots shared above are from a time when this functionality was available for a short time:

http://scn.sap.com/message/13500951

Best regards,

[Former Member]

Hi Victor,

I just tried with few objects but we do not have any issues with three objects (Country, Category, KF1) and it is working without #torefresh even if we use inputcontrol on country.

But I added one more dimension object 'Type' (which has two values) then it is displaying #torefresh with inputcontrol on country.

I followed all your steps but still it is displaying same..

In my scenario, when we execute report, KF is displaying fine with all 3 dimensions are in table. but it is displaying #torefresh with any combination of one dimension.

So initially, input control is selected 'All values' so I re refreshed report then all combinations are working fine. If we select 1 country then #torefresh displaying. Re refresh again.. now if you select any country... all combinations are working fine, but if you select all values then again #torefresh..

[Former Member]

I am not sure if you can get away with this workaround using multiple input controls, you are welcomed to try with all possible characteristic combinations (if you are eager, you can take into account characteristic sorting order too).

Normally the answer to your question is a simple no: You cannot do all the filtering in the front-end side without hitting the database again.

Why? -> Because the definition of your key figures are inside the BEx query (Calculated and Restricted KF), not in the front end, so webi doesnt really know how to filter without the definition (e.g. Formula) done in BEx.

Best regards,

Victor

[Former Member]

Hi Victor,

I will try all the workaround with all combinations and update the results.

but could you please confirm from which service pack or Patch level,  #Torefresh is fixed? (I mean the option is available in screenshot which Sunil is posted above..)

[Former Member]

Plan would be BO 4.1:

http://scn.sap.com/community/bi-platform/blog/2012/11/18/what-is-coming-in-businessobjects-bi41-cust...