Wednesday, October 29, 2008

Demantra Forecasting Models- Part2

continued from Part-1 of Models for DM module ...

6. Combined Transformation Model(elog): Works in both DP & PE mode of analytical engine run and is combination of Transformation &  CMReg model. This model performs CMReg operations on log transformed time series. 

7. Multiplicative Monte Carlo Regression(CMReg): This model comes into picture for both DP &PE mode run as well, and utilizes long Causal Factors. 

8. Integrated Causal Exponential Model(BWint): This also is a regression model, known as Multiplicative regression - winter model.  The model works only in DP mode. It runs multiplicative regression on Causal data (short CFs) and then smooths out the residual series exponentially like HOLT. It helps modeling Trends, Seasonality and Causality in demand data. 

9. Auto & Linear Regression: It is available in DP mode run and includes auto-regression. Causal factors which are used by this model are Constant & events. 

NOTE: All the 15 models can be used by engine in DP mode run, while in PE mode following models are not available:
- ARIX, ARLOGISTIC, ARX, BWINT, FCROST, ICMERGR & IREGR

Tuesday, October 21, 2008

Demantra: How to "Create a new Worksheet"

We covered in last few posts, how one can login into Demantra application with ease and can launch worksheet application. Worksheets are the most used GUI in Demantra application by end users, it helps user in reporting, data entry, what-if analysis runs, decision making, nodal tuning and approval process.

In this post you can see how to create a simple new worksheet.


Download and study the "Demand Management User Guide" , for more details on Worksheet application.
Document is avaialble @ http://download.oracle.com/docs/cd/E11051_02/demantra/acrobat/ddmug.pdf

Monday, October 20, 2008

How to : "Launch Worksheet application"

One can launch worksheet application through Collaborator Workbench, you need to open any of the existing worksheets by clicking on it. Once worksheet application is launched you can create new worksheets or can work on any other existing ones.

Friday, October 17, 2008

How To: "Personalize Collaborator Workbench"

Collaborator workbench is an web-based thin client platform, which acts as a launch pad for various applications, like Worksheets, Business Modeler, Demand Planner etc.. Also it provides a task list for users to work on and empowers them with number of dashboards showing trends, KPIs and business driving factors.

You can completely personalize collaborator workbench as per your role, responsibility and daily routine work. The order and looks of each pane can be modified by user, with ease.

Selecting & Organizing Panes:

You can easily select & manage the panes, change their order of arrangement, select relevant KPI dashboards, member browser content panes, etc. This all can be done by simply using the "Personalize" option available on top-right corner of Collaborator workbench. You will see all the available contents and one can choose based on their usage and need, which contents should be shown on their personal collaborator workbench. One can also move the contents up and down, e.g. you can have "My Tasks" pane on the top and can push the "My Worksheets" pane down.

Personalize "My Worksheets" pane:

It starts with selecting most common and most used worksheets under pane "My Worksheets", by clicking on "Personalize" button on up right corner of pane "My Worksheets". You shall see all the relevant worksheets in and then you can pick ones you want to be shown in the workbench.

Manage "My Tasks" pane:

"My Tasks" pane is like your mail box for Demantra environment, you will get tasks/notifications/alerts/attachments as list items under your content pane "My Tasks". One should ensure completed tasks are removed from the list, so that list of tasks doesn't grow like anything.

Note:

1. Remember that you should not keep lot of Dashboards on your workbench as it can significantly increase the loading time.

2. Treat your collaborator workbench as your office desk, and try to keep only important items on it. Keep it simple and clean to improve your efficiency.

For more details on Collaborator Workbench, read "Demantra Collaborator Workbench User's Guide 7.0.2 " @ http://download.oracle.com/docs/cd/E11885_01/demantra/html/docset.html

Thursday, October 16, 2008

How To: Login into Demantra application

How To: Login into Demantra application

Demantra installer adds a folder with name like "Oracle Demantra Spectrum" under "Start>>Program Files" menu option. (Remember: This startup program option is created only if during installation you have selected the corresponding option)


