3736816 - When Inserting formula SAPSetFilterComponent, some input fields and texts are missing for Korean in Analysis for Office

While inserting AO function SAPSetFilterComponent into a AO workbook or a query, the text of some fields and input fields are missing while Microsoft Office language is set to Korean. However, all fields are displaying without any issue when the Mictosoft Office language is set to English.

• Microsoft Office language is set to Korean.
  
• Microsoft Office language is set to English.
  

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

SAP Analysis for Microsoft Office 

1. Set Korean as the Display Language in Microsoft Office.

2. Open an AO workbook or a query.

3. Go to Excel's menu bar, click 'Formulas' and 'Insert Function', insert Analysis Function SAPSetFilterComponent.
   

4. In the Function Arguments open dialog, only the "Selection Type" field is displayed, while all other fields labels and input fields are missing.

At runtime, AO loads a text file from its installation folder, for the Korean language, all translated texts are stored in file KO.XML. Microsoft Office Excel has a problem with displaying the translated texts for Analysis Function in Korean.

1. Navigate to KO.XML file as per the following path.
   32-bit: C:\ Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\AnalysisOffice\Language
   64-bit: C:\Program Files\SAP BusinessObjects\Office AddIn\Plugins\AnalysisOffice\Language
2. Open the KO.XML file and search for "lbl.SetFilterComponent", replace the Korean parameter names by the English ones (e.g. replace "데이터 소스" to "Data Source") which exist in EN.XML file under the same path.

KO, EN, AfO, 4 fields, missing, descriptions, Excel, Korean Language, Selection Type, label, text, Data Source, Office 365, Formulas, Insert Function  , KBA , BI-RA-AO-XLA , Excel Addin , Problem