Thank you because of NLS_date_Format the above sql gives me DD_MON_YYYY, how do I change NLS_DATE_FORMAT locally, through BI Publisher data model, like session variable?

Hello 1430724, Please elaborate how you accomplished this issue? thanks

Can someon eplease answer this question, I have same issue.