Category: BI Publisher

Steps to convert BI Analytics from PeopleSoft Crystal Reports to Oracle BI Publisher Reports

Since PeopleSoft Crystal Reports is now nearing end-of-life, users need to convert to advanced reporting platforms. Oracle BI Publisher is a reporting solution which facilitates creation, customization, and delivery of reports much more quickly than traditional reporting tools. These are the high level steps to migrate Crystal Reports to Oracle PeopleSoft BI Publisher: Analyze all the crystal reports and categorize them by Data, Complexity, Report size and usage Group for similar Queries/Table, Layout, Prompts, Filter Conditions to rationalize and reduce the number of reports Prioritize the reports for conversion Modify the PS Query as per the filter conditions and joins for similar report and create a new query. Get the latest PS Query xml from PeopleSoft environment and build the RTF template. Create the RTF template based on the Crystal Report i.e., Structure, Suppress conditions, Conditional Styles, Formatting for Numeric Values, Alignments of data. Validate report with multiple test case scenarios for the uploaded PS Query XML. Upload the report into PeopleSoft Application with the new PS Query to BI template for business validation. At DataTerrain we use our Automation Tool to automate many of the above steps which helps in faster, consistent and seamless conversion from Crystal to BI […]

Read More +

DataTerrain Automation is Your Premiere Source For Automated Report Conversion

How DataTerrain Automation Makes Automated Report Conversion Easy Automated report conversion is one of the greatest innovations that have helped in the management of data. A team of our dedicated engineers worked to develop DataTerrain Automation which is a highly effective BI tool conversion system. Through it, we are able to transfer and convert reports from the primary source as per the instructions from our customers. This process is necessary when one needs to upgrade to new technology for the digital age.

Read More +