August MDX Puzzle - 25 Jul 2001

Parent-child dimensions can lead to different types of analysis questions. In this column's file-analysis problem, one of the questions I wanted to answer was, Which first-level directories consume the most disk space? A first-level directory is a directory that contains only files, not subdirectories. Write an MDX query that returns a ranked set of the top 10 first-level subdirectories.

Hint: You might not have the same cube that I have, so try to write a query on the FoodMart 2000 HR Cube. The HR cube has a parent-child dimension called Employees. The equivalent question is, Which first-level managers have the most 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.