ArganoSCM02 - FGF

Time-Series Analysis Test Script

Table of Contents
1. Purpose
2. Prerequisites
2.1 System Access
2.2 Master Data, Organizational Data, and Other Data
2.3 Business Conditions
2.4 Preliminary Steps
2.4.1 Update Key Figure Data
3. Overview Table
4. Test Procedures
4.1 Run Forecast Automation Using Application Jobs App
4.2 Review Time-Series Analysis Results
4.3 Review Change Point Detection Results
5. Appendix
5.1 Process Integration
5.1.1 Preceding Processes
5.1.2 Succeeding Processes
1. Purpose
Time-series analysis and change point detection allow you to identify patterns in individual time series. This
enables the Demand Planning Process Expert to select the most suitable forecast algorithms.

Several applications of SAP Integrated Business Planning, which work with different time profile levels and
time horizons, may use the same planning area. Therefore, the values of the common key figures must be
aggregated and disaggregated across different time levels.

The aggregation and disaggregation of data across different time levels can be realized by a specific modeling
concept, which is built on the modeling of time profile levels with multiple parents and that of intermediate
levels without parents.

· If you apply this “week-to-months split” modeling concept after weeks and months have been aggregated,
you can aggregate and disaggregate key figure values across different time levels.

This document provides a detailed procedure for testing this scope item after solution activation, reflecting the
predefined scope of the solution. Each process step, report, or item is covered in its own section, providing the
system interactions (test steps) in a table view. Steps that are not in scope of the process but are needed for
testing are marked accordingly. Project-specific steps must be added.
2. Prerequisites

2.1 System Access

System

SAP Integrated Business Planning web user interface

SAP Integrated Business Planning, add-in for Microsoft Excel

2.2 Master Data, Organizational Data, and Other Data

The organizational structure and the master data of your company were created in your system during
activation. The organizational structure reflects the structure of your company. The master data
represents products, customers, and suppliers, for example, depending on the operational focus of your
company.
Use your own master data or the following sample data to go through the test procedure.

Data

<Planning Area>

2.3 Business Conditions

Before this scope item can be tested, the following business conditions must be met.
Scope Item ID

1S6 - IBP – ABC-XYZ Segmentation

2.4 Preliminary Steps

2.4.1 Update Key Figure Data
Use
As described in the Time-Series-Based Planning - Data Integration (12H) configuration guide, sample
data files have already been uploaded during the configuration phase of this Best Practices solution.
However, it's likely that time-dependent sample data (for example, key figure CSV files) needs to be
updated at the beginning of each cycle of the business processes supported.
Refer to the Time-Series-Based Planning - Data Integration (12H) configuration guide on how to adapt
and upload key figure CSV files periodically for IBP for demand – time-series analysis (34Y) (this scope
item).
Details
Accessible via SAP Fiori launchpad. Your system
administrator provides you with the URL to access the
various apps assigned to your role.
URL: https://my307052.scmibp1.ondemand.com
To access planning views in Microsoft Excel.
Connection Name: FGFUPAPRD
URL: https://my307052.scmibp1.ondemand.com
Planning Area: FGFUPAPRD

Comment
Sample Value Details
s
FGFUPAPRD

Business Condition
The ABC-XYZ Segmentation application job is finished.
The results of the segmentation run are stored as values (for
example, A, B, C) of master data attributes. You can use
these values to generate reports or define alerts for the
segments that you select. For example, you can check time
series properties for a specific product segment in a chart in
the Dashboards Advanced app.

You can also use the segmentation results to filter the set of
planning objects in the SAP Integrated Business Planning,
add-in for Microsoft Excel and in the Assign Forecast Models
app.
4. Test Procedures
This section describes test procedures for each process step that belongs to this scope item.

4.1 Run Forecast Automation Using Application Jobs App

Test Administration
Customer project: Fill in the project-specific parts.

Test Case ID <X.XX>

Business Role(s) Demand Planning Process Expert (IBP)

Responsibility FGF and SCMO2
Purpose
The Demand Planning Process Expert uses the Application Jobs app to start the forecast automation run with both the chang
Note
Carrying out the forecast automation run as described here is only for testing purposes. In a productive environment,
Procedure

Test Step # Test Step Name

Log on to SAP Integrated Business

1.
Planning

2. Open Application Jobs App

3. Create Job

4. Enter Parameters

5. Schedule Job
6. Check Job Status

4.2 Review Time-Series Analysis Results

Test Administration
Customer project: Fill in the project-specific parts.

