Skip to Content

Introduction: This article contains information about BW workbooks with a business scenario to refresh individual queries from a workbook. Options available to create or change a query is however outside the scope of this article.

Author’s Bio: Sourav is having more than 6 years experience in SAP BI, he has worked on several support and enhancement projects; currently working with IBM India Pvt Ltd.

/wp-content/uploads/2013/08/me_267017.jpg

Workbook: Workbook is a predefined saved view of query or a combination of queries. These are basically created and saved as per user’s choice i.e., end users would be having liberty to create their own workbooks and either save to their local system or to the SAP server.

Business Scenario: When we create workbook with multiple sheets (queries), sometimes it is not needed to refresh all the queries at once. However if we try to refresh only a single query in a workbook where a number of worksheets are available with a different query, it is not possible.

Solution: Below are the steps which should be followed in order to refresh only a single query from a workbook.

Step1: Open the workbook and select workbook setting.


/wp-content/uploads/2013/08/image14_266996.jpeg

Step2: Check ‘allow refresh of individual queries’.

/wp-content/uploads/2013/08/image15_266997.jpeg

Step3: Now go to Tcode RS_FRONTEND_INIT. Make sure that you have change access to that Tcode. Add one entry there –

ANA_ENHANCE_REFRESH = ‘X’.

/wp-content/uploads/2013/08/image16_266998.jpeg

Step4: Now you can see the refresh button has been enhanced to display two option (one for refreshing all queries and one for refreshing only the selected query).

/wp-content/uploads/2013/08/image17_267016.jpeg

****************************** Thank you ************************************

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Benjamin Lignereux

    Hello all,

     

    Thank you a lot Sourav for your tip.

    I just would add as information that you should also go in the Global Settings of Bex Analyzer and check “Allow Refresh on Individual Queries” for all Running Workbooks in order to the trick works.

     

    Regards,

    (0) 
  2. venkat yerva

    Hi Sourav,

    I did the settings as mentioned by you but i didnt get the option ‘Refresh this query’.

    We are currently at BI 7.31 SP08 and using GUI 730.

    Can u help me how to achieve it?

     

    Thanks,

    Venkat.

    (0) 

Leave a Reply