如何根据测量和计算SSAS计算总和尺寸 [英] How to calculate sum in SSAS based on measure & dimension

问题描述

我是SSAS的新手，我不知道如何在Analysis服务中计算条件总和。



我有一个度量组，即

1.案件数量



和3个维度。

1.案例分配委员会ID

2.年份

3.案件结案委员会ID



现在我想计算总和，为此我使用立方体的和函数。但实际上不知道如何处理条件。



Sum（Set_Expression [，Numeric_Expression]）



我想计算：



总和[计数]案件（案件指定委员会ID）] - 总和[案件数量（案件结案委员会ID）]



我不知道如何使用measure& sum函数中的维度。我正在使用它像Sum [measure.count of cases]，但不知道如何将尺寸放入其中。



任何建议真的很感激。



我的尝试：

I'm new in SSAS and I have no idea how to calculate conditional sum in Analysis service.

I have a one measure group i.e.
1. Count Of cases

And 3 dimensions.
1. Case Assigned Committee id
2. Year
3. Case Closed Committee id

Now I want to calculate the sum, and for this am using the "sum" function of the cube. But actually don't know how to put condition in that.

Sum( Set_Expression [ , Numeric_Expression ] )

I want to calculate :

Sum [count of cases (for Case assigned committee id)] - Sum [count of cases (for Case closed committee id)]

I have no idea how to use measure & dimensions both in the sum function. I'm using it like "Sum [measure.count of cases]" but have no idea how to put dimension in it.

Any suggestion really appreciated.

What I have tried:

Sum [measure.count of cases]

推荐答案

你计算总和就像



sum（{[Set Expression]}，[Measure.Count of Cases]



那是



sum（{[Case Assigned CommitteId]。[id]。[id]}，[Measure.Count of Cases]） -

sum（{Case Closed CommitteId]。[id] .id]}，[Measure.Count of Cases]）

You an calculate the sum like

sum ({[Set Expression]},[Measure.Count of Cases])

That is

sum({[Case Assigned CommitteId].[id].[id]},[Measure.Count of Cases])-
sum({Case Closed CommitteId].[id].id]},[Measure.Count of Cases])

这篇关于如何根据测量和计算SSAS计算总和尺寸的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！