I am writing this is ENG so the XML will be readable:
here are some very common Time MDXes
A. how can I get "this date" by using StrToMember (not recomended but simple)?
StrToMember("[Date].[Date].[" + Format(now(), "MMMM dd, yyyy") + "]")
B.an Example of using Year to date function:
the following code returns all a set of Jan-aug 2003
YTD([Date].[Calendar].[Month].&[2003]&[8])
I prefer the function PeriodsToDate since its more generic.
