What is Oracle Demantra?  


Demantra is one of the Oracle Value Chain Planning family of Applications. Fully integrated with Oracle R11 and R12, Demantra provides a Bayesian Forecasting capability in place of the Best Fit approach of most alternative systems. Other benefits range from Real-Time data to PDA (Personal Digital Assisant) functionality.

Demantra comes from: Demand is our Mantra

Yes, Yes, but what does it do?

Fundamentally, Oracle Demantra collects, stores and organises item, location & time information, generates statistical forecasts and enables comparisons of actuals to forecast.  Forecasts can be created and adjusted in Demantra, validated and then forwarded to other applications (such as Hyperion or ASCP) for action. You don't have to create Statistical Forecasts - you could just as easily use the previous cycle as a starting point or use both approaches.

And how does it do it?

Demantra is a web enabled tool that can be implemented in various ways: from a Stand-Alone single PC populated with data from Excel spreadsheets to a sophisticated solution integrated into your ERP System (Oracle E Business Suite, J D Edwards, Siebel, SAP etc.) with hundreds of globally distributed users.

Planners interract with the Forecast (and related) data via worksheets that are quite simple to create and manipulate. Workflows and Methods can be created to automate functions and security features enable the creation of user specific interfaces.

Demantra Modules

Oracle Demantra is actually comprised of a number of modules that can be mixed and matched according to your business needs.   The modules are:

1/ Demand Management (DM)

2/ Advanced Forecasting and Demand Modelling (AFDM)

3/ Real-Time Sales and Operation Planning (RTS&OP)

4/ Predictive Trade Planning (PTP) which comprises of:

- Deduction and Settlement Management

- Trade Promotion Optimization


Demantra Pros and Cons

Demantra Positives

Fast collection & data loading process

Simplified Data loading functions ("Integration Interfaces")

Flexibility in Security / Setup / Roles & Responsibility

Best-in class Bayesian Forecast creation with Multiple Engine Options

Forecast Tree function to determine how the Statistical Engine uses Dimension Hierarchies

Statistical Forecast Simulation functionality

Nodal Tuning enables the Statistical Forecast setup of individual combinations if desired

Sophisticated Promotional and Event functionality

Product Lifecycle Management

Workflow Creation and Management

Ad Hoc Hierarchy level value creation by end user

Dimension Pivoting & Graphical display functionality

Comments and Audit trail

Promotions / Causals visible alongside Plan data

Dependent Demand & Spares Forecasting Functionality

Other features: Off-Line working, Attribute Forecasting, PDA capability.

Option for Real-Time rather than Batch mode transactions.

Some Demantra Negatives

Although data collection is fast specially filtered worksheets will be necessary for large volumes of data

Be prepared for Performance challenges: ensure Sizing & Stress Test Analsis is performed early in Project Planning. 

Ad-hoc Drill Down can only be accomplished via pre-defined embedded worksheets.

Some end-user formatting restrictions in Worksheets: colour coding and column resizing.

Series can only be created by IT

Colour Coding can only be created IT

Risk of the S&OP module duplicating some ASCP functions

Data only stored at the lowest level which means potential allocation and aggregation restrictions.

Intersections or Combinations need to exist before they can be seen in Demantra

Member Management module (for combinations and chaining) is not user friendly

Site design by Halfpenny Design Ltd