on 03-20-2017 8:52 AM - last edited on 02-03-2024 9:21 PM by postmig_api_4
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.
Hi,
check properties of your workbook: Flag refresh workbook when opening
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sure. Please find attached screen shot of both the tabs fr your reference.workbook-1st-tab-main-tab.jpgworkbook-2nd-tab-reference-tab.jpg
Thanks for your help.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.