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

Workbook Refresh

My company is undergoing an upgrade from BW 3.5 to BI 7.0. I have an issue that I am trying to find a definitive answer for. It involves refreshing of individual queries in a multi-query workbook. I am looking for the same or similar functionality in BEx 3.5 where individual queries in a workbook are refreshed with different input parameters. In other words, how do you get to refresh single query within workbook on demand at any given time. Just one query of our choice without refreshing anything else using BEX 7.0 version.

I have gone through SAP Note 1287179. I get the same results proposed in the note. We are getting a u201CRefresh This Queryu201D option in the context menu. However, this only allows an individual refresh once and without changing the input parameters. Once a query has been refreshed or the workbook has been refreshed, the option to "Refresh This Query" is not there.

In short, I am looking for the same workbook refresh functionality as in BEx 3.5. Does anybody have any comments or suggestions?

Thanks,

Mario

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 28, 2009 at 02:38 PM

    In workbook settings -


    >General tab -


    > you need to tick the check box "Allow refresh function for individual queries"

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2009 at 02:39 PM

    Mario,

    To refresh a particular query in a workbook, select any cell in the query output and his refresh button. It will refresh only that query. If you will put the cursor outside of the query result on blank cell and hit refresh, this will refresh all the queries.

    Under General tab select "support single data provider refresh".

    For avoiding the selection screen every time you refresh, go to workbook setting from BEx toolbar and select process variable on refresh under variable tab.

    Regards,

    Kams

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2009 at 09:12 AM

    Hi Mario

    We are having exacly the same problem as you.

    We are upgrading and I verified that it is not possible to refresh queries separately in the workbook. Whe I activate several queries, then I will only be able to refresh variables to all of them together. If I choose to veiw all variables separately it can get quise confusing. I am affraid that the end user will be even more unsatisfied with the time, effort and increase of complexity needed to refresh queries that is coming together with this upgrade.

    Have you found a solution meanwhile? How have you solved this situation for the end users? Does anyone has a solution for this handicap?

    Thanks a lot for any help you may provide

    Heloísa

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Heloísa,

      Unfortunately, I have not found a solution. A workaround could be to limit the number of queries in a workbook but this probably won't be welcome by your users. I haven't explored the tools in BI 7.0 but I think there might a way to refresh a workbook in the background. This could be another workaround.

      Regards,

      Mario

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2011 at 11:29 AM

    Hi all,

    Someone was able to find a workaround for this issue?

    thanks a lot

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi all,

      Just to inform you I found the solution on this SAP NOTE.

      SAP Note 1425496 - BExAnalyzer: variables are melted incommand VAR_SUBMIT

      My MIS has to install a patch on BW and now when we use the MELT_VARIABLES it works perfect...

      cheers!

      Martin

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2014 at 07:37 AM

    Hi Friends,

    We are currently facing this issue....

    Here is a note suggested by SAP to resolve this. This looks like a new development from SAP side. Make sure you are on the correct versions both backend and frontend as mentioned in the note.

    1849135 - BExAnalyzer: Single Data Provider Refresh Functionality NEW

    Regards,

    tapas

    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.