Skip to Content
author's profile photo Former Member
Former Member

#TOREFRESH Error in WEBI4.0

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2013 at 01:42 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2013 at 01:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 28, 2013 at 08:22 AM

    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-relational-connection

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 24, 2013 at 07:35 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.