This content has been marked as final. Show 6 replies
This is known issue, the work around is to use substring1 person found this helpful
SUBSTRING(VALUEOF("XYZ_YEAR") FROM 1 FOR 4)
If helps pls mark
Thanks for your workaround. Could you please point me/share the link related to this issue.
Edited by: obul on Nov 23, 2012 5:51 AM
This issue got fixed in 220.127.116.11.7 BP.
Hey thanks for the update. i am thinking of upgrading to 6.7 BP then. I am already on 6.6 version. After upgrading to 6.7 does it require any workaround?
An easiy solution to this issue is to change the SQL for the initialization block to look like this:
select cast(year as number (4,0)) from blah....
The ,0 in the number specifier truncates any decimal data, and OBIEE then sees it as an integer type instead of decimal. Sorry, I posted this answer in another thread, but there seem to be quite a few threads about this issue.
Hope it helps!