Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tasks : Using Historical Data for Activity Duration

Using Historical Data for Activity Duration
As part of setting up a Process for simulation, you specify the duration of the Activities in the Process using a mathematical distribution (for example, Normal distribution). Alternatively, TIBCO Business Studio allows you to import any real historical data (for example, from log files) that you have about activity duration.
 
Task A Create the Import File
Create an Excel spreadsheet with the data that you want to import. The first row of cells corresponds to the parameter names. Each column under the first row represents the parameter values you wish to import. For example:
In this example, the parameter Existing Customer? can have the values Yes or No.
You can include any number of other columns for import, but be careful to avoid stray data in columns that you do not plan to import.
Task B Import the Data
To import the spreadsheet containing your historical data, do the following:
1.
2.
Select Historical Case Data (Activity Duration).
3.
4.
Either click Browse or Browse Workspace to locate the Excel file. Press the Tab key (this activates the Next button). Click Next.
5.
The Select Parameters dialog is displayed.
In the Map Activity Names: section, map the Activities in the spreadsheet to those in the Process.
Click Next.
6.
The next dialog allows you to map any parameters not already used in the previous dialog onto Activities in the Process. Click Next.
7.
use the imported data, depending on a parameter setting - select the Activity and select the Parameter that will be used to determine which values to use.
Clicking on each row gives the values, average duration and deviation from the average.
8.
Click Finish.
9.
The Simulation Properties view for Activities for which the duration is taken from the imported data show information about the parameter names and values. For example:

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved