将两个值组合起来形成分数值的计算度量 [分析服务]

Question

在我的多维数据集中，我有两个度量：A 存储 aaaaa 形式的值，B 存储 bbbbb 形式的值。我想定义度量 C，它将给出值 aaaaa.bbbbb。我怎样才能实现这个目标？

Answer 1

如果我正确理解你的问题，你可以这样做：

with member [Measures].[A] as 123
member [Measures].[B] as 456
member [Measures].[C] as val(cstr([Measures].[A]) + "." + cstr([Measures].[B]))

select {[Measures].[A], [Measures].[B], [Measures].[C]} on 0
from [YourCube]