title: How to filter time hierarchy based on anothr attribute's value in MDX
body: <p>I want to create a calculated member. I have a time dimension hierarchy" YQM", which has Year/Quarter/Month.  The calculated member should find YTD till the current month.  However, the value of current month will come from database.
  I have created a attribute, "CP" which returns the current month value.
  Please tell me how to create the calculated member. Please note "CP" is not in the same hierarchy YQM.</p>