Scroll Top

Lire cet article en Français france-drapeau

Before migrating
SAP BusinessObjects

(to a new server or a new version)


Since 2001, my husband and I have moved 5 times. Every time we moved, we also moved a large crate that was about 4 feet long and 2 feet tall. It was really heavy and had a lock on it. I had no idea what was in the crate, my husband said it contained “important things” he wanted to save. So we paid to move this large crate 5 times, and stored it at each house. It was kept in the basement or garage in each house and was never opened. I never asked any other questions about it until the last move when it ended up on the floor of the office. It was in the way and I wanted it gone! My husband admitted he had lost the key to the lock, I think he had also forgotten what was inside the crate. After a week of me complaining about it, he cut the lock and opened the crate. It was full of his college text books…over 20 years old…they were obsolete! 

You may be wondering why I am sharing this story and what this has to do with migrating your Business Objects content.  Moving this crate reminds me of the Business Objects upgrades I have done over the years. We migrated content from one version of Business Objects to another and had no idea whether we were moving unused, obsolete content. We didn’t have any insight into what was used and couldn’t risk removing reports or objects that were needed by the end users, so we moved everything. This is exactly what we were doing moving a locked crate full of old college text books from house to house. If I had known what was inside I would have recycled or donated them before the first move!

I was a Business Objects Administrator for 10 years for one client. During that time, I upgraded from every version of Business Objects starting with version 5.  The environment was heavy on ad hoc usage, so the number of reports in the users’ personal folders grew over time. This of course increased the size of the repository and increased the migration time. Each time we upgraded to a new version of Business Objects, we tried to come up with different strategies to get the users to clean up their personal folders. It was very challenging!

During a move, you never want to pack everything, moving is the perfect time to purge! You should do the same when you migrate from one version of Business Objects to another, or move from one server to another, even from on-premise to the cloud. These are all migrations that will cost more and take longer based on the amount of content you have.  Migrations are the perfect time to purge!

Our recommended 10 steps to fast track your migration is explained in detail here


This post is focused on the steps involving clean up (step 3).

Do you keep migrating all of your BOBJ content from one version or one server to another?  Are you spending time and resources on migrating content that isn’t used, obsolete or redundant?  Are you constantly adding space to your servers as your environments grow? Do you have any insight into your content? 

Do you know the answers to any of these questions?

  • Which reports haven’t been run in the past year, or the past 2 years? 
  • Which objects in your universes aren’t used in any reports in your environment? Or, used in reports that are themselves, never used?
  • What is taking up the majority of the space in the CMS? Is it inbox documents? Instances? Public folders? or personal folders?  

Wouldn’t it be great to know what is in your environment and to have definitive information about what should be retained? Being able to eliminate unused and obsolete content prior to a migration would result in faster migration times and a reduction in the storage needed on the BOE server. Business Objects auditor can provide some useful information, however, auditing will only provide data on content that has been accessed. If a report has never been run, or an object has never been used, it will not appear on any auditing report.

With the 360Suite you can gain insight into your SAP Business Objects environments. It provides you with a wealth of information that will assist you with answering questions you have about your environments. Regarding the auditing limit above, 360Suite extracts data from the CMS and Auditor, providing the missing link by combining that data into one easy to report on database schema. 360Suite for Business Objects metadata includes 4 universes and over 70 pre-built Webi reports to get you started with your analysis.  You have the ability to create your own custom reports as well. You will wonder how you ever did a migration without this information!


Benefits of 360Suite:

  • Gain insight into what content is unused (universe objects, reports, users, etc.). 
  • Compare several environments and versions throughout the migration.
  • Analyze and clean UNV universes before converting them to UNX.
  • Optimize report structures before converting them by determining which objects and variables aren’t used on the reports. 
  • Determine which documents contain certain objects, specific SQL or report variables.
  • Track duplicate reports to pinpoint documents that have been copied to different folders across the environment. 
  • Compare security between versions to determine what changed during the migration.
  • Document the content of your environment; documents, universes and security.
  • And much more…

The unknown will prevent you from lowering the costs associated with storage, resources and migration time.  You no longer have to go in blind when doing SAP Business Objects migrations, 360Suite provides insight into your environment and allows you to optimize your migrations.

Getting to know what content is used or not used to determine what needs to be migrated and archived is just one of many steps that you can undertake to succeed efficiently in your migration project. To make your life easier, we have gathered all those different steps into our ultimate migration checklist that you can download here.


Related Posts

Leave a comment