I am actually not quite good at the MDX functions , so i have got one issue where i am unable to find the answer please help me out !!!!
I have got a Year Hierarchy and the levels are like this Year,Quarter,Month,Weekday,Day .
Now my problem is when I select a Quarter like say 'Q1' , i need to get the children of that Q1 ( Jan , Feb , Mar ) so i have used the Children function "...[Quarter].Children" .
I am getting the output , but i am not getting it is correct month order instead i am getting as "Feb , Jan , Mar "
I hope i was able to deliver my question , please help me out how to get the required output .