Jedox, the versatile business intelligence and performance management solution, offers a range of features to streamline data analysis and visualization. In this article, we’ll dive into the capabilities of Jedox ComboBox and explore how it can be used to present future dates in a user-friendly manner. We’ll guide you through a step-by-step process to leverage this functionality, opening up new possibilities for data exploration and decision-making. So let’s get started!
As a pre-requirement, we will need a Day dimension in some of your databases.
Step by Step: Presenting Future Dates in Jedox ComboBox
- 1: Retrieve the Current Date using TODAY().
- 2: Convert the Current Date to the Day Dimension Format.
- 3: Return the DayValue Attribute: In this step, we retrieve the DayValue attribute, which represents the current date in integer format.
- 4: Set a Named Range for Attribute Filtering: We establish a named range in Jedox, which allows us to conveniently filter the DayValue attribute.
- 5: Create a ComboBox and Apply the Attribute Filter.
- 6: Get your dates in combobox.
This functionality is particularly useful in various use cases, such as financial forecasting, sales planning, project scheduling, and resource allocation. By empowering users to conveniently select future dates, Jedox ComboBox enhances efficiency and accuracy in analyzing and predicting trends.
You can download the example here.