Is there an equivalent to XFSetCell for member properties (i.e., XFSetMemberProperty)? I don’t see this as an option but there are a few XFSet formulas, but I am not sure if they would work for this.

• 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