Thursday, October 11, 2007

Demantra Application - Components

Demantra has two set of applications, one which are Browser based applications and others which are desktop based. Typically used Demantra applications are:

1. Browser based applications: These applications provide a web-based collaborative environment with a customizable and user-friendly user interface. Most used applications in this category are Collaborator Workbench, Workflow Management and Demand Planner Anywhere

2. Client based applications: Desktop applications are used mostly by only few key users as these applications serve as administrative tools. Few important ones in this category are Business Modeler, Demand Planner, Scheduler, Engine Administrator etc.

Basic Components of Demantra:
Worksheets: This is an online working environment provided for viewing and editing data. Worksheets are created for supporting need of specific business functions/processes. The worksheet application is the environment on which a demand planner/analyst works for most of the hours of his day.

Workflow: A browser based application for executing functions and processes from front end. This act as a software process which can be utilised to support complex processes & flows and also can automate it.

Content Panes: Dashboards with graphical or tabular views in a read only format, to present all the information on your fingertips. Content Panes become very handy for Executives and Managers for information which can be fetched from the worksheets and represent KPIs.

Collaborator Workbench: Browser based collaborative workbench environment which serves as a launch pad for various applications as well as for quick information & updates with access to KPIs. Workbench can be personalized for each business user as per their needs and roles.

Analytical Engine: Forecasting Engine which generates forecast using Bayesian modeling technique by utilizing multiple statistical models(number depends on licence).

Tuesday, October 9, 2007

Installing Demantra 7.1.1 on Windows

Installing Demantra


Detailed instructions for installing Demantra are available on Oracle Metalink(Doc Id:Note:428495.1), through this blog we would be exploring out the high level requirement and steps involved in installation process, following which one can easily install Demantra for demo purposes.

System Requirement: A PIV processor with atleast 1 GB RAM and sufficient disk space for a keeping a Database installation. (I have installed multiple times on this configuration and system capabilities never came up as a problem, but yeah data size on which I work is no where closer to real life situations). For a client site project the requirement would be obviously on high side.

Software Requirement: For Demo purposes, Windows XP OS is recommended and Tomcat serves the purpose of application server. Oracle DB(9i or 10g) server should be installed on the machine.

Pre-requisites: Make sure you have the installer, security license file and Database information, before you start the installation process. It is adviced to cleanup previous versions of Java for smooth installation. Keep the database running and close out all other applications on your system.

Demantra Installation: Run the installer(setup.exe, Launch Anywhere) and follow these
instructions for completion;

Introduction : Click on Next

Product Configuration/Installation Set : Select "Typical" or "Complete" as per the requirement. The Installation Set window appears if you select the "Custom" option

Choose Install Folder : select the folder in which you would like to install

Choose Shortcut Location : Specify where to put the product shortcuts of application

Database Configuration :

  • Select DB type as "Oracle" and click Next.
  • Provide information to connect to DB as DB administrator. (DBA user name, password & TNS name).
  • Click next and create a user under which all the Demantra data will be stored.
  • On next screen provide details for JDBC connectivity.(host machine, port number & Oracle SID)
  • Select the application as per the requirement for Demo purposes you should pick the "Standard Application" option which has an out-of-box configuration.
  • On next screen select table spaces

General Configuration:

  • Specify Web Address : Define the web address to access Web based applications like CWB & Workflow Manager
  • Client Plugin download : Keep the default values(for Java Plugin version) and Click on Next
  • Designate Administrator Account : Assign administrator account to a Demantra user by providing mail server details and login details, so that all the automated messages are sent to the administrator.
  • Setup Environments : Select promotion environments you want to work on, based on selection you made a default DB structure will be constructed.

Pre-installation Summary : Review the selections made till now, before initiating the actual installation of application. This is kind of summary of install option set which will be installed.

Installing : Wait for the installation to complete this step usually takes some time, so be patient.

Database Summary : This installation step creates user, imports demo data and creates all the procedures.

Final Tuning : Option of upgrading to Settlement Management is made available on this screen, Skip if you don't want it.

Install Complete : Once installation is complete, select the option of re-starting the system and you are done.

Post Installation : Verify that the installation done is working by opening few key applications like Collaborator Workbench, Business Modeler & Engine Administrator. Start the DB & application server(Tomcat in this case). Open the folder in which Demantra was installed and look for following path ....Oracle Demantra Spectrum\Collaborator\Links to get to the links for opening web-based applications like Collaborator Workbench. Open the link and login as dm/dm to access the pre-configured demand management workbench. Try opening Business modeler application by clicking on modeler.exe file located in the installed folder with path ...Oracle Demantra Spectrum\Demand Planner\DeskTop.

Demantra on E-Delivery

Getting the Application

Oracle has made the Demantra application available on their e-delivery site(http://edelivery.oracle.com/). One can download the latest version available after agreeing to the Terms & Conditions of usage. Open the site and reach to the search page, there select product pack "Oracle Demantra" and platform as required(being a Windows user I selected MS Windows 32 it) and click on GO button.


Once downloaded you can run the installer and can easily install a stand alone Demantra application demo.

Note:Make sure you follow the Terms & Conditions prescribed by Oracle for usage of the application downloaded from their e-delivery sites.

Wednesday, October 3, 2007

Oracle Demantra Application

Oracle's acquisition of Demantra Technologies has broaden the Oracle's offering in Supply chain management domain with Demantra catering to serve as Advanced Forecasting, Demand planning and Real time Sales & Operational Planning solution for business needs. Oracle's in house developed Oracle Demand Planning(ODP) product made way for Demantra's Demand Management application as the later is now the application being offered for demand planning solution.



Oracle Demantra offers solution in following lines of industrial needs:


  • Demand Management

  • Real time Sales & Operational Planning

  • Trade Promotion & Management

  • Deduction/Settlement Management

Demantra with it's best in class quality application and ORACLE's brand name attached to it, is galloping to new heights of demand in market. The solutions stand alone offering as well as integrated offering with Oracle EBS, JD Edwards Enterprise & One World has proven it's capabilities already in the market.

Perspectives on Managing through Difficult Times