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
-
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.
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.
Procedure
Results
Delete or Move a Key Performance Indicator Import
Context
-
Move the import file from the Imports section to the Drafts section
-
Delete an imported file
