Skip to Content
0

Cell Refresh-Column Refresh-Emailing Report Content

Jul 06, 2017 at 11:17 AM

34

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jul 06, 2017 at 11:26 AM
0

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/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 06, 2017 at 02:46 PM
0

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

cell-refresh.png

Item-2: Please have a look at Column-Refresh image where Only column Sales-Qty "Column" need to be refreshed but not others

column-refresh.png

Regards

Bose


Show 1 Share
10 |10000 characters needed characters left characters exceeded

On 2 and 3 - I don't see a straightforward way to do this; I can't find functions that will do this. That said, it maybe possible with VBA script, but I am not an expert in that. I wonder if converting to formula may help.

Hopefully the community will have some other suggestions

0