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?
0 comments
Hide comments