Showing posts with label Demantra How To. Show all posts
Showing posts with label Demantra How To. Show all posts

Sunday, January 18, 2015

Demantra Engine Log - Understanding Node


Demantra's Engine2K log has lot of details and one can configure to generate log at various level to debug/analyze engine's forecast generation process. Here is a quick visual of what various numbers mean when log line says Forecasting[x,y,z].


Saturday, November 8, 2014

Demantra: Logs to look for while debugging


Demantra application has various logs which can help during root cause analysis of a problem encountered in application. Some of these logs are configurable to a large degree giving flexibility to capture detailed log for analysis. Here is a summary list of some of these key logs:


  • Demantra installation log: Installer's first screen has option to enable logging at various level to capture installation activity. 
  • Collaborator.log: This log captures any error during server start, shutdown, restart, etc. The log is available under the web server directory. 
  • Systemlog: Captures various issues around logs encountered by end user on worksheets,  while running methods, etc. LoggerManager utility available through URL can be used to configure logging level and setup. 
  • IntegrationLog:  Captures various logs around data integration runs done via Demantra's inbuild integration interface tool. 
  • DBExecptionLog: DB_EXCEPTION_LOG table captures logs generated by some of the Demantra's procedures. (ep_load_xxx, chaining etc.)
  • EngineLog: EngineManagerLog & Engine2Klog files carry details of engine run activity, logging level can be controlled for engine logs too. 
  • WFProcessLog: Captures workflow run related logs and is accessible through URL too. 

More details around all the logs which come handy during troubleshooting Demantra issues can be found in Metalink Note ID 741464.1. 


Thursday, September 20, 2012

New "Guided Resolution" for Demantra

After a good success of Oracle Community concept released earlier by Oracle Support, we are seeing them taking another step forward in form of "Guided Resolution" for Demantra application. The concept basically better organizes previous resolutions for known or fixed issues related to Demantra product. 

They have started with five topics:
  • Data loading related issues (Note Id 1461899.1)
  • Data loading issues not related to error codes (Note Id  1468884.1)
  • Workflow related issues (Note Id 1353217.l)
  • Worksheet related issues (Note Id 1486639.1)
  • Engine related issues (Note Id 1486634.1)
Guided resolution page look:


Refer to below note for more details around what is this new concept and how to use it. 

How to Use the Demantra Guided Resolution, a Proactive Services Tutorial.  Note 1473992.1

Sunday, July 8, 2012

Demantra: Engine Status Check


Checking status of Engine:

To determine if engine is running or not, one can use the work_status parameter in init_params_0 table. Value_float column indicates if the current or the last engine run was in batch mode or simulation mode.

  • 99 => Simulation Run
  • 1=> Batch Run

Value_date reflects the current state of engine. If the value_date changes every 22 sec then it would mean that Engine is running currently.

As Engine can only run in one mode at a time, it helps to be aware of the current state of engine prior to launching engine run.

Wednesday, November 17, 2010

Demantra 7.3: Engine split based on series

Whas is NEW ?:
Demantra 7.3 has come up with quite few features which customers have been wishing to see. One of these is ability to split statistical forecast which generated at aggregated level to split down to lowest level based on user defined/controlled proportions. Prior to 7.3 this split was always based on historical proportions and there was no workaround for it. These historical proportions were calculated based on every product and location combinations historical monthly sales averages using proport procedure. Split by series option allows user to pick a series which dictates weights for dis-aggregation of baseline forecast.

How we USE it?
1. Define a new series with server expression, the server expression gets used in weight calculation.
2. Using Business modeler setup parameter: ENGINE > PROPORT tab > parameter name "ProportionSeries" shall be populated with the internal name of the above series.
3. Select combinations/population to use SPLIT MECHANISM by using series "Engine Proportion Method" in a worksheet. The series has two dropdown values, Matrix Based Proportions which is the default and Series Based Proportions which is the value required for series based split.

Wednesday, February 10, 2010

Exploring Demantra's BPM capabilities


