Import Key Performance Indicators

Save time and reduce manual effort by importing key performance indicators (KPIs) that were exported from other applications into the catalog. Instead of manually creating KPIs, you can upload them using a Microsoft Excel file, streamlining the process and ensuring consistency across your data landscape.

Prerequisites

To manage KPIs, you must have a global role that grants you the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Catalog Asset (–RU––-M) - To edit an asset's name and short and long descriptions and add term, KPI, and tag relationships on the asset details page.

  • Catalog KPI Object (CRUD–-M) - To add, edit, and delete categories and KPIs. Also, to publish and unpublish KPIs.

  • Catalog KPI Template (–R–––--) - To view the KPI template.

The Catalog Administrator global role and the DW Viewer role template (used directly as a global role) applied together, for example, grant these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Context

Rather than creating KPIs manually, you can import them from other applications as long as they're in a Microsoft Excel XLSX file.

To make sure your KPI is available in all catalog views, it's best to create it using the SAP Business Data Cloud cockpit system. If you want the KPI to be available in just one specific formation, create it using the SAP Datasphere system for that particular formation.

Using Delimiters and the Escape Character

You can use delimiters and the escape character to import your KPIs with attributes that have multiple values (for example, keywords, categories, value lists, or other attribute). Delimiters help separate these values, while escape characters manage any special characters within them.

You can choose any character as the delimiter to separate the attributes of KPIs. The following example uses categories to demonstrate how you can use delimiters.

If your KPI's attribute has any values that contain the delimiters, you need to specify the escape character you want to use. To keep your import file simple, you can set the same values as the separators. The following example uses categories to demonstration how to use the escape character.

Procedure

  1. In the side navigation area, choose (Catalog & Marketplace)Start of the navigation path Next navigation step End of the navigation path (Search).
  2. On the catalog search page, click Start of the navigation pathImport Next navigation step KPIsEnd of the navigation path.
    If you have never imported before, the File Upload dialog opens. If you have previously imported, the Import KPIs dialog opens where you can see drafts of files available for import and files that have already been imported. For more information about the detailed status of existing import jobs, see View Details About Key Performance Indicator Import.
  3. Click Create Import.
  4. Either drag and drop your Microsoft Excel file or click (Browse) to locate your file.
  5. In the Selected Sheet Number list, choose the worksheet you want to import. If you've selected the incorrect sheet, you can choose the correct one on the next screen.
  6. (Optional) If the first row of your worksheet contains header information, click Use first row as column header.
  7. If you have mapped a similar worksheet in the past, you can choose the file in the Mapping Template list. Otherwise, choose Use new mapping.
  8. Click Upload.
    The Import KPIs page opens and some options may be mapped. You can remove the default mapping by clicking the Clear Mapping button in the upper-right corner.
  9. In the header area, you can set the options (such as Selected Sheet and Column Header) if they haven't defaulted to the correct option. For more information about the options, click (Help). After making the changes, click Update.
  10. In the Default Attributes and Custom Sections areas, map your source columns to the target attributes. To learn more about the mapping details, click the > arrow.
  11. Click either Save Draft to come back later to complete the import, or click Import to begin the import process.

Results

A popup message appears informing you that the import has started and you're taken back to the catalog search page. After the import is completed, another message popup is displayed. Click the KPIs tab to see the added KPIs. You can also return to Start of the navigation pathImport Next navigation step KPIsEnd of the navigation path to view the completed imports and their status information.

Delete or Move a Key Performance Indicator Import

Context

You can perform one of these tasks:
  • Move the import file from the Imports section to the Drafts section

  • Delete an imported file

Procedure

  1. In the side navigation area, choose (Catalog & Marketplace)Start of the navigation path Next navigation step End of the navigation path (Search).
  2. On the catalog search page, click Start of the navigation pathImport Next navigation step KPIsEnd of the navigation path.
    The Import KPIs dialog opens where you can see drafts of files available for import and files that have already been imported. For more information about the details status of existing import jobs, see View Details About Key Performance Indicator Import.
  3. Select the import file that you want to delete. Click (Delete).
  4. (Optional) To move a file from the Imports section to the Drafts section, select Move import configuration to drafts (do not delete).
  5. Click OK.
    The file is either moved to the Drafts section, if you chose that option, or deleted from the system.
  6. Click Close on the Import KPIs dialog to return to the catalog.