Webi OPEN Doc Hierarchy variable values to another webi Report

[Former Member]

Hi All,

Anyone please let me know formula / URL to pass hierarchy node variable Parameters from one webi report to another another webi report in Open Doc.

="<a href=\"../../opendoc/openDocument.jsp?iDocID=AR2hEROjq5BGson27Le1OK8&sIDType=CUID&sType=wid&lsMZVAR_CE_0PROFIT_CTR_HIER_DF=PlantA&lsIZVAR_CE_0PROFIT_CTR_HIER_DF=0HIER_NODE%2F1000PB&lsSZVAR_CE_CALDAY_YEST="+URLEncode(""+[LastdayPrevMonth])+"\" title=\"\" target=\"_blank\" nav=\"doc\">Prior Month</a>"

Above hard coded values working fine , but i need to capture UserResponse() from first report and pass that to 2nd report through formula.

UserResponse() formula throwing error when we build Opendoc URL . Any help appriciated ...

[former_member748020]

Hi,

For hierarchy, the separator is '|' (encode with %7C)

Regards