在MDX中使用不同的措施(Usingdifferent measures in MDX)

在MDX中使用不同的措施(Usingdifferent measures in MDX)

我希望我的SSRS报告包含几个计算的度量。 首先，我在我的立方体中有一段时间（以分钟为单位的平均时间）。 我想在某些事件类型上过滤此度量（休息，午餐和厕所休息等事件）。 这些过滤器在立方体中工作正常。 经过这些计算的措施后，我想要一些常规措施，如呼叫，平均等待时间等。 跟进我想按部门和员工对这些进行排序，所以我的表格如下所示：

---------------------------------- |Calls| Event Type 1| Event Type 2| ----------------------------------------------------------- | Department | Employee |Data | Data2 | Data 3 | -----------------------------------------------------------

如果我使用下面的查询，我会得到我的事件类型，但我似乎无法添加任何其他措施，以我的查询：

SELECT NON EMPTY [Measures].[Average Time (in minutes)] * [Event Type].[Event Type].MEMBERS ON 0 ,NON EMPTY { [Employee].[Department].[Department].ALLMEMBERS * [Employee].[Employee].ALLMEMBERS } ON 1 FROM [Model];

I want my SSRS report to contain a couple of calculated measures. First of all I have a measure of time in my cube (Average Time in minutes). I want to filter this measure on certain event types (Events like breaks, lunches and Toilet breaks). These filters work fine in the cube. After these calculated measures I want some regular measures like Calls, Average waiting time etc. Following up I want to sort these by Department and Employee so my Table will look like the following:

---------------------------------- |Calls| Event Type 1| Event Type 2| ----------------------------------------------------------- | Department | Employee |Data | Data2 | Data 3 | -----------------------------------------------------------

If I use the following Query I will get my Event Types but I can't seem to add any other measure to my query:

SELECT NON EMPTY [Measures].[Average Time (in minutes)] * [Event Type].[Event Type].MEMBERS ON 0 ,NON EMPTY { [Employee].[Department].[Department].ALLMEMBERS * [Employee].[Employee].ALLMEMBERS } ON 1 FROM [Model];

最满意答案

你可以做这样的事情：

WITH MEMBER [Measures].[Average Time Type1] AS ( [Measures].[Average Time (in minutes)] ,[Event Type].[Event Type].[Event Type 1] ) MEMBER [Measures].[Average Time Type2] AS ( [Measures].[Average Time (in minutes)] ,[Event Type].[Event Type].[Event Type 2] ) SELECT NON EMPTY { [Measures].[Average Time Type1] ,[Measures].[Average Time Type2] } ON 0 ,NON EMPTY { [Employee].[Department].[Department].ALLMEMBERS * [Employee].[Employee].ALLMEMBERS } ON 1 FROM [Model];

You could do something like this:

WITH MEMBER [Measures].[Average Time Type1] AS ( [Measures].[Average Time (in minutes)] ,[Event Type].[Event Type].[Event Type 1] ) MEMBER [Measures].[Average Time Type2] AS ( [Measures].[Average Time (in minutes)] ,[Event Type].[Event Type].[Event Type 2] ) SELECT NON EMPTY { [Measures].[Average Time Type1] ,[Measures].[Average Time Type2] } ON 0 ,NON EMPTY { [Employee].[Department].[Department].ALLMEMBERS * [Employee].[Employee].ALLMEMBERS } ON 1 FROM [Model];