A further update on using AMO to add descriptions to dimension attributes.
I was having problems with this. The code was running fine (all green in the SSIS package) but the descriptions were not showing up. I'd noticed that in Visual Studio a Description property was not available for attributes of Cube Dimensions, but was available for Database Dimensions i.e. those dimensions from which cube dimensions are created.
Furthermore I could not find mention of a Description property for CubeAttributes on MSDN.
So on a hunch I adapted Frank's code to update the attributes of Database Dimensions rather than Cube Dimensions, as shown below (apologies to C# enthusiasts but I code in VB):
'Dim cd As CubeDimension = cube.Dimensions.GetByName(rdr("DimensionOrMeasureGroup").ToString())
'Dim ca As CubeAttribute = cd.Attributes.Find(rdr("ObjectName").ToString())
'ca.Attribute.Description = rdr("ColumnDescription").ToString()
Dim d As Dimension = db.Dimensions.GetByName(rdr("DimensionOrMeasureGroup").ToString())
Dim da As DimensionAttribute = d.Attributes.GetByName(rdr("ObjectName").ToString())
da.Description = rdr("ColumnDescription").ToString()
This seems to have done the trick. Descriptions now appear for dimension attributes when browsing cubes.
I hope this helps those people who cannot use the BIDS Helper to sync dimensions e.g. if they are based on named queries.