1. User Guide
  2. Managing Administration
  3. Managing Profitability Curve Definition
  4. Adding Profitability Curve Definition

5.6.1 Adding Profitability Curve Definition

You can navigate to the Profitability Curve Definition Screen by clicking the Upload icon on the Profitability Curve Definition Summary screen.

Figure 5-19 Profitability Curve Definition Objects Screen


Profitability Curve Definition Objects Screen

The Profitability Curve Definition Objects screen displays the following tables:
  • FSI_M_OBJECT_DEFINITION_B
  • FSI_M_OBJECT_DEFINITION_TL
  • FSI_PM_PROFITABILITY_DEF
  • FSI_PM_CURVE_CHECK_DETAILS
  • FSI_PM_PROFITABILITY_VALUE
  • FSI_PM_PROFITABILITY_DIMENSION
  • FSI_PM_CURV_DRIVER_DETAIL
When you want to upload the Profitability Curve Definition, you need to upload the data from an excel sheet in the same order as displayed in the Profitability Curve Definition Objects screen. After you upload the last excel sheet without any errors, then you can see the updated Profitability Curve Definition in the Summary screen.

Note:

The current implementation of Price Creation and Discovery application supports only the Comma Separated Values (.CSV) file to upload the product parameters.

Also, note that the uploading order must be same as displayed in the Profitability Curve Definition screen.

To upload new card rate definition, follow these steps:
  1. Click FSI_M_OBJECT_DEFINITION_B to display the Upload Product Parameters File screen.

    Figure 5-20 Upload Product Parameters


    Upload Product Parameters

  2. Click Choose File to open the Open window. Select the FSI_M_OBJECT_DEFINITION_B.csv file from your local machine. The screen displays the data from the selected file on the screen. This data is temporary in nature and is not yet uploaded to the FSI_M_OBJECT_DEFINITION_B table.

    Note:

    The column count and order in the CSV file must be same as the table’s columns and order. And blank columns are not allowed.
  3. Click the Load Data button to upload the data to the FSI_M_OBJECT_DEFINITION_B table. Alternatively, click Cancel to cancel the upload.
  4. Repeat the steps 2 and 3 to upload the data from the CSV files to the following tables:
    • FSI_M_OBJECT_DEFINITION_TL
    • FSI_PM_PROFITABILITY_DEF
    • FSI_PM_CURVE_CHECK_DETAILS
    • FSI_PM_PROFITABILITY_VALUE
    • FSI_PM_PROFITABILITY_DIMENSION
    • FSI_PM_CURV_DRIVER_DETAIL

    Note:

    The application does not allow you to upload a wrong file for any of the above tables and displays an error message.
  5. Click the Close button to close the Profitability Curve Definition screen and go back to the Price Creation and Discovery main screen.