SAP Knowledge Base Article - Public

1488746 - Decimal format for spanish(mexico) regional setting is incorrect in Xcelsius

Symptom

Xcelsius dashboards give incorrect decimal format for numbers when the regional settings are set to Spanish (Mexico).

Reproducing the Issue

  1. Create a dashboard and add any number in the spreadsheet, for exampe: 1,234.56
  2. Bind this data to the label component and set the regional settings for the operating system to Spanish (Mexico).
  3. Inspite of setting the appearance/test/number format in the properties of the label component, the data when previewed is displayed as 1,234.5600
  4. We find there are additional two zeros after the decimal.

Resolution

Keep the number format under the properties of the Label component to General and not numberic.

Keywords

Spanish (Mexico) format, Number format for Spanish, Xcelsius Spanish format. , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008