Creating Dimension Filter Using Dropdown

[ahfadoo]

Hi, I am attempting to set the filter of a singular dimension (G/L Account) using a dropdown in SAC. Although, when I attempt to set the dimension filter it removes all the dimensions from my table and I am not sure as to why it is. I have attached images below regarding the results and my code. I assume it has to do with the book/unbooked functionality although I am not sure. I currently have all my dimensions set to Unbooked but still can not get the table to be filtered.  In the images below you can see the dropdown is set to unassigned and the filter receives it but does not display it in the table. 

Any help at all would be greatly appreciated!

Kind regards, Ammar

[N1kh1l · Accepted solution]

@ahfadoo 

try console.log on select variable to see whether its an array of string or string and then check what data type parameter setdimensionfilter accepts.

[ahfadoo · Accepted solution]

Hi Nikhil, I managed to figure out that the variable was bringing in a array and that the type was incorrect. Once I fixed it it managed to work just fine. Thank you so much for your help!