How to manage Decimal notation based on User profile in SAC like SAP

[Vasu_Sac]

Hi

I have input template and users can enter data with below format.

1,234,567.89   (Thousands are in commas and decimal places are in dot)

But some users want to enter data different decimal notation as below.

1.234.567,89 ( Thousands are in dot and decimal places are in commas).

The above formats support based on user profile in SAP systems. Is it possible in SAC?

Regards,

Vasu

[William_Yu1]

Hi Vasu_Sac, 

  SAC has it's own user profile setting either 1,234,567.89 or 1.234.567,89. 

Best regards, William 

[Vasu_Sac]

Hi @William_Yu1, Thanks for your reply. How to change user preferences. I didn't see any edit option for User Preferences to change Number formatting. Regards, Vasu

[William_Yu1]

You just need to click the change button in user profile popup to change it.

[Vasu_Sac]

Hi @William_Yu1, I don't know why I am not getting edit option to edit the user profile. I have roles BI Admin and BI Content Creator roles.

[William_Yu1]

From your screenshot, seems you are having PC with very low resolution, there is a horizontal scrollbar, can you try to either use a higher resolution or scroll to the right?

[umasaral]

In SAP Analytics Cloud (SAC), managing decimal notation based on user preferences similar to SAP systems can be achieved to some extent through localization settings and data input options. SAC allows you to define how data is displayed and interpreted, including decimal and thousand separators, but it does not provide a direct user profile setting for individual preferences like SAP ERP systems do.

Here’s how you can manage decimal notation in SAC:

### 1. Data Input Options

SAC supports different data input formats that users can use when entering data:

- **Automatic Recognition**: SAC automatically recognizes different formats based on the user's browser settings. For example, if a user's browser is configured to use commas for decimals and dots for thousands separators, SAC will interpret data entry accordingly.

- **Manual Input Format**: Users can manually specify the format when entering data. SAC allows you to configure the decimal and thousand separators in the input templates and data models.

### 2. Localization Settings

You can configure localization settings at the SAC tenant level, which influence how numbers are displayed and interpreted across the entire environment:

- **Decimal Separator**: You can set the default decimal separator (dot or comma).
- **Thousands Separator**: You can set the default thousands separator (comma or dot).

These settings apply globally across all users and reports within the SAC tenant.

### 3. Input Templates

When designing input templates in SAC for data entry, you can explicitly define the format expected from users. This includes specifying:

- **Decimal Places**: Define how many decimal places are allowed or required.
- **Formatting**: Use symbols like commas or dots to guide users on how to enter data consistently.

### 4. User Education and Best Practices

Since SAC does not provide a direct user profile setting for decimal notation preferences, it’s essential to educate users on the expected data format and best practices for data entry. This ensures consistency in how data is entered and interpreted, especially when dealing with different regional or organizational norms.

### Conclusion

While SAC does not offer the exact user profile-based decimal notation customization found in SAP ERP systems, you can effectively manage decimal notation through careful configuration of input templates, localization settings, and user education. By setting clear expectations and leveraging SAC’s flexibility in data input formats, you can ensure that users enter data consistently and correctly according to your organization’s requirements.

[Vasu_Sac]

Hi @umasaral Thanks for your reply.

I explored options that you mentioned, but will not fulfil my requirement.

1. Data Input Options - I didn't see any automatic Recognition based on user input data with browser settings. Manual Input Format - I didn't see User can manually specify there own format. If user enters his own format, The formatting overwrites with global setting or KF decimal places in Input template.

2. Localization Settings - These settings apply globally across all users and reports within the SAC tenant. so this is not useful for fulfil individual user requirement.

3. Input Templates - I can see Decimal Places and scale format settings in Styling but no option available to manage commas or dots.

4. User Education and Best Practices - Unfortunately users are looking their individual preferences to enter the data.

Regards, Vasu