How to use hyperlinks in Jedox?

How to use hyperlinks in Jedox?

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 functionsClicking on the right click and selecting the hyperlink icon Hyperlink function 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...
Read More
Palo.ini standard configurations

Palo.ini standard configurations

Palo.ini is a configuration file where superusers (the ones who administrate the server) could add or remove some functionalities of Jedox. It is located in data folder and on-premise could be accessed at this address <instalation folder>/Jedox/Jedox Suite/olap/data. Edit is possible if you do the right click and edit it. For this purpose, we will open it via standard Notepad. Standard palo.ini Lines starting with # are commented configurations and therefore will not be executed. The line will be skipped and the next one will be processed. More about palo.ini can be found on this link. Here are the explanations of the lines: http line represents the IP and port where jedox can be accessed.log sink is the location of the file where OLAP logs will be writtensplash-limit 1000 shows an error if splashing requires more space than the first number. 500 shows a warning if splashing requires more space than the second number. 100 Shows info if splashing requires more space than the...
Read More
Error while restoring the database

Error while restoring the database

When having two servers that are running on different versions, it could happen that restoring the database backup from a newer one to an older one can lead to an error. In our case, it appeared when trying to restore the database in Modeller from 2021.4 to 2021.2. If you are not familiar with how to restore the database from one server to another without including support, the article can be found here. The process is simple: Log in on your server from where you want to take the database Go to desired database in Modeler Right Click on it and choose Download Database... Go to second server where you want to perform restoring the database activity Right click on it and choose Restore Database... IF the scenario is smooth you are ready to celebrate, but in case it's not (like below) CODE: M_DB3 - zip operation failed : not a valid backup file,subfolders found Perform the following steps: Unzip the database Find folder checksum and remove it Zip it again Try to perform...
Read More
Unable to click save button in Jedox ETL

Unable to click save button in Jedox ETL

Hi Jedox beginners, How many times has it happened that while working on your super complex ETLs, the save button becomes unclickable? It can become really annoying problem, especially if you spent a decent amount of time in front of the PC. Until now, the problem could be solved by: Clicking Test button before and then pop up with "Save button" will appear Log out, delete cache and log in again. Since both solutions bring anxiety to your hands, simple CTRL + S typing on the keyboard is enabling the SAVE button again. Click now and thank us later. ...
Read More
How to create a color picker in Jedox?

How to create a color picker in Jedox?

Jedox have wind range of possibilities when it comes to reporting since it is working based on Excel technology. Having that in mind it might happend that sometimes you will need to add color picker into your dashboard. Here is the example how it could be done. On the spreadsheet, you can put the colors which could be chosen Set up a macro which will be trigged when color is clicked ="<a href=""#"" title='"&U5&"' style=""height:100%;width:100%;display:inline-block;color:"&U5&";background-color:"&U5&";"" onclick=""Jedox.wss.macro.exec([true,['Module1.saveColorToVariable','"&V5&"']])""> </a>" Create the macro in the Macro Editor function saveColorToVariable ( $color ) { define_variable ( 'varColor' , $color ); //return do_close(); } That is it!! In case you are not a person who has much sense for colors there are amazing patterns of colors on this website. An example of the project can be found here. ...
Read More
How to return IP address from the Spreadsheet in Jedox

How to return IP address from the Spreadsheet in Jedox

Here is the sample of the macro PHP code which can help you to return the IP address of the current server from the spreadsheet. It could be useful when reports contain download functionality which is the source on the server name. So in order not to have a hardcoded server DNS name you could use this funcionality. -------- function temp(){ $localIP = getHostByName(getHostName()); return __msgbox("myComplexVariable=".print_r($localIP , TRUE ), 'Test', 'Info'); } -------- ...
Read More
Creating sudoku in Jedox

Creating sudoku in Jedox

Primarily designed as a planning tool, Jedox offers a wide range of possibilities when it comes to development. If we forget for a second HR, cost center, or some financial consolidation model and let our creative mind flow, we could come to this kind of application. Sudoku is a game that is designed in matrix form where the goal is to fill the cells with numbers from 1 to 9 that are not repeating on any axes. For our little project, we will design a database that will keep scores of users and set up the Sudoku. Dimensions inside will be: User (Copied from System database)DayVersion of Sudoku [Easy,Medium,Advanced]Measure [Duration] For the Sudoku setup itself, we would have two dimensions Xaxe and Uaxe. Series of conditional formatting values will be responsible for checking if the numbers are in the correct order. Here you can find the whole project.   ...
Read More
Removing extra space in the Jedox report

Removing extra space in the Jedox report

Jedox spreedshets are powerfull place for your analysis. Since it is based on Excel funcionality some side effects can occure as well. One of this sideeffects is extra space in the report which cause higher memory usage. It could be identified if the report size is unusally high and performance while opening is extremelly low. (Example 250kb.) In order to fix it and decrease the size / increase the performance you will need to do the following set of actions: Click on the row under which it is nothing developed. (In this case 30th) Select A30:IV65356 and hit ENTER Delete all selected lines Tadaaaa!!! the new report is now of the proper size. More about Jedox Reports....
Read More