Hi team
i created a new calculated member in the issue dimension to filter issues which contain WHD in summary .
This is my calculated member
Aggregate(
Filter(
[Issue].[Issue].Members,
[Issue].CurrentHierarchyMember.Name matches "(?i).*WHD.*"
)
)
The problem is really the report is very very slow
I dont like to create a custom field can you please provides me other solution to make my report not slow.
I teyed to defined a new user defined measure , i just copy the code from open issue measure and i just edit the first line to filter issue by summary but it didnt works .
This is my user defined measure
CASE WHEN
[Issue].CurrentHierarchyMember.Name MATCHES "(?i).*WHD.*" THEN
Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
Cache([Measures].[Issues created]
- [Measures].[Issues resolved])
))
+ [Measures].[Issues created]
- [Measures].[Issues resolved]
)
ELSE
-- optimized formula for drill through Issue
NonZero(IIF(
DateBeforePeriodEnd(
[Issue].CurrentMember.get('Created at'),
[Time].CurrentHierarchyMember) AND
NOT DateBeforePeriodEnd(
[Issue].CurrentMember.get('Resolved at'),
[Time].CurrentHierarchyMember),
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]),
0
))
END
Thankyou in advance
Regards
Karim