This content has been marked as final. Show 5 replies
Oracle (FINALLY) got back to me with a fix - but not to upgrade to 22.214.171.124.7 (which fixed the earlier posters issue, I'll have to try it).
Instead, they suggested changing the SQL from something like:
select max(fiscal_year) from blah
select cast(max(fiscal_year) as number(4,0)) from blah
the number(4,0) means to return no decimal places, which then appears to make OBIEE behave properly.
Hope this helps,