我希望我的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];更多推荐
发布评论