Sometimes we get different business requirements, which are meaning-full but little trick to implement in OBIEE. Similarly , last week i got a requirement for business to add a hyperlink on a report column, which when clicked goes to an external link. also, along with it i have to pass the CodePin and Number.
I tired many ways of passing parameters in Go Nav, GO url format. But it didnt work. Finally <a Href> worked, so sharing my solution with you.
Step 1: Edit column formula and place your code in below format. Concat all the parameters to be passed. Set Target and give it a name.
Step 2: Modify the same column and set its data format as below.
Let me know if you face any issues.
Follow for more !!