如何在Pentaho Mondrian模式XML中使用公式(how to use formula in Pentaho Mondrian schema XML)

 我正在研究ReportServer中的Saiku报告。 我添加了一个Mondrian数据源。 现在我想在报告中添加两行以显示第三行中的Sum，我做了一些R＆D并发现我们可以使用Cell格式化程序，它可以使用Formula来使用Schema XML中的列。 但我无法得到确切的消息来源。 以下是我从Mondrian文档中找到的来源： 
 
<CalculatedMember name="name" dimension="dimension">
<Formula>
[Measures].[Unit Sales] * 2
</Formula>
<CellFormatter>
<Script language="JavaScript">
var s = value.toString();
while (s.length() < 20) {
s = "0" + s;
}
return s;
</Script>
</CellFormatter>
</Measure>
 
 但这似乎是不正确的，这个块我想要使用公式标签并使用[Measures].[Unit Sales] * 2看起来对我有帮助。 
 
 任何人都可以帮我纠正这个标签。 

I'm working on Saiku reports in ReportServer. I have added a Mondrian Data Source. Now i would like to add two Rows in the report to show a Sum in the 3rd row, i did some R&D and found that we can use Cell formatter that can use Formula to use columns from the Schema XML. But i'm unable to get is exact source. Here is the source i found from Mondrian Documentation:
 
<CalculatedMember name="name" dimension="dimension">
<Formula>
[Measures].[Unit Sales] * 2
</Formula>
<CellFormatter>
<Script language="JavaScript">
var s = value.toString();
while (s.length() < 20) {
s = "0" + s;
}
return s;
</Script>
</CellFormatter>
</Measure>
 
But this seems incorrect and this the block i want as its use Formula tag and using [Measures].[Unit Sales] * 2 that is looking helpful for me.
 
Can any one help me to correct this tag. 

原文：https://stackoverflow.com/questions/41262634