KB439682: In MSTR Office, Pivot Table option does not display negative values in Excel in MicroStrategy

SYMPTOM
When running a grid report as a Pivot Table in Strategy Office 10.4 in Excel, negative numbers will not be displayed in the Pivot Table, but they will display if the report is run as a grid, as shown below.

 
STEPS TO REPRODUCE
Follow these steps to reproduce the issue in a Strategy Tutorial Project.

1. In Strategy Developer, create a metric that returns "negative" values, for example
   

   
   (Cost * -1)

   
   
2. Create a new report with this metric and add an attribute, such as Country.
3. Go to Strategy Office, and find the newly created report.
4. Right-click > Run Report to Pivot Table.
5. In Excel, the negative values will not display at all.

CAUSE
This is an identified defect in Strategy Office 10.4.
ACTION
Currently, this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
WORKAROUND
To avoid the issue, a registry key will need to be created. Follow this steps:
For Linux, go to:

SOFTWARE\MicroStrategy\DSS Suite\

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MicroStrategy\DSS Suite\

• Create a new key under this folder, called: Export Engine.
• Create a new DWORD inside the Export Engine key, with the following name: Avoid_Code_Injection.
• Set the value of the DWORD to 0, as shown below:
  

Note: The Registry key for Export Engine should be applied on i-server machine. 
 
The Strategy Internal Reference Number for this issue is: KB439682