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