Posts Tagged ‘crystal reports’

PeopleTools 8.55 – The Sunset of Crystal Reports and Enhancements to BI Publisher

Posted by

Sunset Crystal Reports Enhancement of BI Publisher

For several years, Oracle has been indicating that Crystal Reports was a technology of the past and has encouraged customers to take advantage of BI Publisher. Well that day has come! PeopleTools 8.55 will not support the use of Crystal Reports. Don’t be alarmed, the capabilities now available to you will make you wish you never had a three-ring binder full of static, stale, snapshot reports. The tools (Pivot Grids, Simplified Analytics) that will replace many of your old reports will provide you with fresh, actionable data to make better decisions to run your business. For those situations where you need static data, month-end for example, BI Publisher is your tool of choice.

Here are some of the new features that Oracle has built into BI Publisher in PeopleTools 8.55.

  • PeopleTools has created a BI Publisher report user role (XMLP Report User) that allows users to schedule and run reports. Users with this role can also open a majority of BI Publisher report definitions in read-only mode.
  • Report developers can delete report definitions from the results grid of the report definition search page.
  • PeopleTools delivers a copy report definition page that simplifies report development by enabling report developers to copy report definitions.
  • BI Publisher for PeopleSoft now enables you to develop PDF reports that users can edit and then submit the changes to be saved in a database. The submittable PDF report functionality is available for delivered self-service reports and for customer-created reports.
  • Beginning in PeopleTools 8.55 you can change the data source of an existing report definition. When a user clicks the link the data source type and data source ID field become editable. An option to cancel data source changes is available, allowing a report developer to revert back to initial state.
  • PeopleTools enables you to include attachments from external sources with BI Publisher PDF report output. The source attachments are converted to PDF format and then merged with the main report. The report is then displayed to the end users or delivered to report manager. To convert attachments to PDF output, BI Publisher utilizes Oracle’s Outside In Technology (OIT), a product that enables the transformation and control of more than 600 file formats, including documents from office suites, specialty formats, and legacy files.
  • You can distribute reports using email to recipients that do not have PeopleSoft user profiles. This feature enables you to distribute BI Publisher reports to external users whose email addresses are stored in the database, file server, or other location.

For questions regarding your upgrade to PeopleTools 8.55, taking advantage of the new features, or help with creating your new reports and analytics, please reach out to us.

Converting Your Reporting to Oracle BI Publisher

Posted by

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:

  1.  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.
  2. You can categorize reports:
      • By data
      • By complexity
      • By size
  3. Understand that there are conversion tools to help with the move to BI publisher.  Certainly manual conversion is an option, but if any time can be saved with the conversion tools, that option should be explored.  I have not used these conversion tools so I do not have direct experience as to how well they work if they convert 100% or 50%. I would recommend you take a sample of low, medium and high complexity reports and evaluate the success rate of the conversion tools when determining your approach. If you do this, I’d be interested in your results. Drop me an email.
  4. The white paper provides some customer examples and general rules of thumb on the level of effort.  From the white paper: “A general thumb rule would be 3 man days for manually converting a simple to medium complex report and 5 man days for converting a highly complex report. The time taken will reduce over a period of time with experience in conversion. Using the Conversion Tools, the conversion time would be reduced tremendously and may require few hours to 1 man day for converting a simple to medium complex report. For converting a medium to highly complex report, the effort may vary between 2 – 3 days. The time taken will reduce over a period of time with experience in conversion.”
Report conversion is often a daunting task that prevents organizations from moving to a more integrated/streamlined reporting option from what they are using now. That doesn’t have to be the case. If you want to explore this option more — or even just pick my brain about it — I’m always happy to chat. Let me know.


More links:

MIPRO Consulting main website.

MIPRO on Twitter and LinkedIn.

About this blog.