In a Jedox, a hyperlink (or link) is an item like a word or button that points to another location. When you click on a link, the link will take you to the target of the link, which may be another report, excel document, or other online content. There are two possibilities to create a hyperlink in Hedox:
- Searching the hyperlink in functions
- Clicking on the right click and selecting the hyperlink icon
The syntax for the function is HYPERLINK(link_location, friendly_name, screen_tip, source1, destination1[, source2, destination2, …]).
link_location – > here we can define where will our link takes us to. It can be on the same page “#SELF”, different sheet “[SELF]Sheet2!A1”, a particular report “//Demo Spreadsheets/Demos/Bikers Best/Navigation/Bikers Best Navigation” or a web page like “https://jedox4beginners.com/“.
friendly_name – > How will link the world to the outside world <Link Friendly Name>
Tool_tip -> What is visible when covering the link? In case you don’t want to see any addresses or strings just write #simple.
Source1 -> the cell, variable, name range, or array from where we are reading the value. In our screenshot, it is a D3 cell and a value of 1000.
Destination1 -> the cell, variable, name range, or array to where we are writing the value. In our screenshot, it is a D3 cell and a value of 1000. it could also be @varValue, rngValue and etc…
A hyperlink can send value from one to another sheet or the report. It is useful when the previous report needs to be closed but variables to be saved.
The benefit of using this type of hyperlink is that can be added to the dyno range which enables developers to create 10s of hyperlinks with only one formula.
A hyperlink that is inbuild in Jedox
The other way to create a hyperlink is by clicking right-click on the string. A new window will appears and here we can see many options + one of which includes actions buttons. These actions are introduced in 2022 versions and until now they are showing great potential and features. Like in the previous one here we can also navigate through pages and sheets.
Users can select many actions like running the ETL, downloading, uploading, or even adding the element.
Additional cool feature. A hyperlink can help you copy data from one area to another without using Integrator. Remember how the Academy team taught us to use splashing functionalities like “copy 2022-12” or copy Budget;2019 no rules. Well, we can use that string and embed it in our hyperlink. This is what it can look like.
By clicking “Copy” data from 2021 Components will be written to 2022 Components.
The file with the examples can be found here. Have in mind that you need to have installed the Biker Best database.