Advertisement
Guest User

Untitled

a guest
Apr 17th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.32 KB | None | 0 0
  1. with member [Measures].[NazwaMiesiaca]
  2. as '[Order Date].[Miesiac].CurrentMember.Name'
  3. select  non empty {
  4. head(order(
  5. crossjoin({[Order Date].[Miesiac].children},
  6. {[Order Date].[Dzien Miesiaca].children}),
  7. [Measures].[Order Qty],
  8. DESC
  9. ),1)
  10. }
  11. on columns
  12. from [Adventure Works2014]
  13. where [Order Date].[Rok].&[2013];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement