Jedox Datepicker 101: Creating Flexible Dynamic Ranges for Data Analysis
One of the features of Jedox is the Datepicker, a user-friendly interface that allows you to select dates, periods, and other parameters to filter and analyze your data. In this article, we'll show you how to create a dynamic range between two dates using the Jedox Datepicker. A dynamic range is a flexible range that automatically adjusts to include new data, and it can be a powerful tool for analyzing trends and making predictions.
Before we create a report you need to prepare the following things:
Create a Day dimension using a Day template
Create additional attribute DayValue2
Create a rule which duplicates data from DayValue to DayValue2
Datepicker RULE
After this is done let us create the spreadsheet report:
Add two data pickers
Add their values in the sheet and save them as a namerange Attribute
Add Dyna range and in the Attribute, section use the variable "Attribute"
=PALO.SUBSET("localhost/Datepicker","Day",1,,,,,PALO.AFILTER(Attribute,0,{true,true,true,true,true,true,true,true,true,true,true}),,PALO.SORT(1,0,,0,,0,0,,))
Save it and you are ready to go. This will now provide a more flexible and customizable approach to data analysis...