cancel
Showing results for 
Search instead for 
Did you mean: 

Cell Refresh-Column Refresh-Emailing Report Content

bosegsap
Participant
0 Kudos
183

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

Accepted Solutions (1)

Accepted Solutions (1)

bosegsap
Participant
0 Kudos

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

TammyPowlas
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

bosegsap
Participant
0 Kudos

Hi Powlas

Issue got resoled using VBA-Script

Regards

Bose

TammyPowlas
Active Contributor
0 Kudos

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/