Import Glossary Terms
Save time and reduce manual effort by importing glossary terms that were exported from other applications into the catalog. You can upload terms 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 Glossary (CRUD–--) - To add, edit, and delete glossaries.
Context
Rather than creating glossaries manually, you can import your glossaries from other applications as long as they're in a Microsoft Excel XLSX file.
To make sure your glossary is available in all catalog views, it's best to create it using the SAP Business Data Cloud cockpit system. If you want the glossary 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 terms 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 terms. The following example uses categories to demonstrate how you can use delimiters.
Procedure
Results
Delete or Move a Term Import
Context
-
Move the import file from the Imports section to the Drafts section
-
Delete an imported file
