hi Tim, I tried to get the Period in the report header. don't think there is a way. One question do you schedule this report and mail it or just run it from the OBI. Thanks Manoj

hi Tim, Do you want the period to be displayed as header of the column? or as the header of the report? thanks Manoj

Hi Tim, glad to hear, it worked for you. instead of the day you can use these variables SQL_TSI_SECOND,SQL_TSI_MINUTE,SQL_TSI_HOUR,SQL_TSI_DAY,SQL_TSI_WEEK,SQL_TSI_MONTH,SQL_TSI_QUARTER,SQL_TSI_YEAR for different time periods. You can see worked examples in the OBIEE help…

hi Tim, I think this should work for you "date variable" > TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) date variable is the date field that you are filtering for. just put this in the sql filter. Hope this helps Thanks Manoj

Hi Tim, you can look at the TIMESTAMPADD function. use a negative number (I think it should be -7 in your case) and the sysdate. use this in the in the filter. Thanks Manoj