Click on Start >Programs > Oracle Demantra Spectrum, on Demantra server machine and you should see a list of programs available in the list. (as shown here)


Demantra application comprises of a set of desktop based and web-based applications. Desktop based applications are adminstrative ones like Business Modeler, Demand Planner, Engine Administrator & Scheduler. Web-based applications are Collaborator Workbench and Workflow manager, these can be accessed from IE(Internet explorer) using specific URLs. Start & Stop Web Server, options are available for tomcat control.

Other programs listed like Analytical Engine, Business Logic Engine & Simulation Engine are very rarely used and some of them launch Engine in command prompt mode.

To Login into Collaborator Workbench, for accessing worksheets and dashboards:

>Ensure Web Server is up and running
>Click on "Collaborator Workbench" option
>In Login screen enter user: dm/password: dm
>Wait till all the java applets are loaded and then click on any of the worksheets under pane "My Worksheets"
>This should launch the workhseet application.
Remember:
1. One can start the desktop based application, with DB up and running. For web-based applications, tomcat (web server) should be running too.
2. One can use seeded logins like dm/dm, sop/sop etc, based on modules which have been installed.

How To: install Demantra application?

How To: install Demantra application?

For basic demo environment setup, single tier architecture suits which comprises of having Oracle Database, Demantra application server and Analytical engine, all in one machine.
Demantra installation can be very easily done using the Demantra installer file. But before you start ensure, that you have Oracle DB installed up and running. Also one should keep handy details like Oracle SID, Database system user login, etc. More details on installation can be gathered from following links:

A blog on Oracle Demantra 7.2 installation:
http://applicationsdba.blogspot.com/2008/01/r12-demantra-integration-part-ii.html

Previously published blog on Demantra installation 7.1.1:
http://oracledemantra.blogspot.com/2007/10/installing-demantra-711-on-windows.html

My Oracle Support(Metalink): Oracle Demantra Installation for Release 7.1.1http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=428495.1

My Oracle Support(Metalink): EBS-Demantra Integration Installation Overview and Diagramhttp://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=434991.1

Post installation activities:
1. Set up Environment variable "JAVA_HOME"
2. Launch and verify tomcat(web server) runs fine
3. Launch and test Collaborator workbench application
4. Launch and validate that desktop based application are working fine. (like Business modeler, Demand planner, Engine Administrator etc.)

Wednesday, October 15, 2008

How to: get hold of Demantra documentation ? |

There are multiple sources to access Demantra documentation, few of them includes:

1. Online documentation for Oracle Demantra available at:
"http://download.oracle.com/docs/cd/E11885_01/demantra/html/homeset.html".

2. My Oracle Support (previously known as Metalink):
If you have Metalink login access, then you can search and find all the available documentations released by Oracle.
https://metalink.oracle.com/

3. Oracle Demantra installed folder:
Few basic documents are available when you install Demantra application. These can be found under the installed folder "Oracle Demantra Spectrum".

News: Kyocera gets Demantra

"In a bid to help wireless manufacturer, to improve planning and forecasting functions, BearingPoint, Inc. has announced it deployed Oracle Demantra Demand Management for the San Diego, California- based company.

With the solution in place, Kyocera is able to improve accuracy and no longer depends on a manual process for planning and forecasting Also, with Oracle Demantra the company can generate more consistent reports and maintain a better audit trail.

All of these new capabilities also help Kyocera Wireless to better respond to demand as well as generate forecasts and consensus plans without the need of any special expertise.
........................................"
For complete story visit "http://call-center-software.tmcnet.com/topics/call-center-solutions/articles/40585-kyocera-gets-oracle-demantra-from-bearingpoint.htm"

Demantra: "How to" Series

We will be starting a "How to" series, for Demantra which will bring answers to various setup and configuration related queries on Demantra. We will start with basics and then move on to more complex world of Demantra product. In case you have any specific question, then put in comments and we would be glad to include that question in this series.

Perspectives on Managing through Difficult Times