- No, there is not Excel Add-In function for setting member properties.
- Metadata changes are captured (i.e., XML file loads, manual record updates, grid view bulk updates) so that audit trails can be maintained.
- Extracting the metadata XML and manipulating the properties is the quickest way and can be re-imported to update dimension properties.
Source: Office Hours 2020-08-27 Partner Enablement