Behavior of Business Rule Calculation When Current Week Forecast is #MISSING — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Behavior of Business Rule Calculation When Current Week Forecast is #MISSING

in Financial Consolidation and Close 6 comments

Summary:
Inquiry regarding whether the business rule for calculating weekly forecast differences (FcstWeekDiff) functions correctly when the current week's forecast value (Final->Forecast) is #MISSING.

Content (please ensure you mask any confidential information):
We are currently implementing a business rule to calculate the weekly forecast week-on-week difference (member name: FcstWeekDiff).
The current week's forecast uses the "Final" member in the Version dimension, while the previous week's forecast uses a substitution variable named FcstPreWeek1. This variable points to a member under the WeekVer hierarchy (e.g., Week17 週次W17 20250725) to represent the prior week's version.

The calculation is defined in the business rule as follows:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!