Hi Team, First create a "date" column in RPD to caculate the last date of month by using below formula ( cast( TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) as date)) Now we have last day of month, Our Aim is to create a…

will add the code once testing is done on this friday

Thanks Team, We don't have time dimension also. I fixed this issue, by adding lot of custom code. Thanks, Avin

I couldn't find that option,

Thank you Issue got resolved

all temp files in OBIEE 12c

Yes able to access my folders, also able to add reports to favorites as well. But whenever user chooses a report from favorites list, then he is getting an error "Access Denied" He has bi-consumer role.