MDX:如何根据每个学生ID的最新日期检索数据 [英] MDX: How to Retrieve data Based on Latest Date For Each Student Id

问题描述

如何根据日期获取每个ID的最新计数.

How to get latest count based on date for each id.

尝试:

SELECT [Measures].[CourseJoinedCount] ON COLUMNS, 
NON EMPTY
        (
         [Course].[CourseName].[CourseName], 
         [DimDate].[Full Date].[Full Date],
         [Student].[StudentId].[StudentId]
        )ON ROWS 
FROM [RandD]

推荐答案

我认为使用Generate可能会有所帮助.目前未经测试，但明天我将针对AdvWrks进行模拟，以查看其是否有效:

I think the use of Generate might help. Currently untested but I will try an mock this up against AdvWrks tomorrow to see if it works:

SELECT 
  NON EMPTY 
   [Measures].[CourseJoinedCount] ON 0, 
  Generate(
     [Course].[CourseName].[CourseName].MEMBERS
    ,[Course].[CourseName].CURRENTMEMBER
     *Tail(
       NonEmpty(
         [DimDate].[Full Date].[Full Date].MEMBERS,
         [Course].[CourseName].CURRENTMEMBER
       )
     )
  )
  *[Student].[StudentId].[StudentId]
  ON 1
FROM [RandD];

这篇关于MDX:如何根据每个学生ID的最新日期检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！