I would like to use (business requirements) Advanced Analisys (Excel) instead of BEx Analyzer.
I have BEx query. I have created Advanced Analisys (AA) workbook on this query.
But I have the problems with refresh and VBA.
- How to tune AA to refresh workbook automatically then I open it?
- Where I should insert VBA-code to run automatically on refresh?
Is it possible?