SAP Analytics Designer - Multi input (Strg+V) and filtering of Dimensions values

[Alex_B]

Hi,

I got a list of values (~20-30 Serialnumbers) that I want to copy out of a Excel file and filter those in my Analytics Application. I also use the same Serialnumbers as Dimension in my Charts/Tables. I thought about copying that values into a Input Field and filter my Tables/Charts out of the copied values (Multi-Input/Insert + Filtering). How can I setup this or is there any other possibility? With Input Control Widget I can't copy multiple values in the search box.

thx

Alex

[former_member678452 · Accepted solution]

Hi Alex,

I had a similar requirement with order numbers. I used an input field and a button onClick to execute. If the input field is empty it removes the filter, otherwise, the filter is applied. The join variable is only there due to a prefix requirement. Hope this helps.

Cheers

Patrick

var txt = InputField_Campaign_WO.getValue();

		if (txt.length === 0)
			{DS_Generic_Campaign_Table.removeDimensionFilter("2CZCEAMCMPGNMAINT");}
		
		else
		{var splitit = txt.split(" ");
			var join = ("0000" + splitit.join(",0000")); //prefixing wo num required
				var filter_val = join.split(",");

		memberInfos = ArrayUtils.create(Type.MemberInfo); 
 		for (var n = 0; n < filter_val.length; n++)
			{var wo_id =  filter_val[n];
				memberInfos.push({id: wo_id , description: wo_id});}
 
			DS_Generic_Campaign_Table.setDimensionFilter("2CZCEAMCMPGNMAINT",memberInfos);}

[Alex_B · Accepted solution]

patrick99 Thx a lot. The entered values are divided by " " or "," ? Could you maybe share how entered and filtered values look like?