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