EazyBI: How can I calculate "next week" members instead of "previous week" and "current week" member

Ueli Jermann_b0yhpj

Good Evening all

For planning purposes I would like to show our team in EazyBI a overview over all planned values of a userdefined field from the next week or even next month.

I guess that I have to define a new calculated member, but I don't know how to define such a objekt.

Can anyone help me?

Regards Ueli

eazyBI Support

Hi @Ueli Jermann 
You can create new calculated members in the Time dimension. For next week, you can use this formula:

Aggregate({
[Time.Weekly].[Week].CurrentDateMember.NextMember
})

Please check that you create the member in Time.Weekly hierarchy and that you have added future Time date members. 

If you want to have next month then in the default Time hierarchy create this calculated member:

Aggregate({
[Time].[Month].CurrentDateMember.NextMember
})

 

You can learn more about the Time dimension in eazyBI documentation: https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/time-dimension

best, 
Gerda // support@eazyBI.com