We are a leading service provider of Business Intelligence Analytics , reports and dashboard development and cloud support

Peoplesoft crystal reports, dashboards, reports

Reports & Dashboards

Support Services



Reports and Dashboard Development Service

New reports and Dashboard development

We are a leading Service Provider of Business Intelligence (BI) analytical reports and dashboard development and support. We have over 10 years of experience in Planning, Design, Development, Tuning and Support of variety of Business Intelligence tools and reporting solutions. We have in-depth real world expertise in industry leading reporting tools such as OBIEE / OAC (Oracle Analytics Cloud), Cognos, Jasper, QuickSight (Amazon) and Tableau among others.

Project Scope Call
Reports & Dashboard requirement Doc For Approval
Reports Development
Functionality Testing
Data Testing
Client Review
Client Site Deployment
Training, Documentation and Support for 6 months.
Divider Divider

Delivering new OBIEE / OAC (Oracle Analytics Cloud) reports and Dashboards

  • DataTerrain will work closely with business users to understand reporting requirements and follow review / approve processes to derive requirements of new reports and Dashboards.
  • We bring in years of OBIEE / OAC development experience and best practices to build new reports and dashboard to specifications.
  • We provide free support for every single report for a period of one year. We deliver for today and tomorrow.
  • Our onshore/offshore development model enables swift, reliable and cost effective delivery of new reports and dashboards.
  • DataTerrain will perform consistent and reliable quality testing and managing the controlled transition from development to UAT to Production.
  • We recommend and help customers in necessary upgrade or patch requirements for best performance of new reports and dashboard along with extensive documentation.

Delivering Transition automation for PeopleSoft Crystal reports to OBIEE / OAC Reports

PeopleSoft Crystal Reports is nearing end of life and is no longer supported with People tools 8.5.5 and future releases. DataTerrain helps you convert the Crystal reports to BI Publisher which integrates existing PeopleSoft data reporting tools such as PS/Query with familiar tools such as Microsoft Word, and Excel.

BI Publisher provides the following advantages:

  • Allows PeopleSoft users to create customer-ready HTML and PDF documents, such as financial statements, contracts, invoices, and purchase orders utilizing multiple formatting and design options
  • Supports E-Text template which is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI)
  • Merges your design template files with the report data to create a variety of outputs(HTML/Excel/PDF/CSV/XML/MS-Word) to meet a variety of business needs in many languages.

DataTerrain uses an automation engine to convert Crystal report to a BI Publisher which helps in drastically reducing the timeline of transition. Customer needs to provide the .rpt files along with the access to PeopleSoft environment. The PSQuery is modified along with the RTF template and the files are converted to BI Publisher, which can be deployed in PeopleSoft platform.

Delivering OBIEE / OAC Reports from Discoverer reports

Oracle Discoverer was a popular reporting tool for Oracle EBS. However it is no longer a supported product and as a result Oracle will provide no further product enhancements or fix for any software problems. Oracle recommends customers to move to the latest and greatest in BI Technology OBIEE / OAC . OBIEE / OAC also supports the integration with Oracle EBS to use the security and SSO set up in the Oracle EBS.

OBIEE / OAC offers the following advantages:

  • Easy to use, with a lot of visualizations and user friendly GUI.
  • Not Oracle database dependent for meta data and reports, and supports the connectivity to a wide range of data source.
  • Supports better report designing in the form of graphs, charts and forms.
  • Scheduler handles the report delivery in a better way and give appropriate alerts
  • Oracle BI Server handles the query more efficiently and thus the performance is better with OBIEE / OAC

To preserve years of design efforts and make the transition faster DataTerrain built an unique automation tool. As the first step Metadata Transition tool builds and validates Oracle Business Intelligence repository (RPD) from EUL. The Discoverer workbooks extract will then be processed by the transition tool to build the OBIEE / OAC Answers reports. The RPD and reports can be deployed seamlessly in the OBIEE  / OAC environment.

Delivering IBM Cognos 10 reports

  • A programmatic approach to designing and developing highly interactive dashboards that provide advanced functionality including dynamic filtering, score-carding, language translation and Google maps integration.
  • An agile and iterative methodology for end to end delivery of IBM Cognos BI systems.
  • Transition of legacy BI systems to IBM Cognos using Cognos’ Transition Roadmap.
  • Onsite/offshore delivery model provides high ROI.
  • Developing and Integrating Reports with 3rd party Portals and Google Maps.
  • Designing, Developing & Tuning Regular and Time Partitioned Cubes using Transformer and Framework Manager.
  • Cognos Performance Tuning including Report Query Tuning, Cache Usage and Model Tuning.
  • Experience with Cognos Report Transitoin and Upgrades/ Transitions from version 7 to version 8.

