Transcript Dashboard Design What
SAP UA Version: 1.1
Author: Sonja Hecht, UCC Munich
SAP Crystal Dashboard Design What-if Scenarios
Product SAP Crystal Dashboard Design, personal edition Level Undergraduate Beginner
Abstract This module provides you an overview on how to create what-if scenarios using different single value components.
© 2009 SAP AG
Dashboard Design What-if scenarios
Agenda • •
What-if scenarios
Case study: Sales Simulation
SAP University Alliances © 2009 SAP AG Page 2
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
What-if scenarios
• •
What-if scenarios let users adjust conditions on the dashboard and view the results, conditions are altered by interactive components What-if scenarios include one or more input component and one or more output components
• •
Examples: Calculation of the monthly rate for a home loan, based on different conditions like loan amount, term in years and interest rate Calculation of the average profit margin, based on different conditions including gross sales, discount and costs
© 2009 SAP AG Page 3
Dashboard Design What-if scenarios
What-if scenarios
Example 1: Calculation of a monthly rate for a home loan
SAP University Alliances © 2009 SAP AG
Source: (Business Objects 2008)
Page 4
Dashboard Design What-if scenarios
What-if scenarios
Example 2: Calculation of the average profit margin
SAP University Alliances © 2009 SAP AG Page 5
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
MVC Pattern used as basis for What-if scenarios
Controller
View (befor adjustment) View (after adjustment)
Model © 2009 SAP AG Page 6
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Input components - overview
• • • •
Dial, Slider, Spinner, Gauge, Value and Play Control are suitable as input components Input components need to be linked to cell including a plain value, not a formula!
The scale of input components is limited by maximum and minimum values, limits can be entered manual, linked to a cell in the spreadsheet, or determined automatically During runtime, limits can be defined as fix, adjustable by the user, or as open, meaning there is no limit
© 2009 SAP AG Page 7
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Input components – scaling
• • •
Manual Scaling Fix value or link to a cell Auto Scaling Value based: limits comprise a range around the value Zero based: value is upper limit and zero is lower limit Zero centered: range comprises value and its negative, zero is the center point Alert based: limits comprise a range based on the selected alert method Possible user interaction with limits Fixed: user cannot change limits Adjustable: user can change limits Open: no limits, range is open
© 2009 SAP AG Page 8
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Output components
• • •
Charts, Single Value components (Progress bar, Gauge, Value) Output Components can be linked directly to the cell that is changed by an input components, or a cell that refers to the input cell by a formula Single value output components have the same limit properties than input components, input and output limits should correspond to each other!
© 2009 SAP AG Page 9
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Setting up the business scenario for a sales simulation Step 1: Define the depended and independent variables of your simulation scenario Step 2: Decide if you want to use absolute values or percentages as input/output values Result of step 1 + 2:
© 2009 SAP AG
Input (%), Output (absolute) Input (%), Output (absolute) Output (absolute) Input (%), Output (absolute) Output (absolute, %)
Page 10
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Setting up the business scenario for a sales simulation Step 3: Create a paper based draft of the visual model that presents your simulation General example for draft:
Progress Bar 1 © 2009 SAP AG Progress Bar 2
Dial to manipulate progress bar 2
Progress Bar 3 Page 11
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Setting up the business scenario for a sales simulation Step 4: Create the underlying spreadsheet model for your input/output components Initial starting values Conditions that can be adjusted using a dial
© 2009 SAP AG
Adjusted values that are displayed as output values
Page 12
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Setting up the business scenario for a sales simulation • • • Step 5: Defining limits for your simulation model in the spreadsheet Limits can be based on the initial values and calculated in the spreadsheet E.g. the user is able to increase gross sales to a maximum of 200 % • Limit for gross sales in % = 200 % • Limit for gross sales absolute = 2 * original value of gross sales Example:
© 2009 SAP AG Page 13
SAP University Alliances Dashboard Design What-if scenarios
What-if scenarios
Setting up the business scenario for a sales simulation Step 6: Create the visual model for your simulation on the canvas and bind data to the input/output components
© 2009 SAP AG Page 14
Dashboard Design What-if scenarios
Agenda • •
What-if Scenarios
Case study: Sales Simulation SAP University Alliances © 2009 SAP AG Page 15
Dashboard Design What-if scenarios
Sales Simulation
• • •
Start with case study: Sales Simulation Use file Simulation.xls as spreadsheet model Duration: 1,5 h
SAP University Alliances © 2009 SAP AG Page 16