Bluefin performed a BW 7.5 on HANA migration and you’ll never guess what happened

18 September 2017

Cal Loudon

Cal Loudon

Consultant

Tips and tricks for your next HANA migration that even a millennial will understand.

You’re back again? Really?

First you let me ramble about what is SAP BW 7.5, then you returned so I could go on and on about the developer features that are included in the last version of BW on HANA (before BW/4HANA). And now you’ve fallen trap to clicking on yet another post from me about BW 7.5. Haven’t you had enough? No? Good, because you’re in luck.

We at Bluefin have completed a successful migration from BW 7.x on Oracle to BW on HANA 7.5 for one of our great clients. What’s more, we live-tweeted the Production migration process to give you, dear reader, a chance to gain some key insights into a real BW on HANA migration and hopefully get some useful take aways for when you do it yourself.  If you want to take a deeper dive into how to make your HANA migration a success, check out this awesome post by our BASIS expert and database genius Matt Matt.

Get your process perfect with practice

They say it takes 10,000 hours to master a skill. That’s probably a little extreme for our needs, but practice definitely makes perfect and it’s for that reason that Production was the fifth environment we upgraded. With each system we upgraded and migrated – from Sandbox all the way through to Pre-Prod – we followed, optimized and perfected the upgrade runbook to the letter to ensure we set ourselves up for the best chance at success. Because that’s what we do.

Getting your perfect process nailed down is a matter of repetition and that means conducting the same pre-tasks, migration activities, post-tasks and tests as many times as necessary. This will help to ensure that you’re comfortable and ready when the big day rolls around.

Make sure you keep your house in order

Always relevant but especially important prior to and during an upgrade and / or migration, it’s essential that BW housekeeping is kept in check. While it’s part of the project and a step within the HANA Migration cockpit (ZBW_HANA_MIGRATION_COCKPIT), it’s never a bad idea to make sure your system housekeeping, both from a BW and BASIS perspective, is kept under control.

The future is now and 3.x isn’t coming with us

You’re not still using that antiquated 3.x technology anymore, right? Good. Because as of BW 7.5; it’s obsolete and you can no longer maintain or upgrade these objects. If you’re just asking for a friend, then make sure you tell them to make use of the available conversion wizards to help bring their content up to 7.x.

Hot tip: SAPGUI transaction RSB4HTRF enable us to further convert our 7.x objects to the new HANA-optimized objects (Advanced DSOs and Composite Providers. This is mandatory for when you’re ready to move to BW/4HANA.

No cowboys around here

I’m repeating myself here but it’s for good reason, it’s that important. The runbook I mentioned earlier is the definitive task list. Just because someone has a good idea to do something better, faster or more elegantly – Production is NOT the time for changes. You’ve got this far trusting the process, don’t mess it up now.

Feed the troops!

When it comes time to the final go-live weekend, you want to be ready for the worst and that can include very long hours for the team – especially your crucial BASIS guys or gals. Our team helped to put the local Starbucks’ kids through college and we definitely had some spin class hours to make up the next week but no one was getting hangry and distracted on our watch.

Slow and steady wins the race

There are many tasks to complete during the Go-Live process and yes, many hands make light work, but this doesn’t mean it should be a free-for-all. You’ve only got so many available processes and you don’t want users and tasks conflicting with one another. Make sure that your BASIS and project leads are simpatico and coordinated so that each required step finishes before the next begins. There’s no need to rush things and face unnecessary risk to save a few minutes. The previous environment migrations proved that this is a process that will take some time and even if things are taking a bit longer, keep calm and stick to the plan.

Don’t forget to take some time to smell the roses

You made it! It took many months of planning and testing and replanning and lots of hard work but you’ve finally got your SAP BW system upgraded to version 7.5. Well done! Now take your team out for some drinks or cake or bowling and celebrate, you’ve earned it. Looking at how you’re going to leverage all the power which is now at your fingertips can wait until Monday when everyone’s had a chance to catch up on sleep. Don’t worry, the business is going to be your best friend once they see the benefits of your hard work.

Okay, I’m finally done writing about SAP BW 7.5, promise! Feel free to reach out to me (or one of my skilled Bluefin compatriots) if you have questions but I think it’s time I write about something different. Will it be a deep dive into hybrid modelling techniques in the next-gen EDW system SAP BW/4HANA, a look at SAP Leonardo perhaps, will it be a ranking of the top 10 cutest dog breeds (spoiler alert: it’s French Bulldogs) or something else entirely? You’re just going to have stay tuned to find out.

About the author

Cal Loudon

Consultant