Just curious, now that 18.104.22.168.4 is out, what people are thinking about it. It definitely fixed a couple of big bugs for us, and I haven't really seen any significant issues. Who else has given it a thorough work out, and what are your thoughts?
After upgrading the rpd from 22.214.171.124 to 126.96.36.199.4 the default values in init blocks gets appended by a character 'd' even though the dynamic variable is of nature integer and not varchar. Has anyone faced this issue and found any resolution?
Oracle (FINALLY) got back to me with a fix - but not to upgrade to 188.8.131.52.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,