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

[Ueli Jermann]

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 · Accepted solution]

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
 

[Ueli Jermann]

Works perfect - thanks a lot

[Fabian Lim]

Hi @Ueli Jermann

You can refer to this example here which is set to months, but you can modify the time dimension options to be by week: https://eazybi.com/accounts/1000/cubes/Issues/reports/499768-risk-chart-by-status-and-priority

Regards