Populate a dropdown list with alphanumerically sorted dimension members

var members = Table_1.getDataSource().getMembers(“Sales_Manager”);
// Sort members by description (simple string / bubble sorting)
for (var i = 0; i < members.length – 1; i++)
{  for (var j = 0; j  members[j + 1].description)
      {      
      var temp = members[j];      
      members[j] = members[j + 1];      
      members[j + 1] = temp;   		
  }    }    }
// Add all sorted members to the dropdown
for (var k = 0; k < members.length; k++) 
{ Dropdown_1.addItem(members[k].id, members[k].description);}

var members = Table_1.getDataSource().getMembers("Sales_Manager");
// Sort members by description (simple string / bubble sorting)
for (var i = 0; i < members.length - 1; i++)
{  for (var j = 0; j < members.length - i - 1; j++) 
  {    if (members[j].description > members[j + 1].description)
      {      
      var temp = members[j];      
      members[j] = members[j + 1];      
      members[j + 1] = temp;   		
  }    }    }
// Add all sorted members to the dropdown
for (var k = 0; k < members.length; k++) 
{ Dropdown_1.addItem(members[k].id, members[k].description);}

Code language: JavaScript (javascript)

bACK

Script Explanation

This script uses 2 loops to perform a bubble sort on the dimension description values
Outer Loop: The script goes through the list from the beginning to almost the end.

Inner Loop: For each item, it compares the current dimension member’s description with the description of the dimension member immediately after them.

Comparison and Swap: If the current member description should come after the next member description (alphabetically), the script swaps their positions.
This process is repeated until all items are compared, and the list is arranged in order from A to Z.