Last updated on OCTOBER 28, 2015
Applies to:Oracle Retail Merchandising Analytics - Version 13.3 to 13.3.6 [Release 13.3]
Oracle Retail Merchandising Analytics - Version 13.2.4 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Analytics (RA) 13.2.4, the OBIEE report is not showing last year metrics.
Steps to Recreate:
- Run mcalwk454sil.ksh.
- Create "Retail AS-IS" report with "Fiscal Date", "Net Sales Qty LY".
- Run the reports. The executed report returns "No Results".
- Notice that the column MCAL_PER_NAME_HALF is loading as null in W_MCAL_WEEK_D table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms