Passing Webi prompts from Xcelcius

[Former Member]

I need to pass webi prompts based user selection in Xcelcius. The selection can be read into a cell in excel and that value need to be passed to Webi report as a prompt and open the report fro that value.

Here is what I read from Xcelcius user guide, but I dont know how to interpret below statement.

The OpenDocument URL can be entered directly into the URL field of the

URL Button component. The URL Button can also be linked to a URL as text

in a cell of your spreadsheet. In combination with Selector components and

the Excel CONCATENATE function, the URL can be changed dynamically

based on user selection

http://XXXXXXXX:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=XXXXXXXXXXXXXXX&&sIDType=CUID&sRef...;

What could be wrong in my code for passing cell value, Please correct it.

[xjhacking · Accepted solution]

You need to use the Excel concatenate function to create an url based on the variables that you select in the dashboard.

Look at this setup for example:

Cell A1: http://XXXXXXXX:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=XXXXXXXXXXXXXXX&&sIDType=CUID&sRef...

Cell A2: August

Cell A3: =CONCATENATE(A1;A2)

You bind the selector for the month variable to cell A2. Cell A3 will now give the following result: http://XXXXXXXX:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=XXXXXXXXXXXXXXX&&sIDType=CUID&sRef.... You can now bind cell A3 to the URL Button component.

[Former Member · Accepted solution]

Thanks Xavier,

Actually it is

Cell A3: =CONCATENATE(A1,A2)

[xjhacking · Accepted solution]

Yep you are right.