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.
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
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