Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Sep 6, 2023

Add an attribute to the time dimension to categorize dimension element (year, month, day)

Everything is in the title, but for some specification here's the complete idea :

What ?

Add an attribute "Category" or "TimeType" that categorize element in the dimension. So for element like :

  • 2022-01-01 or 2023-05-01 the attribute should have the value "Day"

  • 2022-01 or 2023-05 the attribute should have the value "Month"

  • 2022-01_YTD or 2023-05_YTG the attribute should have respectively the value "YTD_Months" and "YTD_Months"

  • 2022-Q1 or 2023-Q2 the attribute should have the value "Quarter"

  • 2022 or 2023 the attirbute should have the value "Year"

  • All Months, All Days or All years the attribute should have the value "All"

For what ?

To be more efficient when filtering in many case. On the dynarange for example it would be more easier to use this attribute than use a regex of a complexe method to get only the year for example.

    Sep 8, 2023

    Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.