Clarification on Proper Setting of MCAL_NUM Value Before Loading Historical Sales Data into Retail Analytics

(Doc ID 1983788.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising Analytics - Version 13.3.6 and later
Information in this document applies to any platform.


According to the Oracle Retail Analytics (RA) documentation (Operations Guide for version 13.3.6):

"MCAL_NUM on W_RTL_CURR_MCAL_G table with MCAL_TYPE equal to 'DT' needs to be updated to the day in 'YYYYMMDD' format before the first dimension/fact is loaded.  That is, if you plan to load data and have all the items on the first day of history on '20100101', then the MCAL_NUM with MCAL_TYPE equal to 'DT' should be updated to '20091231'."

Does the phrase "have all the items on the first day of history on '20100101'" mean that if  the earliest date of sales is '20100101',  we should set MCAL_NUM to '20091231'?


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