Oracle Demantra's various module releases have a lot to offer for small and medium scale enterprises, who can utilize the out of box processes(best in class) as it is to a lot extent. The standard demand forecasting and S&OP planning process offered with the install benefits the SMBs, but for larger enterprises there is always a need to create a custom process. But, Demantra does have BPM(Business Process Management) capabilities as part of its native platform.

Demantra's platform flexibility allows larger enterprises to build a totally custom tailored process. Some of the already established custom process implementations are:
- Store level forecasting and replenishment planning
- hourly forecasting
- Labor planning
- Safety stock calculations etc.

Basic entities like series, levels, workflows, methods, worksheets etc. are used to create any required custom business processes. The flexibility of designing pretty much any kind of custom process by usage of these entities, makes Demantra's BPM capabilities stronger.

With Demantra being a strong pillar of Oracle's VCP offering, the future road map for its BPM capabilities will be to get upgraded to Oracle's Fusion BPM suite.

(source: Oracle)

Also seeing almost all the Demantra integrations releases already out in market, we expect to see more robust and web-based versions(inching towards Fusion) of Demantra in future.

Monday, October 26, 2009

DB issue: Business modeler/Engine Admin cannt connect to database

Problem: When trying to open Demantra Business modeler on my local install, started getting error "ORA-01033 ORACLE initialization or shutdown in progress ". Also found that while connecting to Engine Administrator I started getting error "Cann't connect to database".

Analysis: Found that even while tnsping to database works, even SQLplus connection to database using Oralce SQLPLUS wouldn't work. It happens at times when the last DB shutdown didnt happen properly. Database needs to be re-started after shutting down explicitly by using SQL PLUS.

Solution:
Using command prompt,

Login as:
> sqlplus /nolog


Once logged in, use following commands:

SQL> connect / as sysdba
ConnectÚ.
SQL> shutdown abort
Instance ORACLE arrÛtÚe.
SQL> startup nomount
Instance ORACLE lancÚe.


While executing this, I got below error:
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

To further fix this issue, used following commands to re-start database:

SQL> startup mount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1264916 bytes
Variable Size 264241900 bytes
Database Buffers 801112064 bytes
Redo Buffers 7122944 bytes
Database mounted.
SQL> recover database
Media recovery complete.
SQL> alter database open;

Database altered.

Verify that you are able to login into Database and then into Demantra applications. All set and we are back to action.

Friday, June 12, 2009

S&OP Process - Post1 - New Product Planning process


Step1: New Product planning process

Planning process for new product launch forms the first step of the larger S&OP process. This sub process shall support forecasting demand for the new product being launched. Statistical Quantitative forecast most of the times is based on the fact that future demand will resemble the historical sales. For improved forecast accuracy, qualitative information shall be incorporated into quantitative forecast numbers and a combination of it shall be used as Baseline forecast.

But for a new product with no historical sales data present, one needs to look at their product list for items with similar attributes and characteristics. Once identified historical sales of these existing product shall be mapped as history of the new product. Later a quantitative forecast can be generated out for this new product.

Picture: Product Launch Flow ***

A new product launch can affect the sales of existing products under same product line. Say the recent launch of Apple's "3G S Iphone" will surely impact the sales of it's existing old 3G model. (Well in this particular example with Apple reducing the price of old 8 GB model by half might shadow down the effect to some extent). But usually in such cases old product faces lower demand with consumers trying to grab the latest model release. This effect of reduction in the sales volume, sales revenue, or market share of one product as a result of the introduction of a new product by the same produce, is referred as Cannibalization.

Another commonly seen effect is phase out of an existing product, which is getting replaced by a new one. Effect of this process should be incorporated into the baseline forecast calculation.

Setting up New Product Planning process in Demantra:

Oracle Demantra and it's integration with EBS provides the features required to build the new product planning process on it. Collect new product codes from EBS into Demantra by using NPI setup form on DM system administrator responsibility. Once the new product is visible in Demantra, use the Member Management feature under Demand planner application to create combinations where this new product shall be sold. zero history can also be created for this new product and selected location level member's combination. This will allow users to pull up these combinations into worksheet and manually enter or adjust the historical sales information. Next step in the process is to map the historical sales from existing combination to new combination, which can be achieved using Chaining Management feature. A Chain is created and executed to copy sales history from existing combinations into the new combination. Once done, the new product at selected locations will have historical sales data, which is utilized by the Analytical Engine for calculating future demand of this new product.

