Applying PeopleSoft Regional Settings Personalizations to Online Reports in PIA

This section discusses:

  • Applying regional settings personalizations to online reports in PIA.

  • Using the session language code to determine number formatting.

  • An example of applying PeopleSoft regional settings personalizations to BI Publisher reports using the en-us locale

  • An example of applying PeopleSoft regional settings personalizations to BI Publisher reports using the fr locale.

Applying PeopleSoft Regional Settings Personalizations to Online Reports in PIA

When a BI Publisher report is run online using the PeopleCode APIs, or via the Query Report Viewer PIA page, the personalization settings are determined based on the following three levels:

  • User-specific.

  • Locale-specific.

  • System-wide.

The user-specific settings are those that are specified by overriding any of the default values displayed under your My Preferences - Regional Settings page, and have the highest level of precedence.

If no overrides have been defined for a user, the personalization settings are driven by the locale that is set in the browser, assuming that personalization options have been configured for this specific locale in the PeopleSoft system. See Global Technology: Defining Locale-Specific Formatting for more information.

If no locale-specific personalization settings have been defined for the particular locale in use, the system-wide defaults will then be applied. The system-wide defaults are the default values displayed under your My Preferences – Regional Settings page prior to specifying any overrides.

Using the Session Language Code to Determine Number Formatting

The PeopleTools Settings property group features a psxp_number_format_src property that lets you modify the behavior regarding the personalization of number values. It effectively allows you to revert to the method used in PeopleTools 8.55 and earlier releases. In PeopleTools 8.55 and earlier releases, you can use the language code of the current user session to determine the decimal and digit group separators used when formatting a number with the format-number() function.

Note that this property does not have any effect on reports run through the process scheduler, as number formatting in a scheduled report will always be driven by the language code of the process run control. For more information see section Personalizing Reports Run Through Process Scheduler later in this topic for more information.

By default, the psxp_number_format_src property is set to Browser, and the formatting of number values is based on the PeopleSoft Regional Settings. You can set the property to LangCode to put into effect the older behavior.

The property is located in the PeopleTools Property Group on the Global Properties page or on the Report Definition page - Properties page. See Setting Up BI Publisher for more information.

You can also set the property using the ReportDefn class method, SetRuntimeProperties, in the PeopleCode API. See PeopleCode API Reference: SetRuntimeProperties method: ReportDefn class

Example: Applying PeopleSoft Regional Settings Personalizations Using the en-us Locale

The following examples illustrate reports with PeopleSoft formatted date-time, number, date and time values, when run in a browser using the en-us locale

Note that the examples in this section reflect the regional settings as delivered for the en-us locale, for example: the date format is MMDDYY, the time format uses the 12 hour clock with AM/PM designator, the number has a comma for the digit group separator, and a decimal for the decimal separator.

The following example illustrates BI Publisher Report, QEQ_LOCALEQUERY, formatted with PeopleSoft regional settings using the en-us locale.

BI Publisher locale query report formatted with regional settings using the en-us locale.

The following example illustrates BI Publisher Report, QE_QRY_PRCS_TIME, formatted with PeopleSoft regional settings using the en-us locale.

BI Publisher query processing time report formatted with regional setting using the en-us locale.

Example: Applying PeopleSoft Regional Settings Personalizations Using the fr Locale

The following examples illustrate Reports with PeopleSoft-formatted date-time, number, date and time values, when run in a browser using the fr locale

Note that the examples in this section reflect the regional settings as delivered, for the fr locale, for example: the date format is DDMMYY, the time format uses the 24 hour clock, and the number has a space for the digit group separator, and a comma for the decimal separator.

The following example illustrates BI Publisher Report, QEQ_LOCALEQUERY, formatted with PeopleSoft regional settings using the fr locale.

BI Publisher locale query report formatted with regional settings using the fr locale.

The following example illustrates BI Publisher Report, QE_QRY_PRCS_TIME, formatted with PeopleSoft regional settings using the fr locale.

BI Publisher query processing time report formatted with regional settings using the fr locale.