Is a new hierarchy possible in time dimension?

Is a new hierarchy possible in time dimension?

Eazybi currently
year → quarter → month → day
–2022
—Q1
-----Jan 2022
-----Feb 2022
-----Mar 2022
—Q2

new hierarchy
Year → four months → month → day

–2022
—Q1
-----Jan 2022
-----Feb 2022
-----Mar 2022
-----Apr 2022
—Q2

I thought about creating a calculated field, but I didn’t want to have to maintain this field whenever the year changes, if it could be something automatic it would be perfect!

Is it possible to have this new hierarchy in the time dimension?

Hi @DanteBRSP

We are currently working on the possibility of defining Custom Time hierarchies that would also allow you to change the sizes of the quarters to four months etc.

I currently can’t provide any dates when this will be implemented, but we’ll let you know when this feature is available! :slight_smile:

​Best regards,
​Nauris / eazyBI support

Thanks @nauris.malitis

I was thinking of creating a calculated field using relative dates to try to get what I need…

for example

Q1 (Four Months)
First day of the year and 120 days after

Q2 (Four Months)
121 days and 240 days

Q3 (Four Months)
241 days and last day of the year

Could you let me know if this is possible to create?

Hi, @DanteBRSP

Try this:

Q1
Aggregate(
{[Time].[Year].CurrentDateMember.FirstChild.FirstChild:
[Time].[Year].CurrentDateMember.FirstChild.NextMember.FirstChild}
)

Q2
Aggregate(
{[Time].[Year].CurrentDateMember.FirstChild.lead(1).FirstChild.lead(1):
[Time].[Year].CurrentDateMember.FirstChild.lead(2).FirstChild.lead(1)}
)

Q3
Aggregate(
{[Time].[Year].CurrentDateMember.FirstChild.lead(2).FirstChild.lead(2):
[Time].[Year].CurrentDateMember.FirstChild.lead(3).FirstChild.lead(2)}
)

1 Like