Cubes, Dimensions, Rules, and Other Artifacts

Cubes

A Predictive Cash Forecasting application includes these cubes:

OEP_PCSH—Periodic (Hybrid BSO)
OEP_DCSH—Daily (Hybrid BSO)
OCFREP—Reporting (ASO)
OEP_RCSH—Reporting (ASO)

Dimensions

Table 4-2 Predictive Cash Forecasting Dimensions

Dimension	Dimension Details	Comments
Currency	Mandatory, Standard	You can perform multi-currency forecasting, with multiple currencies imported from Fusion ERP or other sources. Adjustments can be done at each input currency and translated into reporting currency.
Entity	Mandatory, Standard	This is the legal entity structure that can be pulled from Fusion ERP or other sources. The Entity can then be categorized under hierarchies for rolling up cash forecast and actual numbers by entity, regions, and overall global views.
Forecast Method	Mandatory, Provided	Forecast methods are provided in the application as a way to arrive at your forecast. Includes different forecast methods such as Smart Driver (forecasting based on ERP data), Driver, Trend, Predictive (statistical predictions from Auto Predict and ML-based predictions). Also used for pay terms and other assumptions. For each line item, you define which forecast method to use.
Line Item	Mandatory, Standard	This dimension represents each of the cash flow elements, such as cash balance, inflows, and outflows; the equivalent of the Accounts dimension.
Period	Mandatory, Standard	You can enable cash forecasts to be Daily rolling and Periodic rolling forecasts. Periodic forecasts can be either weekly or monthly. You can choose to include Quarters and Months in the hierarchy.
Scenario	Mandatory, Standard	This dimension allows for delineating actual, daily, and periodic forecasts.
Version	Mandatory, Standard	This dimension allows for multiple versions of the forecast. It supports a working version and what-if versions, to compare between working and what-if versions. You can create additional versions.
Years	Mandatory, Standard	Cash forecasting can be done for multiple years. This dimension allows for creating multiple years, both historical and future periods that can help you analyze cash reporting year over year. Years can be calendar years or fiscal years.
Bank	Mandatory, Provided	Bank balances are a critical part of the cash forecasts. Use this dimension to analyze cash by different banks and bank accounts. Typically used for historical data and cash position for reporting by bank. Forecasting is not available by bank; forecasting is done by Any Bank or No Bank. Bank and Bank accounts can be imported from Fusion ERP or other sources.
Business Unit	Optional, Provided	Business Unit is a mandatory dimension if Fusion ERP integration is enabled. This dimension allows for cash reporting based on business unit across the enterprise. Business Unit can be imported from Fusion ERP or other sources.
Category	Mandatory, Provided	The Category dimension is a generic placeholder custom dimension that you can use for various purposes such as Projects, Stores, Assets, or Tax Payments, for example. Hierarchies are populated based on driver-based methods that need this dimension. For example, for project-related payments, you can use this dimension for your projects. The category applicable for each cash line item can be different. For example Project Payments have different Projects in the Category dimension and Supplier Payments have supplier types in the Category dimension.
Custom 1	Optional, User defined	Predictive Cash Forecasting provides one additional custom dimension for any use, such as cost center, market segment, stores, or any other important business dimension that is relevant for the purpose of cash reporting. This placeholder custom dimension is provided to support modeling using this dimension.
Party	Optional, Provided	Party is a mandatory dimension if Fusion ERP integration is enabled. It represents customer and supplier hierarchies. You can import Customers and Suppliers from Fusion ERP or other sources for forecasting and analyzing cash data by customers or suppliers. Customers and Suppliers are tiered into multiple ranked tiers based on key business drivers to identify the top parties to be prioritized versus the others.

Rules

Daily Process Actuals—This rule calculates opening and closing balance based on actuals inflows/outflows. Run this rule on a daily basis after loading daily actuals. This rule is run by entity. This rule sets the substitution variables for the daily period, processes actual data after it is loaded, and calculates the opening balance of the forecast period using the current period ending/closing balance. If you select a parent member to run it for, it runs for all level0 children. The rule takes today's date as the current date.
This seeds the forecast with a rolling forecast so planners can start working, with a forecast range based on Forecast Range Setup.
Periodic Process Actuals—This rule processes actual data after it is loaded and calculates the opening balance of the forecast period using the current period ending balance.
Daily Process Forecast or Periodic Process Forecast—Run this rule before cash managers begin forecasting for the day. This rule populates the rolling forecast based on the forecast method set for each line item and period range and also populates the overall rolling forecast amount. It also posts the opening balance across all open forecast periods.
Currency Translation rules:
- Daily Currency Translation To Entity Currency
- Daily Currency Translation To Reporting Currency
- Periodic Currency Translation To Entity Currency
- Periodic Currency Translation To Reporting Currency
Rollup rules so Controllers see values of an entity at the parent level:
- Daily Rollup Entity
- Periodic Rollup Entity

Navigation Flows

Predictive Cash Forecasting provides role-based navigation flows:

Cash Manager Flow— The primary end user navigation flow that covers both periodic and daily cash forecasting by Entity. Cash Managers review cash inflows and outflows for their Entity to forecast and optimize cash. This navigation flow covers multiple cash forecasting methods, grouped as vertical tabs.
Controller—Another end user navigation flow that can be used by reviewers or treasury who have visibility into to multiple Entities (such as regional-level or country-level). Controllers can drill in to entity-level cash forecasts (the same as the Cash Manager navigation flow). Cash Managers typically report to Controllers.
Admin—The default navigation flow that is provided for administrators for configuring the Predictive Cash Forecasting application and extending it for more capabilities from the EPM Cloud Platform.

Note:

Create groups, such as Cash Manager and Controller, in Access Control, to correspond to the navigation flows, and then assign the navigation flow to the associated group.