Sprint dimension and it's property

Hi,

I have created a member formula that aggregate all future sprint but I also display sprints that have been deleted. I would like to be able to “remove” those sprints from my formula. Is there a Sprint property “Deleted” ?

Aggregate(
Order(
Filter
(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean(‘Closed’)
AND
[Sprint].CurrentMember.Name <> ‘(no sprint)’
),
[Sprint].CurrentMember.Name,
BASC
)
)

Thanks

eazyBI does not create sprints in Sprint dimension if they were deleted. However, if you had imported Sprint before it was deleted in Jira, you may want to run full data re-import in the cube with Empty data option.

eazyBI does not delete most dimension members during import. You would like to go to tab Analyze and select an option Empty for the Jira issue cube. Then go to tab Source Data and run import for Jira issues.

Daina / support@eazybi.com