Using ProcessAdd to add rows to a dimension in SQL Server Analysis Services SSAS

There is not much documentation about how to do a ProcessAdd for a dimension in SSAS (SQL Server Analysis Services). Doing a ProcessAdd for a partition is pretty easy, but there is not much documentation to do a ProcessAdd for a dimension. The SSAS documentation says that you cannot do it using the UI, but you can do it with XMLA. It is definitely not a straightforward task neither is using AMO. In this tip we will walk through an example of how to do this for a dimension.