Max Date in Time Hierarchy in OBIEE 11g

2710382

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.

Thomas Dodds

Take a look at implementing a logical version of your measure using the aggr rule of LAST()