Many companies seeking to reap the benefits that Business Intelligence Tools can offer make a costly mistake in believing that the tools they select are solutions in themselves. Many BI initiatives start out as a tool selection endeavor and never get past the selection and installation of the tools. Link Technology Group offers BI solutions that recognize the importance of intelligent data modeling and end-user needs and expectations.

Innovative BI Template for Peoplesoft Reporting
Have you ever wanted to get a time-series report of employee headcount and turnover from your Peoplesoft Human Resources data? Unless you can settle for the standard reports that come with the package, it is not likely to happen. Ad-hoc reporting on historical data is notoriously troublesome (Peoplesoft seems to prefer you keep your gaze fixed on the current state of things.) This difficulty is mainly due to database design decisions slanted towards efficiency and convenience in data administration. Link Technology Group understands that all IT solutions start with the data, and that is why we can offer a BI solution for HRMS that combines completeness, flexibility, and performance.

Solution Defined
Our BI Template for Peoplesoft HRMS starts with an Oracle based Datamart that is designed to support complete database reporting. That means all the data and all the history. With advanced key structures and indexing, this reporting convenience and completeness does not sacrifice performance. The template enlists the services of two “Best of Breed” BI products, Informatica and Business Objects. These products are widely known and contribute an ease of maintenance and administration to the solution. This combination of technologies also offers advantages that no other HRMS solution can match.

Unique Perspectives
	• Time Series Reporting combining point-in-time with interval based facts. • Ability to mix historical criteria with current criteria in filters. • Year over Year reporting.
Peoplesoft Security Preserved and Enhanced
	Not only is all Peoplesoft row-level security preserved, but is implemented in two ways. This facilitates historical authorizations that are accurate and transparent.
Intelligent Data Synchronization - Don’t build an ODS
	The Template implements Oracle change tracking capabilities in tandem with Informatica ETL allowing a direct link from your transactional database to the Datamart. There is no need for hauling huge amounts of data around. Keep things up-to-date even hourly!
Stupendous Performance
	Get even the most involved time-series reports back in seconds.
Complete Data Resource
	The database is designed as a complete HRMS data resource. Use it to drive data to Employee Portals and for building vehicles for Performance Scorecard vehicles.