Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By : David Lai
Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By: David Lai

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
16
Index

What-if scenario – Mortgage Calculator

In this recipe, we will create a what-if scenario dashboard. The purpose of the dashboard is to calculate and show the monthly payments and the total cost of a mortgage, based on a set of adjustable variables.

What-if scenario – Mortgage Calculator

We will use techniques from the following chapters and recipes:

  • Chapter 1, Staying in Control
  • The Using sliders to create a what-if scenario recipe from Chapter 3, From a Static to an Interactive Dashboard
  • The Selecting your data from a list recipe from Chapter 3, From a Static to an Interactive Dashboard
  • The Illustrating single values recipe from Chapter 2, Data Visualization
  • The Using a pie chart recipe from Chapter 2, Data Visualization
  • Chapter 7, Dashboard Look and Feel

Getting ready

As we are starting from scratch, you only have to open a new SAP BusinessObjects Dashboard file.

How to do it...

  1. The dashboard will contain four variables: Mortgage amount, Mortgage term in years, Yearly interest rate, and a variable that states whether the mortgage...