SNOWFLAKE and POWER BI Cloud Solutions

Building and maintaining an end to end analytics application is complex, challenging, and expensive at the best of times, not to mention littered with risks and unforeseen issues. With our new cloud data warehouse and analytics solutions, we take care of it for you, so you can focus on leveraging data assets to grow your business.

Please Call for a free session with us now to get started. You’ll be glad you did.

Snowflake Cloud Data Warehouse & Data Pipeline Solutions

Leveraging the world’s best cloud data warehouse technology and taking into account your customization and personalization requirements, our certified data engineers deliver an enterprise-class, cloud-ready, end to end data solution for your reporting, analytics, and data science needs.

PowerBI/Sisense Reporting & Analytics Solutions

Our world-class analytics engineers deliver high-end, professional reports, analytics, and dashboards solutions based on your critical requirements. We focus on a personalized approach that is tailored to your needs, so that your data assets deliver long term value.

Business Requirements & Project Planning Workshops

Our business-conscious consultants work directly with your stakeholders to assess your business needs and analytics requirements. Based on these productive sessions, we document a comprehensive path to achieve positive business outcomes and collaborate closely with your team to put the plan into motion, in a reasonable timeframe that balances time and costs.

Ongoing Maintenance & Support

Based on a streamlined and agile engagement model, we provide ongoing, as-needed support for your business intelligence applications. You can expect timely and effective services for all your ongoing needs.



BI Implementation and Maintenance Services

DataTerrain’s BI expert team has an extensive experience in implementing BI services which demands in depth technology knowledge with proven practices and transformation methodology that enables to deliver a wide range of BI implementation services.

With DataTerrain BI Implementation Services, organizations of all diverse domains achieve access to quick-to-deploy, cost-effective Business Intelligence offerings that can be customized to meet particular business goals. DataTerrain’s Business Intelligence Implementation Services spans a complete spectrum of BI ranging from data management, data warehousing, reporting and analytics. This helps us to make sure the organizations reap the maximum amount of value from their Business Intelligence investments.

BI Implementation Services includes:

  • BI Platforms and Package Implementation
  • Enterprise Data Warehouse design, build and maintain
  • Merging Data from different sources and ERP Application
  • Reporting and Analytics
  • Data Profiling and Cleansing
  • BI Dashboard Services
  • OBIEE / OAC (Oracle Analytics Cloud) Upgrade, Transition
  • BI Performance Tuning

Oracle BI Applications Services

  • Implementation of Pre-Packaged Analytics on Oracle E-Business Suite 11.5.9, 11.5.10, R12
  • ETL extensions and customizations using Informatica / ODI
  • Oracle BI Applications upgrade
  • Upgrade assessment and designing roadmap
  • Minimal down-time and high performance
  • Implementation and user training

HCM and Taleo cloud support

  • Oracle BI Applications upgrade from 7.9.x to Oracle BI Applications
  • Upgrade assessment and designing roadmap
  • End to end delivery of OBIA upgrade
  • Minimal down-time and high performance
  • Implementation and user training


DataTerrain Analytics design, development and maintenance

Our Business Intelligence services help organizations to predict, track and analyze valuable information from a huge amount of diverse data, which helps them to create short-term, medium-term, and long-term priorities and business objectives.

Customer Analytic Scope Call
Metadata Layer Development
Metadata Objects Mapping
Analytics Optimization
Analytics Testing
Analytics Deployments
Customer Training, Documentation and Support for 1 Year
Divider Divider

DataTerrain has a robust automation software engine that converts the metadata files across multiple BI platforms. We support the transition of metadata source files like SAP BO Universe, Discoverer EUL, Cognos FM, OBIEE RPD and Hyperion BRIO.

Once we receive the metadata files in the relevant format (like *.biar, *.univ, *.eex, *.bqy, *.cpf or *.rpd formats), the metadata would be converted to the respective destination formats, preserving the all joins and table structures. The converted metadata would be similar to the source metadata in functionality and support adhoc reports too.


Taleo reports builder beginner course enables you to develop native Reporting with BIP for Taleo Enterprise. It gives you hands-on experience in creating, modifying, and sharing both standard and custom reports. It allows you to turn on the capabilities of BI Publisher and Taleo Performance. Taleo Advanced reports builder course gives you deeper understanding of reporting functionality to create more detailed agents, key performance indicators, scorecards, dashboards briefing books and more.

Oracle HCM Cloud foundation Business Intelligence analytics and reports building course trains you for authoring analysis and how to create, modify and share analyses, graphs and dashboards. We will provide deeper knowledge on how to build reports in Payroll, Workers compensation, Tax and other modules in HCM.

All our courses are simple to understand, instructor-led and highly customizable for your needs.