Skip to Content

Passing parameter to selection variable from Desgn studio

Dear All,

I am facing an issue while passing parameter from Design studio to webi.

I am able to pass parameters to all the selection variables except for one, CALYEAR.

Calyear is selection variable applied for a keyfigure(restricted keyfigure).

Is there any limitation in Design studio such that we cant pass values to such selection variable. and what is the solution for it.

Please share your ideas.

Add comment
10|10000 characters needed characters exceeded

  • HI Mustafa,

    Many Thanks for your reply.

    I am capturing the user selection for calyear from the dropdown and passing to webi using the below code.

    APPLICATION.openNewWindow("https://********/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AcLB270bF9BNpqLlN9_a_6c"

    + "&lsSPlant=" + Plantname /// this is a Variable holds the selected plant
    +"&IsSCalYear=" + DROPDOWN_YEAR.getSelectedValue()
    +"&lsSBU=" +BU /// this is a Variable holds the selected plant
    +"&lsMCostCenter=" + Costcenter // this is a Variable holds the selected plant
    +"&lsMProductGroup=" + PG // this is a Variable holds the selected plant
    +"&sRefresh=Y"
    );

    All the values are getting passed except the calyear

  • Some more questions:

    Where in your application are you triggering the above code?

    Do you have any code in the "On Select" event of the Dropdown? If so, can you post it?

    How are you populating the Dropdown?

    Can you post a screenshot of your application showing the expanded Dropdown?

  • Hi Swapna,

    Can you clarify how you are getting the value of CALYEAR and passing it to the WebI report and what the result is? Some screenshots and your script code would be helpful.

    Regards,

    Mustafa.

  • Get RSS Feed

2 Answers

  • Nov 16, 2017 at 11:16 AM

    cusersals7kordesktopcalyear.png

    Hi Mustafa,

    I have attached the screenshot of my application. you can see the dropdown of year filter. and also the button named-"Show Detail View" which is triggering code I mentioned in my earlier post.

    I am populating the drop down in its properties area, where we bind it to source and target.

    you can also see all the available filters on left side of the dashboard. user can select any or all of filter and the dashboard is getting filtered according to user selection.

    Now if the user wants to see more detailed level of data- he will click on the button "Show Detail View" which should open webi report and pass the user selection to webi. So that the user does not have to filter the webi report again.

    Please let me know if you need any information.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 05:15 AM

    Yes Mustafa I have double checked it. and also tried hard coding it. once as "2014" and again as 2014.. it did not throw any error both the times. but the value 2014 was not passed to webi.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Swapna,

      What happens when you hard code the year in the opendoc URL and call the URL directly from the browser instead of from a Design Studio application? This test will tell you if the problem is with Design Studio, or just the way the URL parameters are being encoded.