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.