Requirement – Converting Analysis for office workbook based of netweaver platform to use BOBJ platform.
By default, converting Bex workbook into analysis office uses netweaver connection, which means the workbook needs to be saved to ABAP server, limited broadcasting functionality and also it will be specific to one BW server ( For instance, if you want to have workbook with combined data from BW and hana in multiple tabs it is not possible)
This post explains the step by step procedure on how to change the bex workbook to use BOBJ BICS connection
First, converting the Bex workbook
Launch Analysis office. (TCODE RSAAOE) , Click File>Analysis>Convert Bex workbook
Select the workbook to be converted.
Click Ok, it automatically converts the workbook into AAO workbook
Save the work book ( save to BOBJ platform)
Second, Accessing the workbook
Open the workbook from BOBJ Platform
try to refresh the work book
The workbook will prompt for BW credentials, even though single sign on is activated in BOBJ. ( please sign in manually)
Third, Converting the workbook
Open the work book
Refresh by manually entering the BW password
Click on components in design panel and click edit data source name
The olap connection box will pop-up ( as you already authenticated to BOBJ platform in Part 2 , step 1)
Select the Desired OLAP BICS connection
Select the the same bex query the workbook is using.
Now the workbook is successfully changed, you can now refresh the workbook via BOCS connection and also schedule the workbook through BOBJ Scheduler ( 4.1 sp4 and higher, need AAO add-on to be installed on server)
– Karthik Addula