For year, I use year number. For month, I use 1 to 12 for relative year and 1 to 3 for relative quarter. For week, I use 1 to 52 for relative year, 1 to 13 for relative quarter, and 1 to 4/5 for relative month. I do the similar thing for day. The only thing that is not sequential is the absolute sequence number for the…

Thanks for the reply. I already used TIME type. The ago function works, but it still uses rank function to generate sequence in the sql. In OBIEE12c, they added sequence number tab on the hierarchy level, so you can specify sequence instead of using rank function. My issue is not ago not working. My issue is the ago still…