Export list of SSAS objects and translations (using AMO in .NET)
A while ago I needed to export translations of objects in the SSAS database. After some (unsuccessful) googling and trying some manual methods (e.g. opening XMLA files in Notepad++ and copy-pasting) I've come up with the conclusion that this is a perfect task to learn how to work with Analysis Management Objects in .NET. I've first created a CLR assembly for SQL Server. The input parameters are the SSAS server name and database name and the code then loops through SSAS objects and exports the list of objects and their translations. Afterwards I've modified the code and created a console application that basically does the same, but works independently (e.g. you don't need to install any CLR assemblies into the SQL Server).
Read more...Tags: amo, translation