## SAP BO Analysis for Office (BOAO) Automation
This tool allows you to automate refresh of workbooks with BO Analysis data sources.
Tool helps to automate change of Variables (Prompts) and dimension Filters (Background Filters), and then refresh process itself.
On top of this, you can configure additional actions like "Save As", "Save As & Email", "Refresh All", Run another specific macro etc.
Solution consists of only one worksheet (VBA code is inside it)
- [BOA Control Panel.xlsb](https://github.com/IvanBond/SAP-BOA-Automation/blob/master/BOA%20Control%20Panel.xlsb)
Worksheet can be easily moved to your workbook using standard "Move worksheet" Excel action. Then just collect variables, set values and run Refresh.
# BOA Control Panel
Your future operational center. Control Panel is a worksheet, which includes
- tables defining scenarios of refresh and variables with their values
- VBA code
# How to use this tool
Assume you already have a workbook with BOA data sources and want to simplify refresh process. Let's call it 'Target Workbook'.
0. Open 'Target Workbook' and 'BOA Control Panel' side by side in one Excel application.
1. Move worksheet 'Control Panel' to 'Target Workbook'
2. Press 'Collect Variables'. Macro will make inventory of data sources and their prompts / variables / filters.
3. Specify necessary settings, such as "Scope", "Refresh?", "Order", values for Variables and Filters.
Use formulas to make values of your variables dynamic, then you no longer need to change them manually.
You are ready to refresh!
# Optional steps
- If you don't want to enter your password each time - follow the instruction in comment for 'Path to file with passwords' cell.
- You can specify macros that should be executed before BOA refresh and after (e.g. for your saving/mailing scenario).
# What is 'Scope'?
Scope defines set of settings for data sources and sets of variables.
Assume you want to refresh same workbook for two different Sales Organizations.
Easy. Just define two Scopes with corresponding values for variables.
Using Scopes you may define very advanced scenarios of refresh.
E.g. imagine report when you need to execute 10 queries for current and previous year. Without Scopes it would be 20 queries, 10 for each year. But with Scope you may leave only 10 queries.
Define two Scopes - Prior Year, Current Year. Enable 'Refresh All Scopes' option. Using formulas for variables, force them to calculate corresponding to active Scope values. Add simple macro that will copy data after 'Prior Year" scope refresh is done to another worksheet. Use it in 'Macros After' for the last data source of PY scope. Then after refresh of all scopes you will have static data of PY on one worksheet and data sources with CY on another.
If you run refresh from outside of workbook, e.g. like it is shown in [Sample Refresher VB script](https://github.com/IvanBond/SAP-BOA-Automation/blob/master/Refresher%20Sample.vbs) - you can even run refresh in parallel.
没有合适的资源?快使用搜索试试~ 我知道了~
SAP-BOA-Automation:使用VBA的SAP BO Analysis Excel插件自动化
共6个文件
xlsb:1个
license:1个
md:1个
需积分: 49 6 下载量 11 浏览量
2021-05-12
10:24:26
上传
评论 1
收藏 239KB ZIP 举报
温馨提示
Office(BOAO)自动化的SAP BO Analysis 使用此工具,您可以使用BO Analysis数据源自动刷新工作簿。 该工具有助于自动更改变量(提示)和尺寸过滤器(背景过滤器),然后刷新流程本身。 在此之上,您可以配置其他操作,例如“另存为”,“另存为和电子邮件”,“全部刷新”,运行另一个特定的宏等。 解决方案仅包含一个工作表(其中包含VBA代码) 使用标准的“移动工作表” Excel操作可以轻松地将工作表移动到您的工作簿中。 然后,只需收集变量,设置值并运行“刷新”即可。 BOA控制面板 您未来的运营中心。 控制面板是一个工作表,其中包括 定义刷新和变量及其值的方案的表 VBA代码 如何使用这个工具 假设您已经有一个包含BOA数据源的工作簿,并且想要简化刷新过程。 我们称之为“目标工作簿”。 在一个Excel应用程序中并排打开“目标工作簿”和“ BOA控制面板”。
资源推荐
资源详情
资源评论
收起资源包目录
SAP-BOA-Automation-master.zip (6个子文件)
SAP-BOA-Automation-master
Refresher Sample.vbs 950B
BOA Control Panel.xlsb 214KB
_config.yml 26B
LICENSE 1KB
VBA
ControlPanel.cls 153KB
README.md 3KB
共 6 条
- 1
资源评论
鈤TiAmo
- 粉丝: 20
- 资源: 4695
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功