Guitar_player (9/15/2014)
Hi,Yes i think i am nearer but i am struck somewhere like " .Parent.Children " was used on a Member.
As in my scenario the Members can be anybosy in the specified level so how can i use this when i have got
Week -> Date ?
If i use the formula as Week.Parent.Children , i am getting an error message that "The PARENT function expects a member expression for the 1 argument. A level expression was used."
So any ideas ?
With the understanding that I don't even know how to spell "SSAS", there is a T-SQL solution... but I need to know what the first day of the week is for you.
--Jeff Moden
Change is inevitable... Change for the better is not.