All eazyBI for Jira eazyBI for Confluence Private eazyBI

NextMember

Returns the next member from the dimension in the level that contains a specified member.

Syntax

 Member_Expression.NextMember

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

The following example returns a previous month. 

[Time].[Month].CurrentDateMember.NextMember

See report example Issues created (bi-weekly) in our Demo account. The calculated measure Issues created for this and next week uses Next month for dimension Time in the weekly hierarchy.  This measure will calculate results for the next time period (imported in time dimension) vs the displayed one. 

Members of the Time dimension are created dynamically only for dates that have some data. For example, if the current month is January,  [Time].[Month].CurrentDateMember.NextMember will return February only if February data is imported and February created as month in the "Time" dimension. eazyBI imports date members if there is any activity per date. Add members to date range if you have missing periods in eazyBI.

See also