Defining Business Values Using Massive Import

You can export and edit the KPIs of several entities in a Microsoft Excel sheet, and then import your modifications back in the Business Value Definition widget.

Before you begin:
  • Open the Business Value Definition widget, and select the Weight and Balance cockpit.
  • Product properties need to be indexed in the Exalead CloudView. See Terms of Use.
  • The Server Status Checker displays the statuses of the Dispatcher, SCALA and Index. The status of all three needs to be OK.
See Also
Defining Business Values for a Single Entity
  1. In the tree, select either:
    • A root product to edit and import the KPIs of every subproduct within the root.
    • A subproduct to edit and import the KPIs for this specific entity.
    The KPIs values already defined on the selected product are displayed:

  2. In the menu of the product's tab, click Export to Excel.
  3. In the panel, select the KPIs to export, and then click Export.

    Note: The list of the KPIs available for export depends on the selected cockpit.

    A progress bar indicates the progression of the extract of the KPIs and of the report generation.
  4. When the export is complete, save the generated file, and then open it in Microsoft Excel.
    The selected KPIs and their values are organized in columns in the report.

  5. Enter values in the cells to edit the KPIs, and then save the file.

    Note: Cells with the following background cannot be edited:

  6. In the Business Value Definition widget, click the product's tab, and then click Import Excel Report.
    A progress bar indicates the progression of the import.

When the import is complete, the KPI's values are updated.