![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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 FileCreate 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:
• The spreadsheet must have columns for Activity Name and Duration (though not necessarily with those names).
• 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
1.
2. Select Historical Case Data (Activity Duration).
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.
− use the data specified in the process rather than the imported data - do not select the Activity.
− use the imported data to create a normal distribution - select the Activity, but select IGNORED.
− 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.
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 |