It can be ensured that new product's demand prediction follows the shape of previous product launches, using Shape modeling feature of Demantra. As many as 8 distinct shapes can be saved and used under this functionality.

...........................next step in S&OP process "Demand Planning/Review".............................................


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

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

Tuesday, December 9, 2008

Demantra: Analytical Engine - A deeper look - Part1

Through this post, I would like to share some of findings about how Demantra's analytical engine works. The post is based on Demantra's documents created by Oracle and are available in Oracle Metalink for a detailed study. 

 What is Forecasting


Forecasting empowers one to predict the futuristic tendencies of supply chain, influenced by seasonal and other predictable factors. The result of forecast is a projected curve that has been smoothed to show tendencies and de-emphasize the exceptional variations.


Demantra engine is capable of multidimensional forecasting with mixed modeling techniques. It has been designed to be robust enough for handling large scale installations. It is capable of modeling hundreds of thousands of data sets with various data patterns.


Modeling is performed according to forecast tree, in which each node in the tree is defined by an item-location combination in the Enterprise Data model. Engine tries to generate forecast at lowest level of item-location combination, but in situations where due of data insufficiency's , it is unable to generate a good forecast, then it traverses the Forecast tree to higher level for generation of forecast at an aggregated level. Forecast generated at higher level is split down to lowest level, using a splitting mechanism called “proport”.


Batch verses Simulation


Engine can be executed in two modes, Batch or Simulation.


Batch Run:

  • Traverses a large forecast tress, described in database. Each node in tress represents a time based data series that is subjected to forecast.

  • Performs model calculation on a large subset of data series (each node of forecast tree)

  • Writes the processed data series to a new forecast table in database.

  • Executes a post-process procedure which updates new forecast table


Simulation Run:

  • Same steps as above are performed but on a selective subset of data, as chosen by user for “what-if” kind of simulation run.


    Engine Components


    Engine consists to two components, Engine manager and Engine server. There is one instance of Engine manager and one or more instances of engine server. The engine server scans a portion of the forecast tree according to the traversal rules, and sends the output to the split mechanism. 
    The engine server receives IDs of tasks from Engine manager, which divides the forecast tree into sub-trees (tasks). The engine manager is responsible for the engine run as a whole. 
     


    Based on Engine settings done via Engine Administrator application, Engine managers tries to initiate an engine server on list of machines on network having engine registered and server component installed.


    Reference “Details of Engine Manager & Server”. (source: Oracle Demantra Engine Guide v.5.2.6)


    Causal Factors


    Factors which cause the deviation from a trend, are known as Causal Factors. E.g. a sales promotion, due of it’s result you expect sales to rise. On the other hand, a sales promotion by your competitor can impact your sales negatively, which also becomes a causal factor.


    Causal factors such as promotions, marketing campaigns and production stoppages are essential components when analyzing demand pattern.


    Global Causal Factors effect all the nodes of forecast tree, seasonal CFs are normally global.


    Local CFs can be different for each item-location combination.


    Event is another word for CF, it can be loaded easily with Code, value and intensity information. Event information is not necessarily required to be loaded in future.



    ............to be continued.


Monday, November 3, 2008

How to: "Create a Data Series"

This post contains a simple example of creating a data series and also lists out a starter's definition to "data series" in Demantra application. For those who have worked on ODP, Series in Demantra are like "Measures" in ODP. One can create and build a simple to quite complex logic for data values which are stored and are shown in the Series. 

A simple series could be "Budget Data", which simply is created to store financial budget information. On other hand, one can create series like "Projected Inventory" or "Safety Stock", which uses multiple base series for computing the values. 



More details on Series creation and options available, can be easily found in documentation provided by Oracle. Please refer to below documentation for a better understanding of "Series":


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

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