Jaros Analytics for Oracle's E-Business Suite

Jaros Technologies Corporation

Jaros is a comprehensive business intelligence solution that enables business reporting for customers who run Oracle's E-Business Suite.

Jaros Analytics unlocks Oracle EBS data for the business. It is a unique hybrid solution that makes operational data available in near real time using the operational data store. It also facilitates strategic decision-making and analysis using the solution’s data marts.

The solution provides access to detailed data from Oracle E-Business Suite modules including Financials, Working Capital, Orders Management, Procurement, iProcurement, Inventory, Cost, Discrete Manufacturing, Process Manufacturing, Services and Contracts, HR, Payroll, Oracle Learning Module, and more.

Jaros Analytics is tightly integrated with IBM Cognos 8 BI, providing a dynamically generated Framework Manager that can be used immediately for report development.

Benefits

A key benefit of Jaros Analytics is the ability to provide right time information: near real time, nightly, monthly, quarterly, or yearly data. This supports all operational and strategic reporting needs.

It provides detailed and summary information in areas such as:

General ledger and sub ledger
Revenue and margins
Open receivables and payables
Cash management and receipts
Cost of Goods Sold
Inventory value and inventory turns
AR and AP invoices
PO requisitions, orders, and receipts
Vendor and customer performance

It is a fully documented solution that uses an active metadata repository with a Web-based help system. The built-in ETL product is consistently rated as one of most scalable by expert analysts firms. It further supports implementations without open-ended consulting engagements.

Features

There are six major components of the solution:

An IBM Cognos 8 reporting layer with a dynamically built Framework Manager model for instant reporting capabilities.
Industry-specific data models including an operational data store that provides near real-time operational information and a consolidated set of data marts that enable enterprise reporting.
Pre-built ETL mappings that extract data from Oracle EBS and legacy systems to provide packaged analytics built into the Jaros data model.
An Active Meta Data Repository (AMDR) that fully defines the analytics and provides a framework for extending and growing the solution. It generates metadata layers for reporting tools such as the Framework Manager, and provides help systems that are synchronized with the supported metadata layers.
Software that installs the product and allows customers to apply maintenance patches and enhancements.
A pre-built operational framework and execution workflow engine that executes ETL mappings in the proper order to load the operational data store and data models.

Architecture

Our solution is tightly integrated with IBM Cognos 8 BI. We dynamically create the Framework Manager layer using our AMDR.

Availability

For more details, visit our website: www.jarostech.com