Tuesday, June 9, 2009

How to extend Calendar to 2030 in Demantra

Problem: Demantra has calendar with dates only till 2010, as you could have possible seen in table INPUTS too. With 2009 going on, customers need the calendar to be extended way further in future.

Solution: Oracle has released a patch for this and is now available on Metalink for download.

Details: If your version of Demantra has INPUTS table extending only till 2010, then you need to refer to metalink note (551814.1). Based on which version of Demantra you are running, you can download specific patch to resolve your problem.

Remember that this patch would only populate standard columns and any custom columns representing your custom calendars will need manual intervention. You can populate your custom column upto 2030, once this patch extends the records to dates till 2030.

Metalink note: 551814.1
Demantra Versions applicable: 6.2.6, 7.0.2, 7.1.1, 7.2.0.X

Demantra 7.2.1 integration with Siebel 7.8

In response to a mail query:

"Newly released integration pack between Siebel 7.8 with Demantra 7.2.1 is now available for download from Oracle, after prior approval from Oracle Development team. Remember this integration package is still a controlled release targeted only for a specific customer segement.

NOTE: This release isnt a public one.

Metalink note id 470574.1, shall be referred for more details about this release and for patch name and numbers. "

Wednesday, June 3, 2009

Notes from Today's Webcast on "The Key to Optimizing Demantra Worksheet Performance"

Today's webcast was another session full of information on how to ensure that you are getting best performance from Demantra worksheets. Few key points to take away were:

1. At times JAVA is the culprit for a degraded performance of worksheets
2. End users machine specific setups can help improve performance as well
3. Database maintenance plays key role too
4. Application server settings based on number of concurrent users comes handy too.

The session covered various issues and resolutions for them, it was nicely presented by dividing in short term and long term solutions.

Short term solutions which were discussed in today's session focused on:
- Ensuring End user machines meet minimal system requirements
- Setting up the heap size (Xmx) to maximum possible
- Guidelines to end users for minimizing other applications run during Demantra usage
- Worksheets shall be reviewed and usage of filters is highly recommended
- Setting up params related to Application Server (like MaxUpdateThreads, etc.)
- Running Rebuild_Schema procs to ensure no chain rows exist
- Running Drop_temp to ensure temporary tables aren't eating up space

In long term strategy, few key suggestions were:
- Ensuring strong network connection for end users
- Providing separate tablespace for key tables and their indexes (e.g. sales_data, mdp_matrix etc.)

For complete session coverage and details of all the solutions, you can go to Oracle Community - Demantra Solutions. (or refer to metalink note 800030.1)

Wednesday, May 27, 2009

Upcoming Demantra Webcast from Oracle

Another solution advisory webcast will be happening on 3rd June 09, this webcast comes again from newly build Oracle Support Community for Demantra Solutions. The subject for this webcast is "Optimizing worksheet Performance", more details for the webcast can be found under metalink note with document ID 801835.1. 

"Upcoming Demantra Solutions Advisor Webcasts

Advisor Webcasts offer a convenient way for you to interact with professional, technical, and application experts regarding topics such as troubleshooting tips, best practices, new release information and more.

Webcast: The Key to Optimizing Demantra Worksheet Performance

Topics will include:
  • Java Plugin Settings
  • Creating Worksheets in the optimal manner
  • Backend Database Checks
  • Application Server Settings
  • Other options when your worksheet performance doesn't meet your needs

A short, live demonstration and question and answer period will be included. " 

You can register for this webcast from the link provided in the metalink note. (Id provided at the beginning of this post).

Friday, May 22, 2009

Forecasting Basics - revisited

Here is a good presentation on basics of Forecasting....

Thursday, May 14, 2009

Forecasting Basics: Qualitative Approach

Not always you as a Demand Planner have luxury of sitting on top of good amount of historical data for predicting demand of various products. For new products being introduced into the market and other scenarios when data available isn't sufficient, then one needs to utilize their judgement and intuition. This can be best addressed by using collective expert opinions in making forecasts and the process is called "Qualitative method" in forecasting. 

"Qualitative Techniques"Definition: "Estimating method that relies on expert human judgment combined with a rating scale, instead of on hard (measurable and verifiable) data."

Few known methods used are:
1. Expert Inputs
Sales, Marketing and Management folks bring expertise opinion towards making accurate forecast predictions. Even with quantitative forecast in place, Expert inputs can modify and adjust forecast numbers to improve it's accuracy. 

2. Delphi method
Experts anonymously answer a questionnaire, which is later revisited to review the responses. The process provides flexibility of revising their earlier answers based on the feed backs. This process leads to answers converging on every round and every time improving the accuracy. 

3. Analogy/Attribute/Assumption based Forecasting
Forecast based on analogy to similar products. 

4. Market Research
Creating forecast based on market &  sales analysis along with Consumer research on   products.

More reading material @
1. Forecasting Techniques, Part 2: Qualitative Methods
2. Measuring Forecast Accuracy : A Tutorial :  Qualitative Methods


Thursday, May 7, 2009

New Oracle Support Community for Demantra

Oracle Support team has provided another platform for collaborating with fellow consultants and experts on Demantra, at Oracle's new Community "Demantra Solutions". For all the metalink users, this community can come very handy to raise various issues faced for getting an answer from Oracle directly, or from community members. 

The community's documents scetion has Notes and Tips shared by experts on various Demantra issues and topics.  Another attractive feature of Demantra community is Webcasts done on regular basis on variety of topics. 


Access the metalink, and go to the "Community" tab follow the instructions and you would reach this portal.  

Wednesday, April 8, 2009

News: Supply Chain Fusion Implements Oracle Demantra's BAL Tool

PALO ALTO, Calif., Apr 06, 2009 (BUSINESS WIRE) -- Supply Chain Fusion, Inc, a leader in Demantra solutions, is one of the first companies to leverage Oracle's new Business Application Language (BAL) tool to automate an upgrade of Oracle's Demantra.

The new Business Application Language Utility in version 7.2.0.2 of Demantra is a metadata management tool which compares business models between versions originating from Demantra 7.1.1 or later. The tool highlights the differences and allows for user intervention while migrating business objects. The utility enables comparisons between standard Demantra releases and customer extensions, allowing for a merge of business best practices.

By leveraging Oracle's new BAL tool, Supply Chain Fusion is able to achieve a significant reduction in time and required resources in the upgrade process, translating to savings for their clients...........

For complete story read the article published @ http://www.cnbc.com/id/30078092


Perspectives on Managing through Difficult Times