appBI is a pre built Business Intelligence for Oracle E-Business Suite (EBS), consisting of ready to use dashboards, data cubes and data pumps. appBI Business Intelligence for EBS incorporates best of class methodologies, processes, architectures and technologies to transform raw operational data into meaningful and useful dashboard information to enable more effective strategic, tactical, and operational insights and decision-making. This BI for Oracle EBS is a good start, offering CEOs, CFOs, Marketing Directors, Planners a useful set of dashboards for EBS (performance indicators) covering nearly 90% of their needs.

Provide your business leaders with the business performance information they need quickly and easily.
“Drill down” into detailed information without impacting the performance of your production systems.
Pre-defined executive and management dashboards.
“Plug and play” with Oracle eBS R12/11i.
Non-technical business users can create new or modify existing dashboards on their own.

The data pump (appEXTRACT) connects to Oracle eBS or any other database, extracts and loads the appBI Schema. The end user selects data elements to be loaded into the appBI Schema and the frequency that the data will be refreshed.

The Oracle based schema(Data Mart for EBS) is pre-configured to hold enterprise-wide data for Finance, Supply Chain Management, Sales & Marketing, Customer Service and Operations. Though the Data Cubes for EBS is very comprehensive, it can still easily be extended to meet any customer specific data needs.

The presentation layer is built using Oracle OBIEE. An option to use IBM Cognos as presentation layer is also available.

Management decisions are facilitated by the aggregation of transaction data into performance metrics, trends, forecasts and patterns of behavior. appBI presents executives with information in ways that facilitate decisions both vertically (i.e. within the Supply Chain, Sales or Finance) and horizontally across the enterprise.

appBI’s robust technology platform for business intelligence helps our customers start quickly, deliver immediate results and scales as the business needs evolve.