Skip to Content
author's profile photo Former Member
Former Member

How to show the value of an object as a link to an external website

Hi,

We are on BI platform 4.0,

I have an object called ItemID, It has a number that identifies the article in the system. I want to show it as a hyperlink to an external websites, i.e. clicking on it should take the user to the external website with the value of the object plugged into the link appropriately.

E.g. the Item ID could have a value like 1000. If a user uses this object in a web intelligence document I would want to see the ID 1000 as a link and clicking it should open a browser window for the following URL - http://amazon.com/gp/product.html?id=1000

Can I use the Display as HTML or Display as Hyperlink object property in the Information Design Tool to set this up, I can't seem to get it working. There is no description of this feature in the manual either.

Also, what are the exact steps to do this in a WEBI document ? I tried the create link method but its not opening up the browser, could someone dumb down the steps for me,

I was hoping I could set it up in the IDT instead of the WEBI documents so that users who create their own WEBI docs would get the linked object all set up and ready to be used rather than do it over and over in each doc.

TIA, Sorry for the long post.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 11, 2013 at 02:40 AM

    Hi Enem,

    You can do it both in IDT and Webi.

    In Web Intelligence, create 3 variables :

    - VAR1 : "URLbase" with formula : "http://amazon.com/gp/product.html?id="

    - VAR2 : "ItemID" which can be your dimension ItemID (optional)

    - VAR3 : "URL" with formula : [VAR1]+[ItemID]

    Insert your variable VAR3 into an empty cell and got to "Format Cell" and choose how your cell is displayed such as "Read content as : Hyperlink".

    Now, according to your ItemID, your URL will change automatically and on clic, your web browser will open a new window.

    You can do the same on IDT with 2 dimensions and another one which "CONCAT()" two others. Insert it for all newly reports.

    Hope it helps.

    Regards,

    William


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi William,

      Thanks for your reply. Shouldn't I be able to 'Select' the URL itself as a formula in the Select property of the object in IDT plugging in the id as the parameter ?

      The select formula would be : 'http://amazon.com/gp/product.html?id=' || item_id

      And then set Display as Hyperlink to true ? I would have expected that to show up as a hyperlink in the WebI doc when a user attempts to use the object ? Isnt that how it should work ?

      Or I could build the whole URL link in HTML tags with the href and title etc all in the formula string and Display as HTML. That doesnt work either.

      Thanks for your attention.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.