Guitar_player (9/16/2014)
Yes, i thought the same and i have implemented that with Date only..but the problem is with Members ...The member selection of Date is dynamic here so i have added the .Parent.chidlren to that but it wasnt helping[Date].[Calendar].[Date].[Dynamic Member Selection].Parent.children.
Heres where i got struck when i have implemented the above expression ..anyway what you have provided is correct but i need to check here how can i achieve this by dynamic selection of Date memebers
When you say it's dynamic, is it consuming a parameter? If so you can use the StrToMember function to make that work, like so:
STRTOMEMBER("[Date].[Calendar].[Date].&["+your parameter+"]").Parent.Children
There's quite a good post on using this technique here: http://blog.datainspirations.com/2010/10/07/using-dynamic-mdx-in-reporting-services-part-1/