Task 2: Creating and uploading a scenario file

In this task, you generate a scenario file and populate it offline. Then, you upload the file for use in the simulation.

About this task

You create a scenario file that holds loan data for the simulation that you run on Miniloan Service. You generate a file, download it to your computer, and add data. The scenario file is generated in the Excel Workbook (.xlsx) format.

When you complete the scenario file, you upload it to the Business console. You can use the file in more than one simulation configuration, and in different instances of the Business console.

Step 1: Creating a scenario file

In this step, you assemble the miniloan-simu scenario file.

Before you begin

If you have Decision Center installed on your computer, you can skip this step, and upload the miniloan-simu.xlsx file from the following directory: <InstallDir>/teamserver/tutorials.

Procedure

  1. Open the Data subtab in the Simulations tab.
  2. Click the Generate Scenario File button "" .
  3. Enter miniloan-simu as the file name. Leave the default settings:
    • Operation: Miniloan ServiceOperation
    • Scenario file format: Excel Workbook (.xlsx)
    • Locale: English (United States)
  4. Click Download, and save the file to a directory on your computer, for example, <InstallDir>/miniloanservice-projects.
  5. Open the miniloan-simu.xlsx file in Excel or OpenOffice.
    The expected values of the rules in the decision service determine the contents of the scenario file:
    Image shows the layout of the scenario file.

    Each row is a scenario that represents a loan request from a customer.

  6. Enter the following values into the file. After you enter the values for the first scenario, duplicate the row to create the following scenarios.
    Image shows the data for the simulation.
  7. Save your changes and close the scenario file.

Step 2: Uploading a scenario file

In this step, you upload the scenario file to use it in your simulation.

Procedure

  1. Return to the Data subtab, and click the Create button "".
  2. Enter Miniloandata as the name, and select Miniloan ServiceOperation as the operation.
  3. Click Choose, navigate to the miniloan-simu.xlsx file, and then click Open.
  4. Click Create to add the data file to the Data tab.

What to do next

In the next task, you format a report for your simulation.