Demantra 12.2.3 Worksheet Does Not Respect Calendar Month (Doc ID 1904929.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

Customr is on 12.2.2

Version_details_history

2.2.2 11 0 06-NOV-13
12.2.2 11 0 08-JAN-14
12.2.2 11 0 12-MAR-14


They mention that after installation, they did the following

Upgrade_to_cal_month.main(null,null) was run to split dates

  Inputs was checked to see that new days were added and they were.


  All history and forecast data was loaded from scratch and it followed the new inputs dates


  EngineScaleInput was set to Yes
  Causals were marked be scaled (Scale Causals)

They have noticed that when the first day of the month is not a monday (the first day of the week in a weekly model) the Worksheet miscalculates the dates.

Ex: If the today's date is 1 April 2014 and the Worksheet is configured to use Calendar Month time period and Specify Relative to Today Time window is 0 before and after, the worksheet will show results for March 2013. The Worksheet must recognize that the 1st of April falls in April 2014 so it must show April 2014 results.

This does not happen for Time Window 6 before and after. Since 1 Sep 2014 is a Monday the Worksheet shows the correct results of September 2014.



Model: Weekly
First day of the week: Monday
Splitting programs were used during installation to use Calendar Month

Everything works correctly at Lowest level, Calendar Month level etc. just that they notice this problem in these first weeks.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms