Advertisement
Guest User

Untitled

a guest
Apr 21st, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. with member [Measures].[NazwaMiesiaca]
  2. as [Order Date].[Month].CurrentMember.Name
  3. SELECT
  4. {
  5. [Measures].[NazwaMiesiaca],
  6. [Measures].[Order Qty]
  7. } ON COLUMNS,
  8. HEAD
  9. (
  10. Order
  11. (
  12. (
  13. DESCENDANTS([Order Date].[Hierarchy].[Year].&[2013],,LEAVES)
  14. ),
  15. ([Measures].[Order Qty]),
  16. BDESC
  17. ),
  18. 1) ON ROWS
  19. FROM [Adventure Works2014]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement