MDX Common Solutions

View calculated members when querying the measures dimension. Retrieve the first 5 members from a set. Return a set based on a range of values. Query data using member properties. Get the last child for a parent member. Get the first child for a parent member. Return all date members in the current year. Return yesterday's date in a member format. Query the top 10 members from a set based on a measure. Query the bottom 10 members from a set based on a measure. Apply the currency format to a calculated member.