My Oracle Support Banner

DM:Troubleshooting Issues To Forecast Accuracy (MAPE, MAD, BIAS, Archiving, Waterfall Analysis, Trend analysis) (Doc ID 2661777.1)

Last updated on MAY 18, 2023

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.

Purpose

 This document provides information about Troubleshooting Issues related to Forecast Accuracy (MAPE, MAD, BIAS, Archiving, Waterfall Analysis, Trend analysis)

Scope

 The functionality described in this document is applicable to Fusion Demand Management Application

Details

To view full details, sign in with your My Oracle Support account.

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

In this Document
Purpose
Scope
Details
 General Information
 Common Errors
 Following Level does not share  Dimension and Hierarchy of Granularities:Level: Week, Level Type: Worksheet Levels, Granularity Ids [30000000yyyyyyy]
 Error: The Archive Plan Data process is failing with a warning. Measure id: 1234 has expression referencing non-existing measures: <<Measure_code>>
 Biz Error Message: ORA-01476: divisor is equal to zero
 Common Issues
 Issue:  Unable to view the Archive data for last one week, two week etc in either waterfall analysis or trend analysis.
 Issue:  Archival Measure values are not populated in the Table
 FAQ
 Q: How to View Forecast Fit Data?
 Q: How the analytical engine is calculating MAD/MAPE/BIAS?
 White Papers

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.