Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH MEMBER [Measures].[prev] as '
- ([Applies To Date.All Periods].CurrentMember.PrevMember)))
- '
- SELECT
- {Hierarchize({[Measures].[Available], [Measures].[prev]})} ON COLUMNS,
- {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
- FROM [Inventory]
- WHERE ([Event].[testEvent], [Price Level].[testLevel])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement