Advertisement
Guest User

Untitled

a guest
Dec 28th, 2011
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. WITH MEMBER [Measures].[prev] as '
  2. ([Applies To Date.All Periods].CurrentMember.PrevMember)))
  3. '
  4. SELECT
  5. {Hierarchize({[Measures].[Available], [Measures].[prev]})} ON COLUMNS,
  6. {Hierarchize({{[Applies To Date.All Periods].[year].Members}, {[Applies To Date.All Periods].[quarter].Members}, {[Applies To Date.All Periods].[month].Members}, {[Applies To Date.All Periods].[day].Members}})} ON ROWS
  7. FROM [Inventory]
  8. WHERE ([Event].[testEvent], [Price Level].[testLevel])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement