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
Post a Comment