Task 2: Creating and uploading a scenario file

You generate a scenario file, and add data to it offline. Then, you upload the file for use in simulations.

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 in Excel or OpenOffice. When you complete the scenario file, you upload it back to the Business console. You can use the file in more than one simulation configuration, and in different instances of the Business console.

Attention: To work on the scenario file, you must have OpenOffice, or Excel 2007 or later.

Step 1: Creating a scenario file

The following steps show you how to make the miniloan-simu scenario file. Alternatively, you can skip this step and use the miniloan-simu.xlsx scenario file in the sample project downloaded from the cloud portal.

Procedure

  1. Open the Data subtab in the Simulations tab.
  2. Click the Generate Scenario File button "".
  3. Provide the following information in the dialog box:
    • File name: miniloan-simu
    • Operation: Miniloan Service Operation
    • Scenario file format: Excel Workbook (.xlsx)
    • Locale: English (United States)
  4. Save the file to a directory on your computer, for example, <Install Dir>/Miniloan Service/.
  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 scenario row represents a loan application 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.
    Tip: Instead of completing the table, if you downloaded the sample project, you can use the included miniloan-simu.xlsx scenario file to complete the tutorial.
    Image shows the data for the simulation.
  7. Save your changes and close the scenario file.

Step 2: Uploading a scenario file

You upload the miniloan-simu.xlsx 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 Service Operation as the operation.
  3. Click Choose, navigate to the miniloan-simu.xlsx file, and then click Open.
    Tip: If you have skipped step 1, you can find the premade scenario file at the following location on your computer: <Install Dir>/Miniloan Service/miniloan-simu.xlsx.
  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.