I create an initialization block to populate a couple of repository variables.
After saving the RDP the value for the default initializer changes from 2011 to 2011.0d
I have been using several workaround. But I need some permanent fix in rpd itself. Can anyone point to some Oracle Document? Is this issue been resolved in latest release of OBIEE. I am using 22.214.171.124.6.
Workaround Ref : The .0d date issue Re: OBIEE 126.96.36.199.2 BP1 Repository Variable data type
Yes, we found a solution. In the SQL for the initialization block, set up the code 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!
Yes, I have been using select valueof(year) from abc in front end in dashboard prompt. But instead I am looking for a patch update or permanent fix in rpd itself. Is it resolved in the latest release of OBI. I am currently using 188.8.131.52.6
Insted of doing work around... My Suggestion would be to Try in new version OBIEE 184.108.40.206.8 . I don't see this issue in OBIEE 220.127.116.11.8
But But.. We are having few more new bugs in OBIEE 18.104.22.168.8
Edited by: Venkat Krishna on Mar 6, 2013 7:53 AM