Jedox 4 Beginners

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 […]

Building Dynamic Calendars in Jedox In this guide, we’ll walk you through the process of crafting a calendar widget within the Jedox platform. This endeavor requires the presence of […]

Add element to the Jedox database via macro In this post, we are going to show you how to use multiple PALO functions in the macro to successfully add element in the dimension. For this purpose […]

Excel download using macro Here is one quick way to download a file as an Excel. In normal conditions, Jedox offers two possibilities to Export to Excel: XLSX […]

Dynamic denormalization One of the commonly used transformations in ETL is Table denormalization. Denormalization is the reverse of normalization. Row-based data with […]

Mapping Matrix When working with dimensions like products there must be a use-case when mapping matrix is necessary. This little mapping matrix is used when there […]

Best way to copy data without using the ETL During the planning process, there will be activities that require to copy data from the previous year or another version. There are multiple ways to […]

How to create a colour picker in Jedox? Jedox has a wide range of possibilities when it comes to reporting since it is working based on Excel technology. Having that in mind it might […]

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 […]

How to create paging in Jedox? When crafting reports in Jedox, it’s not uncommon to encounter scenarios where the large volume of rows becomes unwieldy. In such cases, the […]

Create slideshow widget in Jedox Jedox provides many possibilities when creating a report or a dashboard. Apart from native components like buttons, combo, and checkboxes, lists […]

Exchange rate Cubes In this post, we will show you examples of an exchange rate cube, a planning cube, and how to set up the rules between them. This topic is very […]

Version blending Version blending is functionality that brings actual figures to be visible in the forecast versions. Each forecast element in the Version di […]

Audit in Jedox When the cycle of planning starts it is important to track all inputs. One reason is for monitoring purposes [Who did when what and why] and the […]

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 […]

How to create a top 10 list of a certain dimension? The crucial part of every dashboard is the top 10 list analysis. Many companies would like to see what are their best-selling products, best […]

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 […]

Locked Dimensions and Cubes Technically speaking this is not a bug but a feature of Jedox software. Jedox has the possibility to lock a specific area of the cube in order to […]

Slowly Changing Dimensions Slowly Changing Dimensions are a recurring topic in Business Intelligence and Data Warehousing in general. Theterm describes the unpredictable […]