Create a calendar in Jedox

Create a calendar in Jedox

In this article, we will show you how to create a calendar widget inside Jedox. For this task, we will need a Day dimension filled with additional attributes NextDay. Idea is to create a calendar that can be extended with additional dimensions and serve as a data planning area. Possible use cases could be task planning, reminders, planning cycles availability, etc. Everything is built on a spreadsheet without any coding knowledge. We could say that Excel familiarity is sufficient. Creating Time dimension For this task, we will use simple dimension creating where Dimension Template will be Day. That dimension we will extend with an additional attribute called NextDay which is generated by ETL. NextDay will represent Date +1. The transformation function used is Previous. Example: [2022-05-02-----> 2022-05-03] Calendar Creation Once we have all the necessary elements we can start building up the template in a spreadsheet. The template will be mixed with excel formulas and conditional formattings. Selected month dates cells will be colored in white and...
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
Create slideshow widget in Jedox

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 and dynaranges Jedox allow developers to code their own widgets. One of them could be the slideshow widget. This widget can make your dashboard more interactive and interesting. Widgets in Jedox are coded via HTML and this is how you can create one. For our example, we will use Biker's best database whereas for dimension Product we will add attribute images. Value of attribute is the location of the image behind [ Example /pr/jedox/images/Bikes/Mountain Bikes.png ] Idea is to create an array of elements that could be used in the widget, which will contain: Product NameProduct ImageData of selected MeasureMeasure That we will do with Dynarange and it should look something like this: Since coding behind the widget is a bit complex there will be a project available for download here. To learn more about widgets and what possibilities you can have with them check the...
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