Report is taking long time to load if am using custom measure to get the count of issues if custom date field is empty
Custom Measure used for the report
IsEmpty([Measures].[Issue Fix Date]) AND
([Measures].[Issue type] = “Defect”)
– counter by measure works as a filter as well:
Caclautions that iterate through individual issues (Descendants of Issue dimension) are precise but quite resourceful and might impact report performance.
You might look for a different approach to identifying unresolved issues without a fix date.
- When you import a date field, eazyBI creates a new measure, “Issues with XXX date”, in your case, “Issues with fix date”. You might want to use this measure to identify issues that have a date field and then subtract them from all issue amount to find issues without the fix date.
- And use the dimension “Resolution” to identify unresolved issues (without resolution).
Using those building blocks, you may rewrite the calculated measure using a tuple expression that works faster.
--all unresolved defects
--substract unresolved defects that have Fix Date
([Measures].[Issues with Fix date],
Here are more details available measures for custom date fields and tuple expressions:
Zane / support@eazyBI.com
Thanks much Zane for the solution . Using the provided solution measure now report is not taking much time for loading.