SAP Knowledge Base Article - Public

3452740 - SAC dropdown list members are in an unexpected language

Symptom

Dropdown list values are in different language than expected. 
The "end user" has profile setting set to English. All dimensions translated to both Italian (original language) and English language (translated) using "new model's" translation utility. In a new story, the user can see the SAC interface in English language, all labels etc. are in English but dropdown list content is in Italian language. 

Dropdown list members are selected using code similar to:
/* Dropdown country*/
var MemberIDA = Control_Invest.getMembers("Zlocation1");
Drop_Nation.removeAllItems();
for (var indexcount=0;indexcount<MemberIDA.length;indexcount++) {
     Drop_Nation.addItem(MemberIDA[indexcount].id,MemberIDA[indexcount].description);
}

Cause

The "getMembers" API of the PlanningModel does not support fetching member descriptions based on the user profile language setting.  The dimension in use has a default language of 'Italian', which is why the PlanningModeling "getMembers"
API returns the members in Italian.



Resolution

Use the API of "getDataSource().getMembers", example:

"Table_1.getDataSource().getMembers("Zlocation1");" 
or
"Chart_1.getDataSource().getMembers("Zlocation1");".

Keywords

KBA , LOD-ANA-AD-INF , Analytics Designer Infrastructure , Problem

Product

SAP Analytics Cloud all versions