hyperlinking
I am working with a hierarchy in discover.
The second layer in, is 2 columns combined, which I did when I modelled it. The first column represented the quote number (ie. Y19439-R0).... I want to hyperlink that.
I would like to have Y19439-R0 (and all the others on that level of the hierarchy) hyperlink to related sites.
For example: I want to press on "Y19439-R0" and have it open a new tab/window with the url "https://www.madeupname.com/Y19439-R0"
I'm not even sure if it is possible, but I'm trying to step outside of the box a bit.
4 replies
-
If your URL template is consistent, you can use the "actions" mechanism. Although your users need to right click and choose the action from the menu, it's a quick way to get what you want.
You need to setup your URL in the action box with something like this:
"https://wikipedia.com/wiki/" + Captions()I must say this doesn't exactly work with your regular hierarchy level, because it only works with the ENTIRE hierarchy or handpicked members. Neither is what you want.
The other alternative is to create a URL column in the data model. Then add the column to your grid. It then shows up as a link in the grid and users can simply click on it directly. This is easy to create and deploy. BUT, this also doesn't work well together with regular hierarchies.
-
Hyperlinking text is not a truly feasible solution.
The column either contains label text or it contains URL text. The engines cannot magically combine 2 random columns together to create the visible link you're after - unless Pyramid builds a new composite column that can take 2 inputs. Doing that kind of breaks the elegance and cleanliness of direct column analytics used in most modern analytical tools today. And that's before you even consider blending that into a hierarchical construct.
-
I ended up adding the URL's as a separate column in the table, then adding it at the lowest level of the hierarchy. Not exactly what I was hoping for aesthetically, but still works wonderfully.