v2:admin:wftreescenario

Scenarios

Two important functions under Scenario are Closed Month and Copy Scenario.

  • Closed Month: here you choose until which month you will have Actual. This means you will be able to edit numbers for the months after that, but not for the period previous to Closed Month.
  • Copy Scenario: here you can choose copy data. Data copied will include Line Item details and texts/ comments if existing in source data.

    • From Scenario: Which Scenario to copy data from.
    • Year offset:
      • Previous Year - copies data FROM previous year into the specified time period.
      • No shift - copies data without any time shift.
      • Next Year - copies data FROM next year into the specified time period.
      • DataClass - Defaults to “(all dataclasses)”. If desired the can be changed to copy only a certain DataClass.
    • To Scenario specified which Scenario to copy data into.
    • Start Month and End Month specifies the interval to copy data into. Months are specified on the TO side
      • Example: Specifying Start Month = 2021-04 and Year offset = Next Year will copy from 2020-04 to 2021-04.
  • Simplified Dimensionality to reduce number of dimensions in some scenarios
    • A common configuration is that some scenarios have a reduced dimensionality. Typical examples of this are that Budgeting and Forecasting are not using all the detail available in the Actual Finance Scenario. This can be configured by designating a Scenario as having reduced dimensionality. Se “Simplified Dimensionality” checkbox per scenario, and “Simplification” button for setup.
    • When data is copied from a full dimension scenario (on that does not have the “Simplified Scenario” checked to a scenario with reduced number of dimensions
      • Only data in BusinessProcess=CONSOLIDATED and BusinessRule=NONE is copied.
        • The exception of this is for LineItem details where BusinessProcess is preserved.
      • All data is set to specific members of dimensions as set in configuration “Simplification” button (by DataClass, see below)
        • Default settings
          • BusinessProcess=INPUT (default)
          • BusinessRule=NONE (default)
          • Flow=NONE (default)
        • Typical other configurations are segments that are used in actuals but not in Financials budgeting/ forecasting like:
          • Project / GL_Project
          • Customer
      • Note: If these settings are changed and you would like to use the new settings, you will need to re-copy your data.

Other functions in Scenario:

  • Process - All Processes or select specific process to show only relevant Scenarios.
  • Show Inactive - to show inactive scenarios
  • Actual Overwrite - Actual data will replace the current data stored in this Scenario when “Refresh Actual Data” button is pressed.
    • Actual data is defined as all data for the fiscal year up to and including “Closed Month” on the Actual Scenarioor the target Scenario (whichever is earlier).
      • Example 1: If Closed Month of Actual is 2020-07 and Closed month of Forecast is 2020-09, the copy will be from 2020-01 - 2020-07 making sure Actuals from non-closed periods are not copied.
      • Example 2: If Closed Month of Actual is 2020-10 and Closed month of Forecast is 2020-09, the copy will be from 2020-01 - 2020-09 making sure Forecast is not inadvertently overwritten with unwanted Actuals.
    • If applicable (checked) - Scenario Simplification is applied.
  • Auto Actual Refresh - actual will be automatically refresh over night (similar to press “Refresh Actual Data”). Note: make sure to tick Actual Overwrite.
  • Input Allowed - allow input by users.
  • Auto Save on Close - a copy of this Scenario will automatically be saved under a new name whenever closed month is changed.
    • Data included in the copy is based on the Closed Month as set before the change, and includes the Fiscal Year of that month and previous Fiscal Year.
    • Example: with fiscal year April - March
      • A copy of Scenario “Forecast” would be saved as “Forecast 2018-07” when Closed month is switched from 2018-07 to 2019-02.
      • This copy will include data from 2017-04 (opening of previous fiscal year) with no upper time limit.
  • Drill To Scenario Controls the “Drill to Journal data” feature. Example: ACTUAL stores ACTUAL data. An ACTUAL REPORT Scenario has been created for report freeze. Journal Data only exists for ACTUAL. This parameter should then be set for ACTUAL for the ACTUAL REPORT Scenario to get drill to work as expected.
  • Drill Date Limit Controls the “Drill to Journal data” feature. With this parameter you can limit the user to be able to drill into Journal data only prior to this date.
  • Active - to inactive a scenario, un-tick here.
  • New Scenario - to add a new scenario.
  • Delete Scenario - select the scenario you want to delete, then click on Delete Scenario.
  • Refresh Actuals - select the scenario where you want to update the Actuals, then click on Refresh Actuals.
    • This will update Actuals for the fiscal year up an until the closed month of the Actual Scenario or the target Scenario (whichever is earlier).
    • Note: make sure that Actual Overwrite is ticked.

The button shows the settings where you can control having simplified dimensionality for certain scenarios.

  • The settings are made by DataClass for each dimension. This means you can have different simplifications for different DataClasses.
    • Note: DataClasses are where data is stored in EFP. Examples of DataClasses are
      • Financials (that hold GL Data and related budgets and forecasts)
      • Assumptions (that may hold Assumption data used in budgets and forecast)
      • Sales (that hold Sales subledger and related budgets and forecasts)
    • Example: If Budgets and Forecast in Financials are not made by GL_ReferenceCode this can be set to NONE. This will have the effect when data is copied to a scenario that is marked with “Simplified Dimensionality” from a Scenario that does not have “Simplified Dimensionality” selected.
  • When using Simplification certain dimensions are always simplified:
    • BusinessProcess is set to INPUT
      • Note: For LineItemDetails the BusinessProcess setting will remain correct.
    • BusinessRule is set to NONE
    • Flow is set to NONE
  • LineItem and Version are never simplified.
  • We recommend not to use simplification in any normal cases for the following dimensions
    • Currency - which will sum up values in multiple currencies to one. This should be used with great care in special cases only.
    • Entity - which will sum up values in multiple legal entities/ books to one. This should be used with great care in special cases only.
  • v2/admin/wftreescenario.txt
  • Last modified: 2021/10/07 08:42
  • by dspanel