essbase - Is it possible to create dynamic drop-down boxes in Hyperion Planning forms -


i'm working on first sandbox hyperion planning application , i'm curious if possible create dynamic drop-down boxes in planning forms. example, if form requires planner select team/cost center, company , currency possible create form dynamic such that:

when planner picks particular cost center, company , currency drop-down boxes dynamically populated valid choices given selected cost center / team.

without hyperion in front of me, can't remember if got syntax correct, should pretty close this.

in dropdown1 onchange script:

var objdd1 = this; var objdd2 = activedocument.sections['dashboard'].shapes['dropdown2'];  var value1 = 'selection'; var objtable1 = activedocument.sections['table']; var objcolumn1 = objtable1.columns['list_items'];  var value2 = 'selection2'; var objtable2 = activedocument.sections['another table']; var objcolumn2 = objtable2.columns['list_items'];  // go through dropdown for(var x=1; x<=objdd1.count; x++) {   // stop when item that's selected   if(objdd1.item(x) == objdd1.selectedindex)   {     // pick correct list     switch(objdd1.item(x))     {       case value1:         var objtable = objtable1;         var objcolumn = objcolumn1;         break;       case value2:         var objtable = objtable2;         var objcolumn = objcolumn2;         break;       default:         console.writeln('error selection');     }      // empty target dropdown     objdd2.removeall();      // go through rows of table     for(var y=1; y<=objtable.rowcount; y++)     {       // column, go through each cell in order       var value = objcolumn.getcell(y);        // add contents of cell dropdown options       objdd2.add(value);     }   // dropdowns have 1 selection.     // once that's found, stop loop   break;   } } 

Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -