Skip to Content
Author's profile photo Former Member

Refresh individual queries from workbook

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 ************************************

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      Nice doc and useful one.

      Thanks for sharing sourav.

       

      Thanks

      Author's profile photo Former Member
      Former Member

      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,

      Author's profile photo Former Member
      Former Member

      Hi Sourav,

       

      Nice blog.. Thanks for sharing..

       

      Thanks

      Author's profile photo Former Member
      Former Member

      Informative...Thanks.

       

      Best Regards,

      Naresh K.

      Author's profile photo venkat yerva
      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.