Skip to Content

Rolling Periods on Fiscal Year/Period -Design Studio 1.6

I have a requirement to show 13 month rolling period where the user will select intially from the Fiscal Year/Period prompt.

I was able to get 13 month rolling periods in a drop down but when the user selects , application forces to enter prompt values and when they select, then only that period values are displaying.

I have Drop Down On select as DS_1.setVariableValueExt("0P_FPER", DROPDOWN_1.getSelectedValue());

Any help is appreciated,

Thanks,

Jothi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 21, 2017 at 07:50 PM

    Jothi,

    How are you populating the dropdown box? It looks like you are using a BEx data source. In that case, I suggest you use setVariableValue() instead of setVariableValueExt() and make sure the dropdown is populated with internal key values of Fiscal Period.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

    • Apologies for the late reply Mustafa,

      Yr.forEach(function(Yrlist, index) {

      YrMemkey = Convert.subString(Yrlist.internalKey, 2,9);

      Yrkeyvalue = Convert.stringToInt(YrMemkey);

      Yrmemtext = Yrlist.text; if(Yrkeyvalue <= defaultyr){

      //DROPDOWN_1.addItem(Yrlist.internalKey, Yrlist.text);

      DROPDOWN_1.addItem(YrMemkey,Yrmemtext); } });

      DROPDOWN_1.setSelectedValue(selectedValue);

      Dropdown box doesn't display any values

      Any input is greatly appreciated.

      Thanks,

      Jothi

  • avatar image
    Former Member
    Dec 05, 2017 at 09:48 AM

    Hi Jyothi,

    In your script, it seems to be you are passing value to info object not the variable.

    You need to provide the variable name instead of info object name in the highlighted area.

    Please let me know if you faced issue after the change.

    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded