To edit dimensions in the Acterys Excel-Add-on follow these steps:
1- Connect to your model
3- Click on "Edit Dimension" and select the Dimension you would like to edit from the drop-down list.
4- This will show the content of your dimension in an Excel table. Here you can now edit all entries as required or add new elements (leave the ID column empty for new records). All Excel editing features like drag and drop, copy paste etc. are supported
5- To delete record use the "Delete rows" button
6- Once you are finished click on Publish Changes in the Ribbon
"This functionality allows you to copy data from Excel sheet and populate in dimension"