Test Case ID <X.XX>

Business Roles Demand Planning Process Expert (IBP)

Responsibility FGF and SCMO2
Purpose
The results of the time-series analysis are stored as values (for example, continuous or irregular) in the TIMESERIESPROPERT
· Planning views in the SAP Integrated Business Planning, add-in for Microsoft Excel
· Analytics

You can check the Time-Series Analysis dashboard to review the results. The dashboard includes the following charts:
· Distribution of Time Series Property
· Distribution of Time Series Property per ABC Segment
Procedure

Test Step # Test Step Name

Log on to SAP Integrated Business

1.
Planning web user interface

2. Open the Dashboard Advanced app

Select Time-Series Analysis

3.
dashboard

Display Distribution of Time Series

4.
Property chart

5. Analyze data

6. Close Analytics Details tab

Display Distribution of Time Series

7.
Property per ABC Segment chart

8. Analyze data

9. Close Analytics Details tab

14. Choose Home

4.3 Review Change Point Detection Results

Test Administration
Customer project: Fill in the project-specific parts.
Test Case ID <X.XX>

Business Roles Demand Planning Process Expert (IBP)

Responsibility FGF and SCMO2
Purpose
Change points are data points at which long-term significant changes can be observed in the characteristics of the time seri
You can check the Change Point table to review the results for all planning objects that were analyzed on the selected calcu
· The planning objects for which the time series was analyzed
· The number of change points identified for each planning object
· The time series properties identified for each planning object
Procedure

Test Step # Test Step Name

Log on to SAP Integrated Business

1.
Planning web user interface

Open Manage Forecast Automation

2.
Profiles app
3. Select forecast automation profile
4. Choose Show Analysis Results

5. Choose Change Points

Select a Customer-Location-Product
6.
combination

7. Choose Ok

8. Choose Show Distribution

9. Choose Ok
10. Choose Home
h process step that belongs to this scope item.

ation Jobs App

Tester Name

Expert (IBP)

Application Jobs app to start the forecast automation run with both the change point detection and the time-series analysis options act

n as described here is only for testing purposes. In a productive environment, a forecast automation batch job will be scheduled to run a

Instruction

Log on to the SAP Integrated Business Planning web user interface.

Open the Application Jobs app by clicking the corresponding tile.

Choose Create.
The New Job screen is designed as a guided procedure that comprises several main
sections. You can sequentially navigate through the individual sections by filling in
the required data and then choosing Step x where x is the number of the next step.
Enter the following data:

Template Selection
Job Template: 0013 FGF Time-series Analysis - FGFUPAPRD

Click on Step 2.
Click on Step 3.

Choose Schedule.
Choose Go to refresh the job status until the status is set to Finished.

Tester Name

