Thanks @Christian Berg will try that and revert back

@Gianni Ceresa @Christian Berg, Can you please provide an example on how to use LAST aggregates across the time dimension?

Thanks Gianni and Christian for the suggestion. I'm looking into the SQL logs like you suggested and may update you later. but some thing i tried is to use session variable and use it from analysis filter and that worked . i will look into LAST aggr also , but a challenge i have in this DW is that i don't have a time…

Thanks Gianni, appreciate it , but this filter doesn't return any thing and i get the following The RECORD_DATE is a date column (e.g 4/10/2018 04:00:00 PM)

Sorry i'm new to OBIEE and may not know the exact syntax. i tried to use this, but i can't build my where clause using the function provided For example i want to run this where RECORD_DATE = TRUNC(SYSDATE - 2 / 24, 'hh')