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 a Day dimension enriched with an additional attribute named ‘NextDay.’ The overarching goal is to fashion a dynamic calendar capable of accommodating additional dimensions, effectively transforming it into a versatile data planning hub. This widget can prove invaluable for various use cases such as task planning, reminders, and monitoring planning cycles availability, all achieved seamlessly within a spreadsheet environment without the need for any coding expertise. Basic familiarity with Excel is all that is required.
Creating the Time Dimension
The foundation of our calendar widget is laid with the creation of a Time dimension. Utilizing a straightforward dimension creation approach, we will employ the Dimension Template ‘Day.’ This template will undergo augmentation with an extra attribute known as ‘NextDay,’ dynamically generated through Extract, Transform, Load (ETL) processes. The ‘NextDay’ attribute serves as a representation of the following day (Date +1).
By following these steps, we pave the way for a comprehensive calendar widget that aligns with your unique business needs. Let’s dive into the process, where the power of Jedox converges with the simplicity of spreadsheet manipulation, making advanced data planning accessible to all.
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 formatting. Selected month date cells will be coloured in white and others in grey. For simplicity reasons, we will just upload the whole widget here so it’s open for editing. The output should look like this:
Here you can download the whole project idea.