Guest User

Untitled

a guest
May 25th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. select Hierarchize({[Measures].[Latest Available with Value], [Measures].[Latest On Hold with Value], [Measures].[Latest Other with Value]}) ON COLUMNS,
  2. NON EMPTY(Hierarchize({Crossjoin(Descendants([Applies To Date.All Periods].DefaultMember, [Applies To Date.All Periods].[day]), [Price Level].Children)})) ON ROWS
  3. from [Inventory]
  4. WHERE ([Event].[11TWN0410OAK])
Add Comment
Please, Sign In to add comment