Navigate to Web Page from report dynamically

Question

Hi,

We have requirement to navigate from OBIEE report column to the web page for the attachments.  We have column called URL which contains Link to the web URL to view/download the invoice details. Each row is different URL I tried to use action link to web page by passing parameters but I couldn't use.

Please suggest. Thanks

Example: If column URL has three values

URLwww.microsofct.comwww.google.comwww.facebook.com

This values will display in the report and when user clicks on it it should navigate to the web page. Is there any way to pass this and there are many rows

Gianni Ceresa · Answer

Just a detail: keep in mind a link is supposed to start by " http:// ", so if your values don't have it (all of them) add it to the format of the column.

The default format "HyperText link (prepend http://)" does it for you, but in this case if you have some with and some without it will not work as http://http:// will not work. So if you have a mix you can fix the quality of data in the source or use a formula in the column to detect if there is the http:// and prepend it if not).

The default format "HyperText link" will open the links in the same page and it's why the answer above used a custom format taking the "HyperText link" and adding ' target="_blank" ' to open the link in a new window/tab.

Bose Pandian · Answer

Hi, If the column has the URL, then just change the Data format of the colum. ( Column Properties -> Data Format -> Custom Data Format) @[html]""@ This option will allow the open the URL in the new tab in the browser. Hope it helps! Thanks, Bose

Gianni Ceresa · Answer

Hi,

If your column is a URL set the format in the Criteria tab of your analysis to URL and OBIEE makes all of them clickable and working links.

It's just a column format as can be number, percentage etc.