In Oracle BI Admin Tool we can use REPLACE function in a measure to change a column data format(varchar as datatype) and then use it in report. But I need to do
There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to
Say that I have an analysis with the columns Month, Difficulty, and Score. The report has a filter Month = August, but the column Difficulty changes within the