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) Day Version 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