Skip to Content
avatar image
Former Member

Reference given in Workbook does not refresh always

Hello Experts,

In my current project, I am working on BI 7.4 SP 008. . The customer's requirement was to create a report in the format they send to their management for which I have created workbooks in BI wherein I have to create 2 tabs in workbook. First tab is the main tab where data from BEx Query is displayed and the selection criteria for the workbook is Fiscal Year Period and Company Code.

In the 2nd tab I have given the reference of the 1st tab and have done some formatting of colours & borders in the way they report to their management. The issue is when I run the workbook, In the Main tab (First tab) the data gets refreshed according to the Fiscal Period entered in the selection criteria, But in the 2nd tab where the reference has been given, They are not changing always. Sometimes the numbers get changed according to the first tab but sometimes they remain the same as of when executed last time. That means the data doesn't get refreshed in the refrerence tab properly.

It would be appreciable If anyone could help me in this uncertainty issue. Appreciate your help in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 20, 2017 at 10:22 AM

    Hi,

    check properties of your workbook: Flag refresh workbook when opening

    Add comment
    10|10000 characters needed characters exceeded