Expert (IBP)
 ed as values (for example, continuous or irregular) in the TIMESERIESPROPERTY attribute of the SOURCECUSTOMER master data type (i
usiness Planning, add-in for Microsoft Excel

oard to review the results. The dashboard includes the following charts:

ABC Segment

Instruction

Log on to the SAP Integrated Business Planning web user interface.

Open the Dashboards Advanced app from the corresponding tile on the launchpad.

Select the FGF Time Series Analysis - PRD dashboard by choosing its name.

In the upper right corner of the Distribution of Time Series Property chart, choose
Go to Analytics Details.

Analyze the data.

19.79% of the Product-Customer-Location combinations show a Continuous
demand pattern.

Close the Analytics Details tab and return to the Dashboard screen.

On the Distribution of Time Series Property per ABC Segment chart, choose Go to
Analytics Details. Click this Icon

Analyze the data.

1874 products in segment A show a continuous demand.

Close the Analytics Details tab and return to the Dashboard screen.
Choose Home.
 Tester Name

Expert (IBP)

erm significant changes can be observed in the characteristics of the time series. They either mark a level shift or a trend change.
w the results for all planning objects that were analyzed on the selected calculation level. The table shows:
series was analyzed
for each planning object
each planning object

Instruction

Log on to the SAP Integrated Business Planning web user interface.

Open the Manage Forecast Automation Profiles app from the corresponding tile on
the launchpad.
Select your Forecast Automation Profile.
On the upper right part of the screen, choose Show Analysis Results.
Choose Change Points.

Select a Customer-Location-Product combination with change points.

Choose Ok to go back.

Go back to the time-series properties tab. Choose Show Distribution.

Choose Ok to go back.
Choose Home.
 Testing
Date

Duration

detection and the time-series analysis options activated.

cast automation batch job will be scheduled to run automatically..

Pass /
Expected Result Fail /
Comment
The SAP Fiori launchpad as the access point to all
web-based applications for SAP Integrated
Business Planning is displayed. Apps are displayed
as tiles.

The New Job screen is displayed.

Testing
Date
 Duration

bute of the SOURCECUSTOMER master data type (in the case of sample planning area FGFUPAPRD). You can use them as filters in multi

Pass /
Expected Result Fail /
Comment
The SAP Fiori launchpad as the access point to all
web-based applications for SAP Integrated
Business Planning is displayed. Apps are displayed
as tiles.

The Dashboard List screen is displayed.

The Time-Series Analysis dashboard is displayed.

The Analytics Details tab is displayed.

On the Analytics Details screen, the Distribution of
Time Series Property chart is displayed.

The chart displays which percentage of the

Product-Customer-Location combinations belongs
to which time series property.

The Dashboard screen is displayed.

The Analytics Details tab is displayed.

On the Analytics Details screen, the Distribution of

Time Series Property per ABC Segment chart is
displayed.

The chart displays the distribution of Product-

Customer-Location combinations to time series
properties and ABC segments.

The Dashboard screen is displayed.

The SAP Fiori launchpad is displayed.
 Testing
Date

Duration

y either mark a level shift or a trend change.

evel. The table shows:

Pass /
Expected Result Fail /
Comment
The SAP Fiori launchpad as the access point to all
web-based applications for SAP Integrated
Business Planning is displayed. Apps are displayed
as tiles.
The Forecast Automation Profiles screen is
displayed.
Select "Time Series Analysis - FGFUPAPRD"

The table shows the results for all planning objects

analyzed:
· The planning objects for which the time
series was analyzed
· The number of change points identified for
each planning object
· The time-series properties identified for
each planning object
A trend chart shows the time series changes
between periods and also which changes are
identified by the system as change points.

A pie chart shows how the change points are

distributed among the planning objects.
Note: If there are many items with a lot of change
points, you might need to adjust the thresholds
configured.

The SAP Fiori launchpad is displayed.

Click here to enter a date.

15 min

Must to run from SAP FIORI

Click here to enter a date.

 15 min

f sample planning area FGFUPAPRD). You can use them as filters in multiple areas:
Click here to enter a date.

15 min
3. Overview Table
This scope item consists of several process steps provided in the table below.
Process Step

Run Forecast Automation using Application Jobs App

Review Time-Series Analysis Results

Review Change Point Detection Results

Business Role App/Transaction Expected Results
The time series are
analyzed and classified by
Demand Planning
Application Jobs app their time-series properties
Process Expert (IBP)
and the change points are
identified.
The dashboard shows the
Demand Planning Dashboards Advanced
results of the forecast
Process Expert (IBP) app
automation run.
The app shows the results
Demand Planning Manage Forecast
of the forecast automation
Process Expert (IBP) Automation Profiles app
run.
4.1 Run Forecast Automation Using Application Jobs App

1.

2.

4.
5.

6.

4.2 Review Time-Series Analysis Results

1.
2.

3.

4.

8.
9.

4.3 Review Change Point Detection Results

1.

2.
3.

4.

5.
6.

8.

9.
5. Appendix
5.1 Process Integration
The process to be tested in this test script is part of a chain of integrated processes.

5.1.1 Preceding Processes

You may first have completed the following processes and conditions before you start with the test steps:
Process

IBP – time-series-based inbound integration with SAP S/4HANA (3OF)

IBP – ABC-XYZ Segmentation (1S6)

IBP for demand – demand planning (11V)

5.1.2 Succeeding Processes

After completing the activities in this test script, you can continue testing the following business processes:
Process

IBP for demand – demand planning (11V)

IBP – ABC-XYZ Segmentation (1S6)

processes.

ore you start with the test steps:

Business Condition
If time-series-based integration (using SAP Cloud Integration for
data services) is implemented, master data transferred from SAP
S/4HANA is used in all time-series-based SAP IBP business
processes.
The results of the IBP – ABC-XYZ Segmentation (1S6) process are
used in time-series analysis charts.
The results of the IBP for demand – demand planning (11V)
process are used in time-series analysis charts

the following business processes:

Business Condition
The IBP for demand – time-series analysis (34Y) process is an
optional preceding process to the forecasting process.
The results of the IBP for demand – time-series analysis (34Y)
process can optionally be used as input to the IBP – ABC-XYZ
Segmentation (1S6) process.