on 2024 Oct 09 2:50 PM
Hello,
Can you please explain how I can add comments to an existing model.
I have a very large model (20+) tables with 100s of columns.
I need to be able to add comments via spreadsheet: Table Name, Column Name, Comments.
I cannot find an option to upload comments to my existing tables in a physical data model.
Thanks
Hello,
To achieve this, you can use the Excel Import extension that is installed with the tool.
please follow the instructions provided for organizing the data into Excel tables as outlined below.
1. In an Excel sheet, create a tab "Table".
2. The first row contains the name and/or the code, plus the comment to be imported.
NAME | CODE | COMMENT
Table_1 | TABLE_1 | This is my comment for this table
3. Create a second tab "Table.Column".
The first row contains the parent object (table), the name and/or the code, plus the comment.
PARENT | NAME | CODE | COMMENT
TABLE_1 | Column_1 | COLUMN_1 | This is my comment for the column
4. Save the Excel file.
5. In PD, create a PDM containing one table TABLE_1 and one column COLUMN_1.
6. Add the Excel Import extension to your model (see C:\Program Files\SAP\PowerDesigner 16\Resource Files\Extended Model Definitions\ExcelImport.xem).
7. Right-click the model and select Import Excel File.
8. Click the Options button.
9. Select the Auto-map columns to properties option, and click OK.
10. Browse to select your Excel file, and click Next to launch the import.
Follow the steps described in the Resolution section of KBA 2539632 for further details.
Kind regards,
SAP Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.