I have a WEBI ReportX which has 5 prompts which are all mutliselect. On reportX I want to create a hyperlink which calls another WEBI reportY.
I want the same prompts entered in ReportX by user to be passed as ReportY and the ReportY should open is excel(default).
What should be my syntax of hyperlink and how do I read the host name dynamically so that I dont have to update the link when I move content from DEV->TEST->PRod