在MDX中列出成员及其所有后代的最佳方法是什么？

In an OLAP database I work with there is a 'Location' hierarchy consisting of the levels Company, Region, Area, Site, Room, Till. For a particular company I need to write some MDX that lists all regions, areas and sites (but not any levels below Site). Currently I am achieving this with the following MDXIn an OLAP database I work with there is a 'Loc