Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. WITH
  2. SET [S_PrevDate] AS
  3. StrToMember(@Month, CONSTRAINED).PrevMember
  4.  
  5. MEMBER x AS
  6. SetToStr([S_PrevDate])
  7.  
  8. SELECT x ON 0 FROM [cube]
  9.  
  10. WHERE StrToMember(@Month, CONSTRAINED)
  11.  
  12. WITH
  13. SET [S_PrevDate] AS
  14. [Date].[Y-Q-M-D].[Month].&[201708] -- August
  15.  
  16. MEMBER x AS
  17. SetToStr([S_PrevDate])
  18.  
  19. SELECT x ON 0 FROM [cube]
  20.  
  21. WHERE [Date].[Y-Q-M-D].[Month].&[201709] -- September
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement