Please see the SAP Analytics Approach document, section 'Documentation' for more information about the context of this document.
It is to be populated by the story owner and the reporting functional consultant collaboratively.
It does NOT describe business logic e.g. KPI definitions delivered by the data models (e.g. analytic models) that it consumes. This is covered in the Data Model Functional Specification
If a requirement is for a flat table, then this will be delivered as a story and this document may simply show the order of the columns. Where more detailed requirements for a story layout are known, this template will capture these requirements.
As story building is an iterative and agile process, it is expected that this document will be updated through the development process.
| Status | |
|---|---|
| Functional Specification Owner | CONNELLY-ext, Delia |
| Stakeholders | |
| Jira Request ID | [ERP-125] Business Case form to capture Project Financial Indicators - Jira |
| Jira Development (Build) ID | [ERP-263] Business Case form to capture Project Financial Indicators - Jira |
| Lean IX App Link | To be added when development reaches UAT |
| Business Process Reference (L4) | 10.01.03.01. Manage Initiatives and Items | Signavio |
| Parameter | Value |
|---|---|
| Application System (Delivery Tool) | SAC Story |
The Project Business Case captures key financial information about a project in a simplified and standardized format to enable:
The Business Case includes:
The Project Business Case must be completed for all financially driven projects.
This section is predominantly for planning stories and can be deleted if not applicable. Insert the flowchart and fill in the steps. The flowchart will detail how (it is anticipated) that the user will navigate through the screens and what order they will perform activities.
Step | Description | Comment |
|---|---|---|
| 1. | Enter Project Cost | Project Cost is required for all Portfolio Items and is a prerequisite for the Business Case. |
| 2. | Provide inputs to the Business Case | Mandatory inputs to the Business Case are completed and interim calculations made. |
| 3. | Financial Indicators are calculated | Financial Indicators such as NPV, MIRR and VCI are calculated from the business case inputs. |
| 4. | Project Score is calculated | The Project Score is calculated based on the financial indicators |
Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant
The Project Business Case incorporates data drawn from the following sources:
An Overview Page for Portfolio Item Planning & Reporting will provide a link to the Business Case, which is part of a multi-page 'Portfolio Item Planning' story. This Story manages Cluster, Item and WBS level planning.
The Story pages are defined across the following Functional Specifications:
| Story | Page # | Page | Functional Specification |
|---|---|---|---|
| Portfolio Item Planning | 1 | Project Cost (Item) | ERP-669 SAC Planning Portfolio Items |
| 2 | Project Cost (Cluster) | ERP-669 SAC Planning Portfolio Items | |
| 3 | Business Case (Item/Cluster) | ERP-263 SAC Project Business Case | |
| 4 | Detailed Planning (Item) | ERP-670 SAC Planning WBS Elements |
Further related Stories are access via the same Overview Page:
| Story | Page # | Page | Functional Specification |
|---|---|---|---|
| FY Budget Request | 1 | FY Budget Request (Item/Cluster) | ERP-669 SAC Planning Portfolio Items |
| |||
|
Input of Business Case
Report Field Name | Mandatory/Optional | Prompt Type (Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy) | Default Value(s) or Restrictions (please provide default value) |
|---|---|---|---|
| Item Id | Mandatory | Single Value Select from Hierarchy with option to filter by Item attributes such as Description, Person Responsible |
(Only if not possible within Datasphere).
This section will contain a wire-frame of the page indicating the widgets on it. The wire-frame can be a draw-io diagram or a screenshot of e.g. an excel mock-up.
If there are multiple data models in the story, indicate which data models the widget takes data from at page or widget level.
Widget level details such as filters, dimensions, hierarchy usage, history, comparatives, targets, thresholds, top N etc can also be included. N.B. This level of detail is not mandatory and often changes through the iterative development process. For tables, indicate the number of expected rows.
Refer here for a mock-up of the Business Case: Business Case Template - Google Sheets
If multiple data sources consumed by story:
Widget | Data Model | Field | Filter |
|---|---|---|---|
Header | PPM_ITEM | Project Name: CGPL_TEXT-TEXT1 | |
| PPM_ITEM | Project ID /RPM/ITEM_D-EXTERNAL_ID | ||
| PPM_ITEM | Project Owner: /RPM/ITEM_D-ZXX14 | Derive Personnel Name from Position | |
| PPM_ITEM | /RPM/ITEM_D-CATEGORY | Retrieve description from RPM_PROJ_CAT | |
0. Preliminary Information | PPM_ITEM | Year of Project Kick-Off | Mandatory, format YYYY Default to year of /RPM/ITEM_D-PLANNED_START |
| PPM_ITEM | First Year of Commercial Sales | Optional, format YYYY If entered, must be >= Year of Project Kick-Off | |
| PPM_ITEM | Time to Full Maturity (Years) | Optional, integer If entered, must be >= 0 | |
| PPM_ITEM | Discount Rate (WACC) | Mandatory, format % Must be >= 0 and <= 100 If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where: /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV' /SYQ/T_SCORING_PARAMS-PARAM = 'Discount Rate/WACC' | |
| SCORING_PARAMETERS | 'Years for NPV Calculation' value: /SYQ/T_SCORING_PARAMS-PARAM_VALUE | /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV' /SYQ/T_SCORING_PARAMS-PARAM = 'Years for NPV Calculation' | |
| PPM_ITEM | Currency | Mandatory Default to Group Currency (EUR) and allow to switch to Item currency (/RPM/ITEM_D-CURRENCY) | |
| Currency Multiplier | Mandatory Select from list (1's, 1,000's, 1,000,000's) Default to 1000's | ||
| PPM_ITEM | End Year for NPV Calculation | Calculated: If First Year of Commercial Sales = 0 then Year of Project Kick-Off + Years for NPV Calculation Else First Year of Commercial Sales + Years for NPV Calculation | |
| PPM_ITEM | Probability of Commercial Success | Optional, format % If entered, must be >= 0 and <= 100 | |
| PPM_ITEM | Probability of Technical Success | Optional, format % If entered, must be >= 0 and <= 100 | |
| PPM_ITEM | Risk Adjustment | Mandatory, format % Must be >= 0 and <= 100 | |
| PPM_ITEM | Working Capital/Sales Ratio | Mandatory, format % Must be >= 0 and <= 100 If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where: /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV' /SYQ/T_SCORING_PARAMS-PARAM = 'Working Capital/Sales Ratio' | |
| PPM_ITEM | EBITDA at Maturity | Optional, format as per Currency | |
1. Project Cost | PPM_ITEM | Project Cost - Opex: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Filter:
|
| PPM_ITEM | Project Cost - Capex: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Filter:
| |
| Total Project Costs | Display-only, format as per Currency Calculated: (Project Cost - OPEX) + (Project Cost - CAPEX) | ||
2. Project P&L Impact | PPM_ITEM | Unit | Mandatory Select from list of defined UOM |
| PPM_ITEM | Product Volumes Unit: /RPM/FIN_PLAN-UNIT | Display-only, same as selected Unit Filter:
| |
| PPM_ITEM | Product Volumes: /RPM/FIN_PLAN-QUANTITY | Optional, format as quantity in selected Unit Filter:
| |
| PPM_ITEM | Product Selling Price Unit: /RPM/FIN_PLAN-UNIT | Display-only, derived as Currency / Unit Filter:
| |
| PPM_ITEM | Product Selling Price: /RPM/FIN_PLAN-AMOUNT | Optional, format is Currency per selected Unit Filter:
| |
| PPM_ITEM | Sales Forecast: /RPM/FIN_PLAN-AMOUNT | Display-only Calculated per year: Product Volumes * Product Selling Price Filter:
| |
| PPM_ITEM | Product Variable Cost: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Product Selling Price Filter:
| |
2. Project P&L Impact | PPM_ITEM | Contribution: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: Product Volumes * (Product Selling Price - Product Variable Cost) Filter:
|
| PPM_ITEM | Contribution in % of Sales: /RPM/FIN_PLAN-QUANTITY | Display-only, format as % Calculated per year: Contribution / Sales Forecast * 100 Filter:
| |
| PPM_ITEM | Total Fixed Costs: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
| |
| 3. Cash Impacts | PPM_ITEM | Working Capital: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: Working Capital/Sales Ratio * Sales Forecast Filter:
|
| PPM_ITEM | Change in Working Capital: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: Sales Forecast this year - Sales Forecast last year Filter:
| |
| PPM_ITEM | Other Cash Impacts: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
| |
| 4. Subsidies | PPM_ITEM | Subsidy: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
|
| 5. Interim Calculations | Year XXXX - Year YYYY | Display only Year XXXX = Year of Project Kick-Off Year YYYY = End Year for NPV Calculation | |
| PPM_ITEM | Discount Period from Kick-Off: /RPM/FIN_PLAN-QUANTITY | Display-only, format as per Currency Calculated per year: If Year < Year of Project Kick Off or > End Year for NPV Calculation then zero Else If previous year Discount Period > 0 then Add 1 to previous year Discount Period Else Add 0.5 to previous year Discount Period Filter:
| |
| PPM_ITEM | Cashflow: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: If Year < Year of Project Kick Off or > End Year for NPV Calculation then zero Else Contribution - Total Project Costs - Change in Working Capital - Other Cash Impact Filter:
| |
| PPM_ITEM | Discounted Cashflow: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: Cashflow / (1 + Discount Rate) ^ Discount Period from Kick-Off Filter:
| |
| PPM_ITEM | Risk Adjusted Contribution: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: If Year < Year of Project Kick Off or > End Year for NPV Calculation then zero Else Contribution * Risk Adjustment % Filter:
| |
| PPM_ITEM | Risk Adjusted Cashflow: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: If Year < Year of Project Kick Off or > End Year for NPV Calculation then zero Else Risk Adjusted Contribution - Total Project Costs - Change in Working Capital Filter:
| |
| PPM_ITEM | Risk Adjusted Discounted Cashflow: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: Risk Adjusted Cashflow / (1 + Discount Rate) ^ Discount Period from Kick-Off Filter:
| |
| PPM_ITEM | Cumulative Discounted Cash Flow: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Calculated per year: If Year < Year of Project Kick Off or > End Year for NPV Calculation then zero Else Risk Adjusted Cashflow for this year + Cumulate Discounted Cash Flow for Filter:
| |
| PPM_ITEM | Payback Period (Days): /RPM/FIN_PLAN-QUANTITY | Display-only, format as per Currency Calculated per year: If Cumulative Discounted Cash Flow = 0 then zero ElseIf Cumulative Discounted Cash Flow < 0 then 365 ElseIf previous year Cumulative Discounted Cash Flow > 0 then zero Else (previous year Cumulative Discounted Cash Flow * -1) / (Cumulative Discounted Filter:
| |
| 6. Financial Indicators | PPM_ITEM | Year XXXX - Year YYYY | As above |
| PPM_ITEM | NPV (Net Present Value) | Display-only, format as per Currency Calculated: Sum (Discount Cashflow) for all years | |
| PPM_ITEM | Risk Adjusted NPV | Display-only, format as per Currency Calculated: Sum (Risk Adjusted Discount Cashflow) for all years | |
| PPM_ITEM | MIRR (Modified Internal Rate of Return) | Display-only, format as per Currency Calculated: MIRR (Sum (Discounted Cashflow) for all years, Discount Rate, Discount Rate) | |
| PPM_ITEM | Discounted Payback Period | Display-only, format as per Currency Calculated: Sum (Playback Period for all years) / 365 | |
| PPM_ITEM | VCI (Value Creation Index) | Display-only, format as per Currency Calculated: NPV / Sum (Total Project Costs) for all years between kick off to NPV calc? | |
| PPM_ITEM | Project Score | Display-only, numeric Refer to FS-??? for the calculation | |
| 7. Comments and Justification | PPM_ITEM_Long_Text | CGPL_TEXT-LTXT | Optional, long text commentary to support Business Case Filter:
|
As story page N.
Details any filters that apply to the entire story. N.B. Most mandatory (e.g. security variables) should be applied in Datasphere.
Report Field Name | Mandatory/Optional | Prompt Type (Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy) | Default Value(s) or Restrictions (please provide default value) |
|---|---|---|---|
This section lists the data models consumed by the story and links to the functional specification describing them.
| Data Model Technical Name | Data Model Description | Jira Development ID | Link to Data Model Functional Specification |
|---|---|---|---|
| (Filled when available) | Text for data model | ||
List the business roles who will be executing the report
Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant
Describe any assumptions that have been made in the process of completing this design. What functionality is expected of configuration or other developments that pass information to this development and/ or retrieve the information processed by it (performance, triggers, exceptions, etc)
Indicate any dependencies or constraints that may impact development, in terms of requirements from internal or external applications or teams, limited access to legacy system, time constraints or data restrictions. Also, please specify schedule dependencies e.g. interface or batch jobs that must run prior to execution.
Specify any special requirements or considerations that may impact the development based on specific locations, regulatory compliance or system limitations. Clearly outline requirements e.g. localization rules for countries like China
If the development interacts with third-party systems such as Icertis, describe any additional integration, security or authentication considerations that must be taken into account.
Provide information regarding report run frequency like ad-hoc, monthly analysis, weekly, yearly analysis etc.
N.B. Unless this is a planning story, the testing should cover layout and user experience NOT data values for metrics created in the data model. Data model values will be tested in conjunction with the data model specification.
Please provide some guidance and/or test data to help the developer unit test the report. Please include both positive and negative testing (to validate error situations handling)
List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI).
The developer will need to test repeatedly, so where appropriate provide instructions to reverse the actions performed so the test may be run again, or explain how to create new input data to the test. In particular, the developer will need logons for test users representing the various roles within the approval process.
| ID | Condition | Expected Results |
|---|---|---|
List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI). If the development encompasses a user interface, explain how to test it. List any insights as to how this component could be tested the most efficiently.
Description of requirements not covered by topics above
Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.
