I just read the blog and still confused about the functionality of this order function.
According to the blog, when we add DESC keyword to the ORDER function, the data has to be sorted by fact value without any break in the natural hierarchy of dimensions, but why even the Alabama and Mississippi children are sorted ( I mean swapped).
I was expecting first the children of Alabama sorted by fact value DESC and then children of Mississippi sorted by fact value DESC.
Please help me in understanding this.
Thanks in Advance.