Dropdown on Account dimension property in SAC Story

[VKhatri]

I'm looking to create a dropdown on Account dimension property (Account_Group) to filter out Story data. 

I can see the list of value in drop down 

var resultSet = PlanningModel_1.getMembers("Gl Account");
for ( var i = 0; i< resultSet.length; i++ ){
Dropdown_1.addItem(resultSet[i].properties["Account_Group"]);
}

But drop down Selection is not working to filter out table data.

var selectedName = Dropdown_1.getSelectedKey();
Table_3.getDataSource().setDimensionFilter("Account_Group",selectedName);

I created a table with row gl account and Account_Group (gl account property) and colum amount in column. Have to filter out table data based on Account_Group value selected on Dropdown_1

Any help would be appreciated!

[N1kh1l]

@VKhatri 

Dropdown_1 has property values. You have not provided what Dropdown_2 has ?

Table_3.getDataSource().setDimensionFilter("Test_1",selectedName);

Test1 should be dimension here as syntax for setDimensionFilter is setDimensionFilter( dimension, selection)

Nikhil

[VKhatri]

Hi Nikhil, there is Only DropDown_1 with property. Updated my question with more specific details. Let me know if I missed something