I have a Shared Dimension for "Order By" I am using a different column
from my view so I created a member property to use that for "Order By".
But the issue is when I process the Dimension only it shows the data in
order but when process the cube which has this dimension it ignore the
order by clause totally.

I am not sure Why? Client is not happy because the stuff is not in
order.

I have spent days to try different option to make it work but not able
to get it right.

Any help appreciated !!!

Thanks
Sam