on 2017 Jul 06 12:17 PM
Hi Friends
Currently we are working on BW 7.4 with AO 2.4 (analysis office)
As of now we are using BEx queries as source for designing AO workbooks.Our business is demanding below requirements,but not sure we can achieve or not, need your experiences...
1) Cell refresh
2)Column refresh
3)Emailing report content to business users email id's (Excel sheet & Excel workbook)
BR
Bose
Request clarification before answering.
Hi
Item-1 : Please have a look at cell-refresh image where I am trying to refresh a cell which is related to Sales_qty for Sales-Order-S001
Item-2: Please have a look at Column-Refresh image where Only column Sales-Qty "Column" need to be refreshed but not others
Regards
Bose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Powlas
Issue got resoled using VBA-Script
Regards
Bose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bose -
On items 1 and 2, can you provide more details?
On item 3, would scheduling meet your needs? See https://blogs.sap.com/2015/02/25/checklist-for-scheduling-of-analysis-for-office-workbooks/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
48 | |
10 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.