Skip to Content
Author's profile photo Former Member

Migration to Analysis for Office / BEx 70

Hello everyone,

one of the big hurdles that customers face before converting from BEx Workbooks to Analysis Workbooks is the effort needed to migrate many workbooks as the standard options only allow us to go one workbook at a time. All the repetitive tasks for each one of the converted Workbook also increases the hurdle to go for Analysis for Office. SAP Consulting has now come up with automatic tools to reduce the manual effort in migration projects.

One of the tools allows to to migrate all BEx Workbooks in specific roles to Analysis Workbooks:

AO_Roles.png

You can also configure the tool to do repetitive tasks, like saving all workbooks with a specific Prefix/Suffix, saving the Workbook to the original role or to another one, or also convert the BEx Navigation Pane to Analysis formulas:

AO2.png

I believe with all this settings the migration is less error prone and of course it reduces the amount of manual effort involved in a migration project. Why do I say “reduce” and not “eliminate”? Well because there can be very complex workbooks with VBA Code for example that require manual intervention.

Other areas of mass migration include the BEx Query Migration, which contains an application log and makes backups of your 3.5 queries, which is very handy in order to recognize problematic queries:

query2.JPG

And the BEx Workbook (from 3.5 to 7.X) migration, which also has a nice a detailed log of what was done:

WB.JPG

This tools are very interesting for customers that are still on BEx 3.5 because starting with SAP NetWeaver BW 7.4, the BEx 3.5 tools will not be supported any more.

Thanks for reading.

Victor

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Great...how do we access them?

      do we need to engage and pay SAP CONSULTING FOR licenses ?

      thanks for sharing..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Peter,

      thanks for commenting.

      Yes, you would need to engage with SAP Consulting.

      Best regards,

      Victor

      Author's profile photo Former Member
      Former Member

      Hi Victor,

      Thanks for the information.Can you please let me know where we can download this tool.

      Please provide the download location link with us.

      Regards

      Raghavendra

      Author's profile photo Former Member
      Former Member

      We are planning to conver 7.4 to Analysis 2.0. Will this tool help?

      Any documents would help us.

      Author's profile photo Former Member
      Former Member

      Hi

      Would like to understand what do you mean by

      No conversion. You can use the design panel in Analysis.

      Do you have a Example of how it is converted and what is the Look and Feel of it??

      Your reply will be greatly appreciated.

      Regards

       

      Author's profile photo Bhargav Malsani
      Bhargav Malsani

      Hi

      A newer version of this tool to convert BEx 7.x workbooks to AO 2.x. is available please refer to the link for more details - https://blogs.sap.com/2017/07/12/automated-mass-migrationconvertion-of-bex-workbook-to-ao-2.x/

       

      Regards,

      Bhargav