I would like to dynamically manage cube translations through c#(.net v3.5) and AMO. I am still to handle calculated members translations.
Another post here shows how to do that if I add a new calculated member. My question is how are existing ones handled.
I have created a calculated member in the cube. Looping through the Microsoft.AnalysisServices.Cube.MdxScripts.CalculationProperties collection however, returns no results. However I can see the mdx script in the MdxScript.Commands collection
foreach (MdxScript sc in cube.MdxScripts)
foreach (Command c in sc.Commands)
Console.WriteLine(c.Text); //writes the mdx of the calculated member
foreach (CalculationProperty cp in sc.CalculationProperties) //collection is empty
foreach (Microsoft.AnalysisServices.Translation t in cp.Translations)
View Complete Post