3621460 - Setting Unit of Measure Position in SAP Analytics Cloud Add-in for Microsoft Office

• Unit of Measure (Currency Symbol) Position is different in SAC add-in reports than how it is set in the data source (for example, Datasphere).
• In SAC add-in report, Currency Symbol is placed at the left, while in Datasphere it is at the right. Example: Datasphere 200.000BX, SAC add-in BX200.000
  
  

• SAP Analytics Cloud, add-in for Microsoft Office
• SAP Analytics Cloud

1. Create a report in SAC add-in, and create a report off the data source where Currency Position is set at the right(example: 200.000BX)
2. Notice Currency Position is placed at the left in SAC Add-in report. 

SAC Add-in takes "Currency Position" setting from User's "Profile Settings - User Preferences" in SAP Analytics Cloud 

Image / Data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

1. Log on to SAP Analytics Cloud and go to Profile Settings - User Preferences for the user account.
2. Set "Currency Position" to your desired setting(example: 1234Million$) in Profile Settings.

NOTE: This is a user based setting.  

unit of measure, sac add-in, symbol placement, sac stories, data analyzer insights, excel default format, currency position, user preferences, sac, analytics cloud , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions