Setup Automation Framework and changing the source of Web Intelligence report using Automation Framework

Below blog explains how to setup AFW (Automation Framework) and how to use some of the features with in AFW (Automation Framework). The main reason I started this blog, put all the content in one place , so new comers will be able to follow this blog to setup the AFW instead of searching through various documents or various posts. Hope this blog will help.

Why do I need to install AFW (Automation Framework)?

Automation Framework will help to automate some of the complex and repetitive BI tasks. This is the new tool introduced in BI 4.2 SP5 onwards which I found out this is more useful for repointing the Web Intelligence reports from UNV to UNX universes. Without this tool, we could not have done this change much easily. We can use standard templates as well as we can build custom templates using SDK.

How to setup Automation Framework in windows and change the source of the web intelligence report using AFW (Automation Framework).

If you are upgrading the environment from 4.x to 4.2 SP5, Automation framework will not be installed by default. After installing the 4.2 SP5, we need to modify the installer to add Automation framework.

Running the BI agent Service and Automation Framework from CCM:

To understand the Automation framework architecture, please refer the below link for BI Administration Console Guide

https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/4.2.5/en-US

Login to Business objects server. Open command prompt in admin mode.

1. Set JAVA_HOME=<INSTALL_DIR>\SAP Business Objects Enterprise XI 4.0\Winx64_64\SAPJVM
2. CD <INSTALL_DIR>\AdminConsole\MessagingQueueBroker\bin\
3. Startbroker.bat.
4. Make sure the Apache ActiveMQ is running
5. Open CCM, Start Automation Framework Service
6. And Start BI agent service

Configure Enterprise Authentication for Automation Framework:

1. Login to CMC, Authentication -> Double Click on “Authentication”
2. In the Trusted Authentication section, make sure “Trusted Authentication” is enabled.
3. Choose “New Shared Secret”. Choose “Download Shared Secret” . Select “update”
4. Save the Shared Secret Key in the following Directory. <Install_dir>\AdminConsole\Automation Framework\Custom\cms_certificate

Accessing the Automation Framework URL:

http://<BOEserver>:8080/BOE/BIAdminConsole

How to add default templates if they are missing using Fresh Install or Modify install:

1. When you login to AdminConsole , if you noticed Default templates are missing when you select new scenario, follow below steps to recover the Templates

To create those default templates manually through jar file execution by providing valid arguments.

Ensure JAVA Home path is set.

In CMC -> Application -> RESTful Web Service -> Properties provide valid Access URL and ensure that it is accessible from the machine where “Automation Framework” feature is installed.

Login to the machine where Automation Framework” feature is installed.

Open Command Prompt or Terminal and execute the below commands :

On windows:

set JAVA_HOME={BOE Installed Dir}\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\jre

set PATH=%JAVA_HOME%\bin;%PATH%

cd {BOE Installed Dir}\SAP BusinessObjects Enterprise XI 4.0\java\lib

Execute the jar with 5 parameters :

CMS System Name

User name (a user with administrator rights)

Password

Authentication type

Time Delay (In Milliseconds)

Example: java -jar com.sap.bong.default.objects.jar myBoeCMS administrator password secEnterprise 0

Once you run the above jar, login to Automation Framework, make sure Default templates appear in the scenario section.

How to change the source of Web Intelligence report from UNV to UNX:

1. Login to Admin Console.
2. Click on “Landscape Management” to add Business Objects Platform
3. Add System name, Access URL as “http://<Tomcat server>:8080/biprws or “http://<BOE Server>:6405/biprws , it is the same URL from CMC ->Applications -> Restful webservice URL
4. Now click on home button to go back to main page. Click on “Automation Framework “ button to create a scenario.
5. Click on Scenario, and + sign on the right top corner to add new scenario.
6. On the workflow templates, Select “Standard “ templates.
7. Drag “Logon”, Change web Intelligence source, Refresh Document, Logout icons to the right to create a scenario and save the scenario.
8. Click on “Workflow template”, add the scenario from the previous step.
9. Logon – Select the Landscape you want to logon to, Change Webi Intelligence Source – Select the webi document want to change it to,, Universe mapping -> select the UNV universe and UNX universe. And run the Task. It should change the source of the webi report from UNV to UNX.

Note: From SP5, there is no need to use restful webservice URL link to WACS server, you can connect to Tomcat server, since Restful service is part of Tomcat.

Refer the SAP KB article: 2585147