Parameter Passing in Webi through Lumira Designer

[shubham_chawla]

Hi,

I am trying to call a Webi report through my Lumira Designer Dashboard but its not working. Below are the following scripts I am trying to use:

Case1:

APPLICATION.openNewWindow("<Server>:<Port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6"+ "&lsMProdcut Category=" + DROPDOWN_PROD_CAT.getSelectedText());

Case 2:

APPLICATION.openNewWindow("<Server>:<Port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6"+ "&sRefresh=Y&IsMProdcut Category=" + DROPDOWN_PROD_CAT.getSelectedValue() );

Case 3:

APPLICATION.openNewWindow("<Server>:<Port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6"+"&lsProduct Category:=" +DROPDOWN_PROD_CAT.getSelectedText());

Case 4:

APPLICATION.openNewWindow("<Server>:<Port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6" + "&sRefresh=Y&IsMProduct Category&=" + DROPDOWN_PROD_CAT.getSelectedText() );

Case 5:

APPLICATION.openNewWindow(<Server>:<Port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6" + "&sRefresh=Y" + "&IsMProduct Category=" + DROPDOWN_PROD_CAT.getSelectedText() );

My Product Category on Webi is an optional prompt. Request you to let me know the correct script.

[arijit_das · Accepted solution]

What exactly do you mean by "not working" ? Do you get any error message ? How is the prompt defined in webi ? Does it accept only single value or multiple values ?

For prompt accepting multiple values, try:

APPLICATION.openNewWindow("/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6&sRefresh=Y&lsMProdcut+Category=" + DROPDOWN_PROD_CAT.getSelectedValue() );

For prompt accepting only single value, try:

APPLICATION.openNewWindow("/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FroZjFoMxQ4AUhwAAAAXs9MAAFBWsSZ6&sRefresh=Y&lsSProdcut+Category=" + DROPDOWN_PROD_CAT.getSelectedValue() );

[shubham_chawla · Accepted solution]

Hi Arijit,

Could you please help me on another scenario?

I need to color the alternate columns of a cross tab in Lumira Designer.

How can achieve that?