Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Hierarchize({[Measures].[Latest Available with Value], [Measures].[Latest On Hold with Value], [Measures].[Latest Other with Value]}) ON COLUMNS,
- NON EMPTY(Hierarchize({Crossjoin(Descendants([Applies To Date.All Periods].DefaultMember, [Applies To Date.All Periods].[day]), [Price Level].Children)})) ON ROWS
- from [Inventory]
- WHERE ([Event].[11TWN0410OAK])
Add Comment
Please, Sign In to add comment