SAC app: updateMembers and checkbox widgets

[igladyshev]

I'm trying to use updateMembers() in my app to manage property values of a dimension Dim1 in my planning model.

For this I use a checkboxgroup widget where Selected Items should pass 'X' value to the property Flag of a corresponding Member, and NotSelected Items correspond to the empty '' values.

There is a tab, a checkboxgroup and a button in my app.

I use following code in canvas onInit script to fill checkboxgroup with initial items from Dim1

MemberArray = MyModel.getMembers("Dim1");
for(var k = 0; k < MemberArray.length; k++) 
	{
	//transfer all CP to ChBox	
	CheckboxGroup_1.addItem(MemberArray[k].id, MemberArray[k].description);
	if (MemberArray[k].properties["Flag"] === "X") 
		{	
		SelStrArray.push(MemberArray[k].id);	
		}
	CheckboxGroup_1.setSelectedKeys(SelStrArray);		
	};

I use following code in Button onClick script to synchronize tab and checkboxgroup:

Application.showBusyIndicator();
//clean up all property values
MemberArray = MyModel.getMembers("Dim1");
for(var k = 0; k < MemberArray.length; k++) 
	{
		Member = ({ id: MemberArray[k].id,
					 properties: { Flag: "" 							 
								 }});
		AllMemberArray.push(Member);		
	};
if ( AllMemberArray.length > 0 ) 
	{
		MyModel.updateMembers( "Dim1", AllMemberArray );
	};
//fill selected property values
SelStrArray = CheckboxGroup_1.getSelectedKeys();
for(var i = 0; i < SelStrArray.length; i++) 
	{
		Member = ({ id: SelStrArray[i],
					 properties: { Flag: "X" 							 
								 }});
		SelMemberArray.push(Member);
	};
if ( SelMemberArray.length > 0 ) 
	{
		MyModel.updateMembers( "Dim1", SelMemberArray );	
	};
Table_1.getDataSource().refreshData();
Application.hideBusyIndicator();

Unfortunately, the app works as expected only after the first click on the Button. All subsequent clicks don't remove 'X' from property values, but are only able to add them.

I'm not experienced in JavaScript, so I could misinterpret some syntax, or some used APIs are generally not working in SAC...

Please help to understand. I would appreciate to know other possible scenarios allowing to manage Member Properties from EndUser perspective in the App.

[N1kh1l · Accepted solution]

igladyshev

Ok The issue is that your variable SelMemberArray does not get emptied out after the dimension update. It still has the old members from first run. I just adjusted the second code block as below and it works as expected. I have just re instantiated the SelMemberArray with a fixed None member which is neither root nor has parent. I could not find a quick way to clear out the array.

Script variables used: The ones in red are array. All are of type planningmodel member.

Application.showBusyIndicator();
//clean up all property values
var ds=Table_1.getDataSource();
Application.refreshData([ds]);
var SelStrArray= ArrayUtils.create(Type.string);
SelStrArray=[""];
SelMemberArray=[{id:"NONE",properties: { Flag: "" }}]; // Re assigning the member with a fixed id None.
var MemberArray1 = MyModel.getMembers("SAP_CEP_SALESORG");


for(var k = 0; k < MemberArray1.length; k++) 
	{
		 Member = ({ id: MemberArray1[k].id,
					 properties: { Flag: "" 							 
								 }});
		AllMemberArray.push(Member);		
	};

if ( AllMemberArray.length > 0 ) 
	{
		var result=MyModel.updateMembers("SAP_CEP_SALESORG",AllMemberArray);
	};
console.log(AllMemberArray);
if(result){
	Application.showMessage(ApplicationMessageType.Success,"Flag set to blank");
}
Application.refreshData([ds]);
//fill selected property values
SelStrArray = CheckboxGroup_1.getSelectedKeys();

for(var i = 0; i < SelStrArray.length; i++) 
	{
		selMember = ({ id: SelStrArray[i],
					 properties: { Flag: "X" 							 
								 }});
		SelMemberArray.push(selMember);
	};
console.log(SelMemberArray);
if ( SelMemberArray.length > 0 ) 
	{
	var update=	MyModel.updateMembers( "SAP_CEP_SALESORG", SelMemberArray );	
	};
if(update){
	Application.showMessage(ApplicationMessageType.Success,"Flag set to X");
}
Application.refreshData([ds]);
Table_1.getDataSource().refreshData();

Application.hideBusyIndicator();

Output:

On Initialization

Update based on checkbox selection

Hope this helps !!

Please upvote/accept if this helps you

Nikhil