tag:blogger.com,1999:blog-6566349382458116822.post5915970390583606174..comments2024-03-15T08:28:44.794-07:00Comments on Oracle BI Publisher Consulting: Date Formatting and Handling for Siebel ReportingUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6566349382458116822.post-6248579498868669282010-11-16T07:12:53.664-08:002010-11-16T07:12:53.664-08:00Hi Kanichiro,
For Siebel BI integration. Got stuck...Hi Kanichiro,<br />For Siebel BI integration. Got stuck comparing the dates & using it in if condition to filter out the records.For comparing dates I am using exp like this.<br />"xdoxslt:date_diff(‘d’, ‘2009-07-21’, ‘2009-08-21’, $_XDOLOCALE, $_XDOTIMEZONE)"<br /><br />Next step want to store the above expresison in variable/parameter for using in if, trying this:<br />"?partik singlahttps://www.blogger.com/profile/06941062558411077095noreply@blogger.comtag:blogger.com,1999:blog-6566349382458116822.post-30628808186739422892010-05-28T02:16:16.264-07:002010-05-28T02:16:16.264-07:00Hello Kanichiro,
let me ask you about currency f...Hello Kanichiro, <br /><br />let me ask you about currency formating. I wish to show numbers like 12.345,68€. I use format-currency for that and the values are displayed correctly in rtf preview mode (!), while in the application I get the format like €12,345.68. Any chances to display currency like in the preview?<br /><br />Many thanksarnashttps://www.blogger.com/profile/16611120002675107103noreply@blogger.comtag:blogger.com,1999:blog-6566349382458116822.post-91334408524877746992010-05-11T11:19:05.002-07:002010-05-11T11:19:05.002-07:00Alex, found out that the fix didn't make it to...Alex, found out that the fix didn't make it to the production. Hopefully the next release. <br /><br />Benjamin, glad to hear it worked!Anonymoushttps://www.blogger.com/profile/13242147692123973325noreply@blogger.comtag:blogger.com,1999:blog-6566349382458116822.post-22096056303358842202010-05-10T02:28:29.977-07:002010-05-10T02:28:29.977-07:00Hi,
thanks for sharing. Finally we have the canoni...Hi,<br />thanks for sharing. Finally we have the canonical format from Siebel!<br />I downloaded the XSLFunctions.jar and copied it to local jar directory for use with BIP Desktop. Seems to work fine and now we can use the format-date function to format the output of psfn:getCanonicalDate().<br />Thanks Kanichiro!Unknownhttps://www.blogger.com/profile/06911673057518574458noreply@blogger.comtag:blogger.com,1999:blog-6566349382458116822.post-46210721941231210112010-05-08T03:26:41.011-07:002010-05-08T03:26:41.011-07:00Hi Kanichiro,
nice information. Do you have more ...Hi Kanichiro,<br /><br />nice information. Do you have more info, how the canonical date output can be achieved? I ran a quick test on 8.1.1.2 and the output for a date field is similar to "05/06/2010 07:03:25".<br /><br />This isn't canonical, is it?<br /><br />I think there must be some user property...<br /><br />Thanks for any insight<br /><br />@lexAlexhttps://www.blogger.com/profile/12084125686909788385noreply@blogger.com