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

#TOREFRESH ISSUE IN WEBI

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2012 at 12:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2012 at 09:28 PM

    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


    Add a comment
    10|10000 characters needed characters exceeded

    • 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... 😊

  • Posted on Jun 06, 2012 at 01:38 PM

    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 ()
    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2012 at 05:19 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 28, 2012 at 04:57 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 29, 2012 at 07:44 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 29, 2012 at 08:00 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Mar 01, 2012 at 03:50 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2013 at 09:03 PM

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

    Regards

    Sebastián.-

    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.