We’re seeing this more and more: as Oracle’s OBIEE platform gains steam, many organizations are making the move to convert existing reports from Crystal, Actuate or Oracle Reports to BI Publisher. Report conversion can be a daunting task, not necessarily from the technology move, but moreso from simply understanding, cataloging and consolidating the current collection of reports. Over time, many reports are modified, added, and personalized, and it is very easy to lose track of what you have — and more importantly, what is valuable.
Oracle has a very good white paper which provides all sorts of great information regarding the conversion process. Probably not unlike you, when I need to know something that I don’t necessarily have experience with, I often look to white papers and red papers to give me that initial push — and often I am disappointed. I need to know a strategy, I need to know what type of skills I need and how much effort it will take. In so many cases, this information is what is most obviously missing. Well, this white paper outlines a strategy, outlines key considerations, provides several company examples and outlines the resources that are required for success. I highly recommend it to all of my clients. Entitled Planning to Covert to BI Publisher, you can check it out here (PDF link; you’ll need your Oracle login and password).
Here are few of the key elements I took away from the white paper:
- Prior to any report conversion activity, you must evaluate your current catalog of reports. Determine what reports are being used, what reports are important and what reports should be carried over. Don’t forget to evaluate the new technology and capabilities of Oracle BI Publisher. Old technologies may propagate the need for multiple reports because of only slight variations in requirements. There is an opportunity to reduce the overall number of reports simply based upon the capabilities of BI Publisher. Also, challenge the end users on the needs of the reports. If a report has not been run in a long time, is it really necessary? Remember, end users can also create their own reports which may impact how many reports must be converted.
- You can categorize reports:
- By data
- By complexity
- By size