1741977 - How do I pass parameters to openDocument from an Excel cell?

An Dashboards or Xcelsius dashboard has a hyperlink to make an openDocument call that requires the passing of a parameter located in a separate cell.  Mapping the call to pass a parameter &lsSmyparameter=A1 is taken literally and not passing the contents from cell A1.

SAP BusinessObkects BI 4

SAP BusinessObjects Enterprise XI3.1

Steps:

1.  Create a cell in the underlying Xcelsius dashboard spreadsheet containing a hyperlink for openDocument.

     Example  BI4 openDocument link:  http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AW4AVT1AUhVAogA6P7OQv9c&sIDType=CUID&lsSmyparameter=A1

2.  Create a cell containing a parameter that will be passed using the openDocument call.

     Example parameter:  Enter July in cell A1

3.  Execute the hyperlink.

Note that URL passed is http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AW4AVT1AUhVAogA6P7OQv9c&sIDType=CUID&lsSmyparameter=A1

Create the base URL in one cell.

In Cell A2 enter http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AW4AVT1AUhVAogA6P7OQv9c&sIDType=CUID&lsSmyparameter=A1

Create parameter in a separate cell

In Cell A1 enter July

In a third cell,  use the concatenate function to merge the two cells.

In Cell A3 enter  =concatenate(A2,A1)

Point URL box to cell A3

Xcelsius Dashboards Concatenate openDocument , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To