通过AMO向计算成员添加翻译

Question

我正在使用AMO以编程方式生成OLAP多维数据集。如何为计算成员添加翻译？(SQL Server 2008)

我尝试了如下方法，但不起作用：

MdxScript mdx = cube.MdxScripts[0];
CalculationProperty calculation = new CalculationProperty();
calculation.CalculationReference = "[Calculated measureName]";
calculation.CalculationType = CalculationType.Member;
Translation translation = new Translation();
translation.Caption = "Some Caption";
translation.Language = "Language Code";
calculation.Translations.Add(translation);
mdx.CalculationProperties.Add(calculation);

Answer 1

我在上面的代码中发现了这个问题，应该将CalculationReference属性设置为"Measures.Calculated measureName“。