I am trying to define calculated member formula with below for Time dimension:
[Time].[Last 7 Days]
[Time].[Day].DateMembersBetween(‘7 days ago’,‘today’)
it is almost the same with the samples in jira demo, but I got errors like below:
No Function matches signature ‘.DateMembersBetween(,)’
could you please let me know why the errors showing?
Thanks a lot
The function DateMembersBetween is added since eazyBI version 5.1.0, see https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datemembersbetween.
In older versions there was a longer syntax to calculate the same:
[Time].[Day].DateMember('7 days ago'):
Lauma / firstname.lastname@example.org
Thanks a lot lauma, It is working.