Oracle Business Intelligence

SmartERP Oracle BI Practice offers design and development services across most information management platforms: data warehouse & application design, ETL development, reports and dashboards, upgrades and conversions. We have a sharp focus on ODI, OBIEE (including prebuilt analytics) and Hyperion.

Oracle Business Intelligence Foundation Suite is a complete, open and architecturally unified business intelligence solution for the enterprise that delivers best-in-class capabilities for reporting, ad hoc query and analysis, OLAP, dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions and hierarchies, are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, ERP and CRP applications, mobile devices, and MS Office applications.

SmartERP provides a range of services on Oracle BI starting from capacity planning, implementation and support functions. We at SmartERP have done large implementation to various customers across the globe.

Our Skills and Experience

OBIEE Server Technologies

Configuring the OBIEE environment, including installation, configuration, clustering and setting up authentication mechanism. Managing users and setting up their privileges and profiles using LDAP, SSO & external database. Also configuring usage-tracking, if required.

Dash Boarding Reporting and Publishing

Experience in Oracle BI Apps that include OBIEE/Siebel Analytics in sales & marketing, financial, HR and insurance. Also, knowledge of supply chain, pharma and project analytics. Experience in using business rules to configure interactive dashboards with drill-down capabilities, contextual navigation, guided analytics, alerts, metadata objects & web catalog. Create a central architecture for generating and delivering information to employees, customers and suppliers—both securely and in the right format.

Data Integration

Experience in working with Informatica Power Center in applying transformations, creating mappings & loading data into the data warehouse.
Experience in OWB, ODI latest versions.

Query & Analysis

Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local filters, Siebel Security Setup (groups, access / query privileges), metadata objects and web catalog objects (dashboard, pages, folders, report).

Our designs allow users with the appropriate permissions to create requests that let you explore and interact with information, and present and visualize information using charts, pivot tables, and reports.

Enhanced results through charting, result layout, calculation and drilldown features.


DBA support, ETL  Server support, performance and tuning