We have one requirement where if user selects year in dashboard time prompt then he should see max date data from the data available in fact table for that particular year.Similarly if he drills down to qtr,month then he should see max date data of that particular level. This is not max date of the month,qtr and year, it should be max date of data available in fact table for every level.

Please let me know how to implement this.