Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Navigate to Web Page from report dynamically

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
URL |
---|
www.microsofct.com |
www.google.com |
www.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
Answers
-
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.
0 -
Hi,
If the column has the URL, then just change the Data format of the colum. ( Column Properties -> Data Format -> Custom Data Format)
@[html]"<a href="@H" target="_blank">"@</a>
This option will allow the open the URL in the new tab in the browser.
Hope it helps!
Thanks,
Bose
0 -
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.
0