Skip to Content
avatar image
Former Member

Refreshing Workbooks in BW 3.5

Guys,

I have a requirement - We have a workbook and this workbook contains 3queries. This workbook needs to be refreshed every month on 1st, 2nd and 3rd day.

I would like to make this an automatic process. We do not have WebTemplates for the queries. Is it possible only based on Workbooks?

I checked few threads on SDN but i'm not familier with VB coding. Is there any other way than using VB code? If yes, what is that? If no, can you please give me step by step VB code and where to write it.

Without VB knowlegde is there any way to do it?

Thanks in advance for your help.

Thanks & Regards,

Edited by: Sarkar on Sep 3, 2008 11:02 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 09:53 PM

    Hi,

    With workbooks the user can also choose whether to refresh the data automatically when the workbook next opens or to open the workbook with the old (frozen) data first, the user could then choose to manually refresh the data.

    In Bex Analysis toolbox -> Refresh/Automatic Refresh

    This above option is a toggle button, which will allow you to toggle between

    Automatic and Manul refresh..

    So, set your workbook to automatic refresh.

    For more info on this, read ahead:

    __________________________________________

    Refresh / Pause Automatic Refresh

    The default action following any change to the navigation state of the result

    set in a workbook is that an automatic refresh of the query is performed.

    If a user wishes to enter a series of filters then it would be inefficient for the query

    to automatically refresh each time a filter was entered, especially if the refresh

    took a while to complete.

    It is possible to halt the auto refresh from executing and instead switch to a manual refresh mode which means that the user can enter a series of filters and when they are ready they simply press the fresh button in the toolbox to trigger the refresh.

    This means the OLAP processor can process all the filters in one step. The refresh icon appears slightly differently depending onwhether the workbook is in automatic refresh mode or manual refresh mode.

    To switch between the automatic refresh and manual refresh modes simply press the

    refresh button in the analysis toolbox.

    When a workbook is saved the reporting data can also be saved with the workbook.

    This means that when the workbook is reopened the user will immediately see the

    old reporting data, they would have to press the refresh button in order to refresh

    the data. _You have to consider whether this is the required behavior for the users,

    they may prefer to have the workbook automatically refresh on opening._ If the

    latter is the case then switch the default check box setting to Refresh workbook

    on opening.

    If data is huge, broadcasting on the desired days would ba good option.

    Hope this is of help to you..

    Cheers,

    Habeeb

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 09:40 PM

    Try broadcasting on the on the 1,2,3 days, if this is not possible

    set it to refresh on open so that it refreshes sometime everyone opens it.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2008 at 06:30 PM

    You can use Precalculated web template functionality instead of workbooks or you can set Bex Analysis toolbox -> Refresh/Automatic Refresh option to automatically refresh the workbook everytime it opens.

    Add comment
    10|10000 characters needed characters exceeded