Enabling Weekly Planning
In Financials, select Weekly Planning to enable planners to plan and forecast at the weekly level. Forms are designed so planners can view weekly level plan and forecast data. Planners can also leverage the rolling forecast range at a weekly granularity and plan continuously at a weekly level for 13, 26, or 52 weeks.
For 12-period applications, you also specify how to map weeks to months, based on the number of fiscal weeks in a month: 4-4-5, 4-5-4, or 5-4-4. The application treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern. For example, if you select 5-4-4, the first month in a quarter has five weeks, and the last two months in the quarter have four weeks. You can't later change the distribution method. For 13-period applications, you specify these distribution options during application creation.
In Financials, if you are planning at the weekly level in a 12-month calendar application, you can incrementally enable an option to support a 53-week calendar. Options you specify when enabling 53 weeks determine in which month and year the 53rd week falls. Usually the 53rd week occurs every fourth or fifth calendar year. You can’t disable this feature once it’s enabled. See Enabling 53-Week Planning.
After you enable weekly forecast, use the Planning and Forecast Preparation configuration task to configure your Plan, Forecast, or Rolling Forecast for weekly, monthly, or yearly planning.
By default, when you enable weekly planning, all entity and account combinations are set up for weekly planning. You can specify that some entity/account combinations use monthly planning. This is useful when most entities use weekly planning, but certain entities use monthly planning; or when an entity plans at the monthly level except for certain accounts. To configure weekly planning for these scenarios, see Weekly Configurations.
When you enable and configure weekly planning:
-
Rules for weekly planning and analysis are created, to convert months to weeks, and to convert weeks to months.
- Forms are designed so you can view the appropriate granularity for each time period. For example, some years can show weekly data while other years show monthly or yearly data. Valid intersections are used to control what displays.
-
When you update the current time period, forms are automatically updated to add or drop new time periods as needed to reflect the updated period. Trends and drivers are populated to newly added time periods. Valid intersections are used to make the forms dynamic.
- A new member (OEP_Weekly Plan) is added to the Period dimension.
- When you enter exchange rates at the monthly level in the Global Assumptions configuration task, when you save the form, the monthly exchange rates are copied to the weekly level, based on how you mapped weeks to months (4-4-5, 4-5-4, or 5-4-4), for the Financials cube (OEP_FS) only. The weekly time periods are not automatically enabled for other cubes when they are enabled for Financials. If you enable weekly periods for other cubes and want currency conversion to work for weekly time periods, you must enter exchange rates for weekly periods for that cube.
Weekly currency conversion is supported for BSO cubes only. (It is not supported for ASO cubes even if weekly periods are enabled for ASO cubes.)
- If you are integrating with Capital, Projects, or Workforce, the granularity of the data in each must match in order to view the integration-related reports.
These batch rules must be run after planning at the weekly level, to convert weeks to months or months to weeks, and before performing trend calculations if the actuals data is at a monthly granularity. Give planners access to these rules and instruct them to run the rules after performing weekly planning:
- Convert Weekly Data to Monthly. You must run this rule before planners can view monthly data in dashboards.
- Convert Monthly Data to Weekly.
Before you run the rules Prepare Plan, Prepare Forecast, or Prepare Rolling Forecast, make sure to perform any required conversions from months to weeks or weeks to months.
Video
| Your Goal | Watch This Video |
|---|---|
|
Learn about weekly planning. |
|
