BO webi 6.5 allows to link two reports (parent and target) using the openDocument syntax in a cell formula's. I have following 2 issues while trying it:
1. Problem: The prompted values are not passed into the target document. The target (called document) opens by displaying the prompts screen for user to make a selection, when it should instead pass the value from the parent report. Pls see below the syntax I used. Can you pls indicate the fix to this problem
2. Question: the syntax requires a "server name", but as the report is copied from server to server: Developmnet / Test / Production, this is inconveninet if the server name is hard-coded in the report: is there a function or system variable that can be used to return the server name?
Syntax example from webi manual:
="<a href=\"openDocument.jsp?&iDocID=451&sDocName=eFashion%20Stores&sT
ype=wid&sRepoType=Corporate&lsSState%20Equal%20to:="+[Stat
e]+"\">"+[State]+"</a>"
My target report has 1 prompt, which displays the prompt text as "District Code". The syntax I use in the parent report:
="<a href=\"[District Code]+"\">"+[District Code]+"</a>"
All works ok except for the target report MSA17J opens by displaying the prompts selection window. I expected the report to open showing data refreshed and relevant for the "District Code" value passed in from parent report.
The parent report is at this time in my Personal Documents, and the target report is in Corporate documents.
The target report used a prompt on district, pre-defined in the Universe design. The sql view shows following code for the prompt:
MSV000_DC0001_NAME.DSTRCT_CODE IN @Prompt('District Code','A','District Inventory Information\District Code',Multi,Free,Persistent,{'*'},) OR '*' IN @Prompt('District Code','A','District Inventory Information\District Code',Multi,Free,Persistent,{'*'},) )
MSA17J is saved with Refresh option set to 'Manually'.
1. Problem: The prompted values are not passed into the target document. The target (called document) opens by displaying the prompts screen for user to make a selection, when it should instead pass the value from the parent report. Pls see below the syntax I used. Can you pls indicate the fix to this problem
2. Question: the syntax requires a "server name", but as the report is copied from server to server: Developmnet / Test / Production, this is inconveninet if the server name is hard-coded in the report: is there a function or system variable that can be used to return the server name?
Syntax example from webi manual:
="<a href=\"openDocument.jsp?&iDocID=451&sDocName=eFashion%20Stores&sT
ype=wid&sRepoType=Corporate&lsSState%20Equal%20to:="+[Stat
e]+"\">"+[State]+"</a>"
My target report has 1 prompt, which displays the prompt text as "District Code". The syntax I use in the parent report:
="<a href=\"[District Code]+"\">"+[District Code]+"</a>"
All works ok except for the target report MSA17J opens by displaying the prompts selection window. I expected the report to open showing data refreshed and relevant for the "District Code" value passed in from parent report.
The parent report is at this time in my Personal Documents, and the target report is in Corporate documents.
The target report used a prompt on district, pre-defined in the Universe design. The sql view shows following code for the prompt:
MSV000_DC0001_NAME.DSTRCT_CODE IN @Prompt('District Code','A','District Inventory Information\District Code',Multi,Free,Persistent,{'*'},) OR '*' IN @Prompt('District Code','A','District Inventory Information\District Code',Multi,Free,Persistent,{'*'},) )
MSA17J is saved with Refresh option set to 'Manually'.