Tag: presenting future dates

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...