![oracle apex sql currency oracle apex sql currency](https://raw.githubusercontent.com/mortezamashhadi/Number_field_with_currency/master/setting.jpg)
![oracle apex sql currency oracle apex sql currency](https://docs.oracle.com/database/121/AEUTL/img/query_builder.gif)
(optional) displayMessage=" displayMessagevalue" sets the presentation variable erPreference to a localized value. For its value, specify a string that uniquely identifies the currency, for example, gc1. SessionVarValue=" sessionVarValue " sets the session variable PREFERRED_CURRENCY. ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obips nĪdd a UserCurrencyPreferences element as follows:įor each currency option to be displayed in the Currency box or in currency prompts, add a UserCurrencyPreference element between the tags using this format: Use a text editor to open the userpref_currencies.xml file located in the following directory: To define the user-preferred currency options using a static mapping: You can use a mapping to define a static list of options that all users see for selecting currency. For example, one group of users might want to select from only Global Currency 1 or Global Currency 2 while another group might want to select from different options.ġ6.2.1 Defining User-Preferred Currency Options Using a Static Mapping Each user sees a subset of the total options available. This is useful, for example, to dynamically change the currency options so that each user sees a list specific to his or her account. Static - Produces a static list of currency options that all users see.ĭynamic - Produces a list of currency options that changes dynamically based on a logical SQL statement that you specify. When you define these currency options, you can use one of two types of mappings:
![oracle apex sql currency oracle apex sql currency](https://basitmis.files.wordpress.com/2016/02/apex_lov_6.jpg)
(These currency options must be for currencies to which your installation can convert columns.) Defining the currency options also controls whether the Currency box is available on the My Account dialog: Preferences tab and whether the Currency Prompt option is available on the Definition pane of the Prompt editor. You define the currency options that are to be displayed in the Currency box and in a currency prompt in the userpref_currencies.xml file. If desired, save this setting as a systemwide default.Ĭlick OK when you have finished, and repeat the preceding steps for any other columns to change.įigure 16-1 Example of the Currency Box on the My Account Dialog: Preferences Tabĭescription of "Figure 16-1 Example of the Currency Box on the My Account Dialog: Preferences Tab"įor information about setting the currency preference on the My Account dialog: Preferences tab or about currency prompts, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition. In the Currency Symbol list, select the symbol.Ĭomplete the other options on the tab as appropriate. In the Treat Numbers As box, select Currency. In the Analysis editor: Criteria tab, click the Options button for the currency column and select Column Properties to display the Column Properties dialog.Ĭlick the Data Format tab and select the Override Default Data Format box. In Answers, modify the analysis that uses the subject area. To specify the currency for a column in a customized subject area: Restart the service for Oracle BI Presentation Services.
![oracle apex sql currency oracle apex sql currency](https://s33046.pcdn.co/wp-content/uploads/2020/03/sql-format-date-using-culture.png)
Replace the tag attribute so it reads int:wrhs.įor example, replace tag="int:euro-l" with tag="int:wrhs". Select the entire element and replace it by pasting the copied element over it. Search for the text string int:wrhs, located near the top of the file. Search for the currency to make the default, for example, USD, CAD, PEN, or MAD.įor example, copy the currency tag for the Euro: Open the currencies.xml file in the directory For information about using formatting functions in Answers, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition. You can change the default currency that is displayed, for example, from French Francs to Euros. 16.1 Changing the Default Currency for Analyses