• subscribe
October 23, 2002 12:00 AM

November 2002 MDX Puzzle

SQL Server Pro
InstantDoc ID #26680

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.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here