Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with member [Measures].[NazwaMiesiaca]
- as [Order Date].[Month].CurrentMember.Name
- SELECT
- {
- [Measures].[NazwaMiesiaca],
- [Measures].[Order Qty]
- } ON COLUMNS,
- HEAD
- (
- Order
- (
- (
- DESCENDANTS([Order Date].[Hierarchy].[Year].&[2013],,LEAVES)
- ),
- ([Measures].[Order Qty]),
- BDESC
- ),
- 1) ON ROWS
- FROM [Adventure Works2014]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement