tag:blogger.com,1999:blog-3303178385491249894.post7275926069916381481..comments2024-03-11T12:40:19.889+00:00Comments on BI Direct: Oracle Business Intelligence Enterprise Edition 11.1.1.6.0 – Configuring Logical Columns for Multicurrency Support with STATIC List Currency OptionPravin Khadakkarhttp://www.blogger.com/profile/00951643834171565870noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3303178385491249894.post-63684194878250253132013-05-01T09:47:46.865+00:002013-05-01T09:47:46.865+00:00Hi Pravin,
I know this post is old, hope you will...Hi Pravin,<br /><br />I know this post is old, hope you will reply anyway.<br /><br />We followed your post and enabled everything.<br />But we have an additional problem to solve: decimal places.<br /><br />In MyAccount, the user wants 3 options:<br /> - option 1: Global Currency<br /> - option 2: Local Currency (2 decimals)<br /> - option 3: Local Currency (3 decimals)<br /><br />They don't want to show any symbol in reports (like $ or USD), just see the numbers with the proper number of decimal places. <br /><br />So we created 3 entries in userpref_currencies.xml file:<br /><br /> <br /> <br /> <br /><br />Note that the value passed to the variable is the same for the two Local Currency entries, so the values in report will not change.<br /><br />Then we added the corresponding 3 entries in currencies.xml file:<br /><br /> <br /> <br /> <br /><br />Then we create an analysis and we change the "Currency Symbol" to "User's Preferred Currency" as you are suggesting.<br /><br />Values in the analysis are calculated correctly and accordingly to the selection in MyAccount page, but the decimals shown are always 2, aslo if we select the 3rd option, which should be configured for 3 decimals, accordingly with the "int:cust_L_3" entry in the currency.xml file.<br /><br />Are we missing something?<br />Do you have any suggestion?<br /><br />Thank you.Anonymoushttps://www.blogger.com/profile/16622536933050896538noreply@blogger.com