Home / Business Intelligence / Lessons on BI 4 Migration Testing from Pi Day

Lessons on BI 4 Migration Testing from Pi Day

Last week I was visiting a large computer processor manufacturer where we ended up in the building cafeteria which was packed with people eating apple pie. The pie was being served and offered for free because that day was “Pi Day” in celebration of the number Pi which is 3.1415926535897932 … etc.. The 3.14 translates into March 14 and this day is celebrated by math and computer enthusiasts and geeks everywhere. March 14 also happens to be Albert Einstein’s birthday.

However, this company took it a stage further by only starting to serve the pie at precisely 1:59:26 pm to match the next six digits of Pi (3.1415926. …).

I was impressed. This got me thinking about discussions I had earlier that day with another company regarding their BI 4.1 migration testing. It revolved around whether to test all the reports or just a sample of the reports to be migrated and the best way to test them.

There are a lot of changes between BusinessObjects XI 3.1 and BI 4.1 that could potentially affect queries and reports both from a layout and calculation perspective so it is advisable to validate all of them. This can be very time consuming if the report comparison is being performed manually and so tools to perform an electronic comparison could be employed to help speed up the process.

While some people may just check a sample set of reports they consider representative of all the reports or may just check certain totals on the reports, this is really only a partial validation. It is akin to accepting Pi as 3 whereas testing all the reports is more like accepting Pi as 3.142.

In addition, not all BusinessObjects reports are just one-dimensional static reports. Many have drill downs built into them, which should also be tested. Some are exported to other formats like PDF and Excel which should also be validated.  There are also possibly universes, dashboards, explorer information spaces, schedules and publications. When you include all these additional aspects and content in your testing, you are much closer to seeing Pi as 3.14215926!

Of course, this should also encourage you to carefully audit your existing BusinessObjects repository, and only migrate what is actually in use and needs to be migrated. Auditing provides the best results when it has collected data over an extended period of time so be sure that you have it turned on. Look for content that has not been used for more than 12 months and question if it really needs to be migrated.

Also, check that users do not have local content on their desktops that needs to be migrated and request them to move it to the central repository.

Migration testing is often underestimated yet it is the most crucial phase to a successful migration. The good news is that if you plan and execute it properly, it will be as “easy as Pi!”

About Paul

Paul Grill, Co-Founder and CEO of Infosol Inc., is an information technology guru with more than 40 years’ experience in the IT industry. Recognized as an industry expert, Paul’s vision is to collaborate and develop long-term global relationships, resulting in the successful implementation of business intelligence solutions. Paul believes a company’s success with Business Intelligence is a combination of data and people’s insights and actions. He believes in the coexistence of technologies. With a strong portfolio of clients ranging from fortune 50 companies, start-ups, and middle market, Paul takes pride in his ability to deliver positive transformations impacting company’s productivity and profitability through the application of business intelligence. He is often heard saying that “data holds amazing nuggets that can be used to create limitless BI solutions that make a difference in people’s lives”. Throughout Paul’s career, he has been a speaker, lecturer, and writer sharing his passion for Information Technology and Business Intelligence. On a personal note, Paul is an avid runner, Tai Chi practitioner, and youth soccer coach. Paul’s curiosity for knowledge expands beyond technology with a passion for Ancient Egyptology and Gorillas.

Check Also

Eating the Elephant of Data Strategy Feature Image

Eating the Elephant of Data Strategy

I have a had a lot of conversations about data strategy this year. With both ...


  1. Was interesting to read the way you tied Apple Pie to Pi to the decimal points to illustrate the levels within testing! I am more from the SAP Business Warehouse side and wondering if your company does any work in the SAP BW & HANA space while enabling BI reporting?

  2. Hi Naresh,

    Thank you for your comment.

    We do help with BW and reporting with BI. I would be happy to answer any questions you may have offline.