My Oracle Support Banner

OBIEE 12c: DV/DVD - Currency And Decimal Separator Do Not Depend On Locale Settings For 'Norwegian' (Doc ID 2576057.1)

Last updated on AUGUST 19, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Issue only on "Norwegian" locale.

Goal

 On Oracle Busniess Intelligence Enterprise Edition (OBIEE) 12.2.1.4.x version, could see the following differences between OBIEE and DV for "Norwegian" locale. 

Steps to verify:

Database Settings

Alter the 'locale' and 'Language' NLS settings in the database as below -

  • Create a report with any one measure column. For e.g., SAL.
  • Go to Column Properties >> Data Format. Change Currency Symbol to “kr norsk-Noerg”.
  • The results would be showing based on 'User Locale' settings. Result is in Norway format. 
    • 'Decimal Separator' --> 800,00.
    • '1000 separator' --> 1 100,00.
  • DV Project

    1. Create a DV project with the same date column- SAL.
    2. Locale settings are not applied to the DV project.
    3. Results would be in U.S format only i.e, not in Norway format.  
      • 'Decimal Separator' --> 800.00 [Expectation is 800,00].
      • '1000 separator' --> 1,100.00 [Expectation is 1 100,00].

    Solution

    To view full details, sign in with your My Oracle Support account.

    Don't have a My Oracle Support account? Click to get started!


    In this Document
    Goal
     Steps to verify:
     Database Settings
     RPD Settings 
     Analysis 
     DV Project
    Solution
    References


    My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.