#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