How to get children's children?

Check function Descendants.

Vidas

"cowznofsky" wrote in message
news:1173368448.425211.118060@8g2000cwh.googlegroups.com...
>I have a hierarchy that goes Dept, Class Category, Style
>
> I can get the all the Classes and all their measures for Dept 1 using
> the syntax below.
> But I want to skip a level, and get all the Category numbers for Dept
> 1, and I haven't figured out how to do this.
>
> SELECT NON EMPTY {Hierarchize({{[Measures].ALLMEMBERS}})} ON COLUMNS
> , NON EMPTY
> Hierarchize(
> {
> AddCalculatedMembers({[Product Dim].[by Merchandise].[Dept].&[01
> Career].children}) }
> )
> ON ROWS
>