Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« A Vendors Guide for Understanding BI Deployments - Business v/s IT | Main | Critical Role of Training In ERP Adoption »

Mighty Oracle Fusion Transportation Intelligence

Retaining customer loyalty, meeting SLA's, managing increasing expectation of stakeholders within existing financial restraints are few of the challenges business face. Logistics hence, plays important role meeting such needs and provides competitive advantage. Transactional logistics data nowadays is not merely part of repository; it has grown as integral part of business strategy in today's world. If harnessed it can provide the competitive edge businesses around the world eye upon. With ever growing data storage capacity per unit cost, Businesses around the world have huge amount of such data. This data if utilized in strategic manner, can provide Intelligence support to day to day business decision or objective support to future strategies.

Oracle Fusion Transportation Intelligence is one such innovative product which meets such business needs. It's a web based solution which integrates Oracle Products such as Oracle Database , Oracle Data Integrator, Oracle Business Intelligence Enterprise Edition & Oracle Transportation Management (OTM).Transactional data residing in OLTP systems (OTM) is fetched into FTI historical repository.The FTI's historical repository act as a datawarehouse & provides information which can be utilized to support various level of decision makings. Organizations need to define and monitor various Key Performance Indicator (KPI's) or Metrics , keeping in mind the strategy , to analyze their business health.

 

Fusion Trasnportation Intelligence Features :-

·         Industry Specific Dashboards

·         Over 60 Prebuilt KPI's post OTM 6.0

·         Increased Adhoc Querying Capability

·         Interactive Alerts

·         User Defined Customizable Dashboard

·         KPI Targets

·         Performance Indicators

·         Customized Dashboards based on user role

·         Historical Analysis available for Decision Points

·         Process Management- ETL Jobs from OTM UI

·         Data Management- Data Load Status in FTI in Dashboard

·         Analysis At Week Level - Lower Level Of Granularity

·         Refnums Modeling in FTI

·         Ranking of Refnums - 3 Refnums per Object flow into FTI 

User Friendliness :     

  • Put reports in placeholders and if needed share it with other users by granting access
  • Create on the fly reports by simple drag & drop required columns
  • Ad Hoc Querying - Create business reports on ad-hoc requirements

Business Benefits:

·         Operations Benchmarking & Tracking

·         Defining Business Metrics

·         Business analysis spread across various periods

·         Various report available on-demand , to assist in decision making

·         Revise & keep track of business goals.

·         Get alerts based on business events.

·         Target Setting for future

·         Tune business processes

 

Fusion Transportation Intelligence Architecture Details :

FTI works with Historic Data and fetches data from Oracle OLTP servers. In practice , keeping in view the performance the data source is generally kept as ROD ( Replication of Operational Database) or DR (Disaster Recovery). Oracle Data Integrator fetches up the data from these repository servers. Diagram below depicts Oracle Data Integrator architecture :

 ODI.png

 

In practice , we trigger ETL process ( Extract , Trasform & Load ) from OTM UI. Once triggered , ODI fetches the data from source repository , transforms the data in to denormalized form ( extended star schema ) and finally , pushes data into Historical Database or commonly known as FTI DB. OBIEE ( Oracle Business Intelligence Enterprise Edition ) uses Historical Database for reporting purpose.Finally , OBIEE is linked with OTM/GTM products to access FTI from single UI window.

 

 Diagram below summarizes the process flow

 

FTI.png

 

 

Infosys Advantage :

Infosys brings it's vast experience in Consulting & System Integration. Apart from mentioned production features and it's implementation , Infosys brings tailored customizations which best suits business needs. Certain features that our expertise brings which doesn't come out of box :

ü  What-If Scenarios

ü  Developing Forecasting Capabilities

ü  Predictive Transportation Analytics & Simulations based on historical data

ü  Data Modelling & Wrangling

ü  Vouchers & Accrual Process Analytics

 

 

Fusion Transportation Intelligence brings best of the Oracle Products and it's integrated architecture provides flexibility which can be mould to suit existing business best practices.It's highly recommended for the business who looks forward to make best out of existing logistics data.

Comments

I think this feature going to fullfill the business needs.It efficients to analyze the business health.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles