Member value on column

with 


 MEMBER [Measures].[Label] AS [RDate].[Date].CURRENTMEMBER.Item(0).Name


SELECT non empty({[Measures].[Label]},{[Measures].[Rentals]}) on columns,
non empty( Generate
  ( [Title].[Format].[Format].MEMBERS
    ,TopCount
    (
      Order
      (Filter([Title].[Format].CurrentMember, [Title].[Format].Member_Value = "DVD" or [Title].[Format].Member_Value = "Blu-ray" )
        * [Title].[Format-Titles].[Long Title Name].MEMBERS
       ,[Measures].[Rentals]
       ,DESC
      )
     , 50
    )
  ) ) ON rows

      FROM [MasterCube]
      Where  [Date].[Date].[2015-08-09]:[Date].[Date].[2015-08-17]

i am trying to get top  50 movies by format,   

With out [Measures].[Label]  column query works, but trying to add release date for that title,

dimension is [RDate].[Date],

I am expecting result

DVD  Tilte1      01/01/2000    1,232

DVD  Tilte2      08/03/2006      922

Thanks

V

  
  • Edited by Vaishu Wednesday, August 19, 2015 9:15 PM change
August 19th, 2015 9:13pm

created measure same way mentioned in your query

member [measures].[date]
as
[RDate].[Date].currentmember.name

when i run my select 

SELECT   {[measures].[date],[Measures].[Rentals]} ON COLUMNS,

getting All for date instead of  actual date.

is something wrong in relationship or design

 


  • Edited by Vaishu Thursday, August 20, 2015 3:50 PM c
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 3:50pm

able to get result by 

SET [RDate] AS [RDate].[Date].[Date].ALLMEMBERS

  • Marked as answer by Vaishu 13 hours 32 minutes ago
August 21st, 2015 1:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics