November 2002 MDX Puzzle

For most dimensions, the business analyst determines like items by looking at their distance from the topmost (root) dimension member. Items at the same distance from the root member are at the same level. For example, in a customer dimension, all countries might be at one level, cities at another level, and customer names at still another level. But for some dimensions—such as the Employees dimension of the FoodMart 2000 HR cube—the analyst determines like items according to their distance from the bottom of the dimension. In FoodMart's HR cube, you can determine the CEO and senior management by counting levels from the root; but if you want to determine which employees are first-level employees or first-level managers, you have to count from the bottom.

Use the FoodMart 2000 HR cube to determine which 10 first-level employees have the lowest employee salary. Include only hourly employees who have a non-empty salary. Then, display the employee salary for each of these 10 first-level employees.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.