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,



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 21, 2017 at 07:50 PM


    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.



    Add a 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 box doesn't display any values

      Any input is greatly appreciated.



  • Posted on 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.



    error-script.jpg (13.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.