Reports often timeout at month end

Questions & Answers
1

Hello! For some time now, we have experienced issues with getting the outofmemory exception error, particularly around our month end period (first 3-4 working days of a month). eazyBI is used more heavily across the business during this time, and particularly so in our Service Management team.

Our Atlassian support team have increased the memory allocation to eazyBI and it is now on a dedicated node, but we continue to experience the same issues. They are now saying we need to improve our reports/queries so that it uses less resource, and this is where I would appreciate some assistance please.

2

Hi @dwightman,

Improving report performance is excellent advice! The first step is identifying which reports cause the most problems. For that purpose, please enable the eazyBI usage statistics and monitor which reports fail the most and take the most time to load - Usage statistics.

I also recommend monitoring the report location. In some cases, demanding reports are published in Jira dashboards and get refreshed there very often, causing a slowdown for other users.

After that, please share the report definition that causes the most problems here or to the eazyBI support email - Export and import report definitions.

Best,
Roberts // support@eazybi.com

3

Hi Roberts,

Thanks for coming back to me. We have already got the usage statistics in place. In terms of the report location, the embedded and gadget reports/dashboards only make up approx. 6% of total report executions and the reports that create the errors are part of the Technical Service Operations project, which is the project that is causing almost all of the pain in our dashboards
image

One of the main reports that causing us issues is the one below and as you can see it fails over 90% of the time. I’ve attached the report definition as requested.

image
image817×75 7.53 KB

Apologies for doing this but I cannot upload a text file on this site, so am copying the definition of a report into the body of this email:

{
  "cube_name": "TSO Reports",
  "cube_reports": [ {
     "name": "Caused by Infra",
     "folder_name": "Sub-Task Reports",
     "result_view": "bar_chart",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Sports]","[Measures].[Casino]","[Measures].[Poker]","[Measures].[PAM]","[Measures].[Marketing]","[Measures].[Flutter Studios]"],"members":[{"depth":0,"full_name":"[Measures].[Sports]","format_string":"#,##0","report_specific":true,"name":"Sports","calculated":true},{"depth":0,"full_name":"[Measures].[Casino]","format_string":"#,##0","report_specific":true,"name":"Casino","calculated":true},{"depth":0,"full_name":"[Measures].[Poker]","format_string":"#,##0","report_specific":true,"name":"Poker","calculated":true},{"depth":0,"full_name":"[Measures].[PAM]","format_string":"#,##0","report_specific":true,"name":"PAM","calculated":true},{"depth":0,"full_name":"[Measures].[Marketing]","format_string":"#,##0","report_specific":true,"name":"Marketing","calculated":true},{"depth":0,"full_name":"[Measures].[Flutter Studios]","format_string":"#,##0","report_specific":true,"name":"Flutter Studios","calculated":true}]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[2023].[Q1 2023].[Mar 2023]","[Time].[2023].[Q2 2023].[Apr 2023]","[Time].[2023].[Q2 2023].[May 2023]","[Time].[2023].[Q2 2023].[Jun 2023]","[Time].[2023].[Q3 2023].[Jul 2023]","[Time].[2023].[Q3 2023].[Aug 2023]"],"members":[],"bookmarked_members":[]},{"name":"Priority","selected_set":["[Priority].[Major Incidents (P1 \u0026 P2)]"],"members":[{"depth":0,"name":"Major Incidents (P1 \u0026 P2)","full_name":"[Priority].[Major Incidents (P1 \u0026 P2)]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"removed":true}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Host(s)","selected_set":["[Host(s)].[All Host(s)s]","[Host(s)].[International]","[Host(s)].[US]"],"members":[{"depth":0,"name":"All Host(s)s","full_name":"[Host(s)].[All Host(s)s]","drillable":true,"type":"all","expanded":true,"drilled_into":false,"removed":true},{"depth":0,"name":"International","full_name":"[Host(s)].[International]","calculated":true,"drillable":true,"dimension":"Host(s)"}],"bookmarked_members":[],"current_page_members":["[Host(s)].[International]"]},{"name":"Responsible Squad(s)","selected_set":["[Responsible Squad(s)].[Infra \u0026 Platforms]"],"members":[{"depth":0,"name":"Infra \u0026 Platforms","full_name":"[Responsible Squad(s)].[Infra \u0026 Platforms]","calculated":true,"drillable":true,"dimension":"Responsible Squad(s)"}],"bookmarked_members":[],"current_page_members":["[Responsible Squad(s)].[Infra \u0026 Platforms]"]},{"name":"Time","duplicate":true,"selected_set":["[Time].[Last 6 Months]","[Time].[Last 6 + Current Month]"],"members":[{"depth":0,"name":"Last 6 Months","full_name":"[Time].[Last 6 Months]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"removed":true},{"depth":0,"name":"Last 6 + Current Month","full_name":"[Time].[Last 6 + Current Month]","calculated":true,"drillable":true,"dimension":"Time","expanded":true,"drilled_into":false},{"depth":3,"name":"Mar 2023","full_name":"[Time].[2023].[Q1 2023].[Mar 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"},{"depth":3,"name":"Apr 2023","full_name":"[Time].[2023].[Q2 2023].[Apr 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"},{"depth":3,"name":"May 2023","full_name":"[Time].[2023].[Q2 2023].[May 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"},{"depth":3,"name":"Jun 2023","full_name":"[Time].[2023].[Q2 2023].[Jun 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"},{"depth":3,"name":"Jul 2023","full_name":"[Time].[2023].[Q3 2023].[Jul 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"},{"depth":3,"name":"Aug 2023","full_name":"[Time].[2023].[Q3 2023].[Aug 2023]","drillable":true,"parent_full_name":"[Time].[Last 6 + Current Month]"}],"bookmarked_members":[],"current_page_members":["[Time].[2023].[Q1 2023].[Mar 2023]","[Time].[2023].[Q2 2023].[Apr 2023]","[Time].[2023].[Q2 2023].[May 2023]","[Time].[2023].[Q2 2023].[Jun 2023]","[Time].[2023].[Q3 2023].[Jul 2023]","[Time].[2023].[Q3 2023].[Aug 2023]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{},"font_size":"large"},"table":{"freeze_header":false}},"calculated_members":[{"dimension":"Measures","name":"Sports","formula":"(\n[Vertical].[PokerStars Sports],\n[Measures].[Count of Subtasks]\n)","format_string":""},{"dimension":"Measures","name":"Casino","formula":"(\n[Vertical].[Casino],\n[Measures].[Count of Subtasks]\n)","format_string":""},{"dimension":"Measures","name":"Poker","formula":"(\n[Vertical].[Poker],\n[Measures].[Count of Subtasks]\n)","format_string":""},{"dimension":"Measures","name":"PAM","formula":"(\n[Vertical].[PokerStars PAM],\n[Measures].[Count of Subtasks]\n)","format_string":""},{"dimension":"Measures","name":"Flutter Studios","formula":"(\n[Vertical].[Flutter Studios],\n[Measures].[Count of Subtasks]\n)","format_string":""},{"dimension":"Measures","name":"Marketing","formula":"(\n[Vertical].[Marketing],\n[Measures].[Count of Subtasks]\n)","format_string":""}]}
  } ],
  "calculated_members": [{"name":"PokerStars PAM","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[PAM - Accounts],\n  [Vertical].[PAM - Accounts Security],\n  [Vertical].[PAM - OpTech],\n  [Vertical].[PAM - Payments],\n  [Vertical].[Regulatory Compliance]\n  })","format_string":""},{"name":"International","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[IOM]\n  })","format_string":""},{"name":"Major Incidents (P1 \u0026 P2)","dimension":"Priority","formula":"Aggregate({\n  [Priority].[P1],\n  [Priority].[P2]\n  })","format_string":""},{"name":"PokerStars Sports","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Sports]\n  })","format_string":""},{"name":"US","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USNJ],\n  [Host(s)].[USPA],\n  [Host(s)].[USMI]\n  })","format_string":""},{"name":"Infra \u0026 Platforms","dimension":"Responsible Squad(s)","formula":"Aggregate(\n  Filter(\n    [Responsible Squad(s)].Members,\n    [Responsible Squad(s)].CurrentMember.Name MATCHES 'Infra.*'\n  )\n)","format_string":""},{"name":"Last 6 Months","dimension":"Time","formula":"Aggregate(\n  [Time].[Month].DateMembersBetween('7 months ago', 'Last Month')\n)","format_string":""},{"name":"Count of Subtasks","dimension":"Measures","formula":"iif([Measures].[Issues with Impact End Date]=0,0,\nCount(\nFilter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n[Measures].[Issues with Impact End Date]\u003e0\n)\n)\n)","format_string":""},{"name":"Last 6 + Current Month","dimension":"Time","formula":"Aggregate(\n  [Time].[Month].DateMembersBetween('6 months ago', 'today')\n)","format_string":""}]
}

Thanks in advance,
David

4

Hi @dwightman,

The performance problems stem from the calculated measure “Count of Subtasks”. It is referenced in all calculated measures selected in the report. See its formula below:

iif([Measures].[Issues with Impact End Date]=0,0,
Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues with Impact End Date]>0
)
)
)

This calculated measure iterates through all issues, returning the number of issues that have a value for the “Issues with Impact End Date” measure. By default, the measure “Issues with Impact End Date” should already return the number of issues, and the calculated measure “Count of Subtasks” shouldn’t be necessary.

One use case where iterating through issues could be necessary is where your report’s dimensions are based on multi-value fields. Are the “Host(s)” or “Responsible Squad(s)” multi-value custom fields? Suppose it is so. In such a case, I recommend improving the calculated measure “Count of Subtasks” formula:

IIf(
  [Measures].[Issues with Impact End Date] > 0,
  Count(Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IIF(
      [Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember,
      1,
      DateInPeriod(
        [Issue].CurrentHierarchyMember.Get('Impact End Date'),
        [Time].CurrentHierarchyMember
      )
    )
    AND
    [Measures].[Issues with Impact End Date] > 0
  )),
  0
)

Let me know how this goes.
Best,
Roberts // support@eazybi.com

5

Hi Roberts,

I’ve completed testing of the improvement you previously sent and it is not re-introducing the duplicate count. It certainly seems to perform better than the previous version I was using as well, so that is great, thank you.

We do still have issues, though, which I have been speaking to our Atlassian team about recently. We have a weekly report which was failing 96% of the time when we ran it last week. What is strange is that this report historically didn’t cause us that many issues (errored around the 60%-70% rate which I know is a lot, but we have worked with that in the past), so I looked through the usage statistics, and something seems to have happened between 16th and 23rd October as it’s been erroring between 82%-96% since then. The report definition is at the bottom of this message (sorry for the length of the message!)

Error Rates 2nd Oct 9th Oct 16th Oct 23rd Oct 30th Oct 6th Nov 13th Nov
Inc-Impacts Downtime Mins (3614) 68.75% 66.67% 57.89% 93.65% 96.46% 82.05% 96.05%
Inc-Impacts Uptime % (3612) 35.00% 66.67% 57.89% 89.06% 94.93% 82.05% 88.89%
Inc-Impacts MTT Recover (3613) 35.00% 66.67% 57.89% 91.57% 96.09% 82.05% 86.05%
Inc-Impacts Created (3611) 0% 0% 0% 0% 3.03% 0% 0%

Our Atlassian support team have advised that the week mentioned above was around the time when we allocated more memory to the eazyBI instance, which now stands at 6GB – our memory config is as follows:

image

Would you be able to help us get to the bottom of this relatively sudden drop in performance please? I’ve CCd our Atlassian specialist that I was speaking to about this issue yesterday.

As part of this investigation, I’ve noticed that the outofmemory error we receive is showing a lower MAX value than before. Could you advise what this value relates to please?

Old error which I believe equates to 10GB for max
image

New error which I believe equates to 4GB max value
image

Report Definition:

{
  "cube_name": "TSO Reports",
  "cube_reports": [ {
     "name": "Inc-Impacts Downtime Mins",
     "folder_name": "DW Test",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Inc-Impact Downtime in Minutes]"],"members":[]}]},"rows":{"dimensions":[{"name":"Vertical","selected_set":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]"],"members":[],"bookmarked_members":[]},{"name":"Host(s)","selected_set":["[Host(s)].[International]","[Host(s)].[New Jersey]","[Host(s)].[Pennsylvania]","[Host(s)].[Michigan]"],"members":[],"bookmarked_members":[]},{"name":"Priority","selected_set":["[Priority].[Major Incidents (P1 \u0026 P2)]"],"members":[{"depth":0,"name":"Major Incidents (P1 \u0026 P2)","full_name":"[Priority].[Major Incidents (P1 \u0026 P2)]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"removed":true}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Issue Type","selected_set":["[Issue Type].[Sub-Tasks]"],"members":[{"depth":0,"name":"Sub-Tasks","full_name":"[Issue Type].[Sub-Tasks]","calculated":true,"dimension":"Issue Type"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Sub-Tasks]"]},{"name":"Time","selected_set":["[Time].[Current month]"],"members":[{"depth":0,"name":"Current month","full_name":"[Time].[Current month]","annotations":{"group":"Default","predefined":"true"},"calculated":true,"drillable":true,"dimension":"Time"}],"bookmarked_members":[],"current_page_members":["[Time].[Current month]"]},{"name":"Vertical","duplicate":true,"selected_set":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]","[Vertical].[PokerStars Marketing]","[Vertical].[PokerStars StarsWeb]","[Vertical].[Flutter Studios ]"],"members":[{"depth":0,"name":"PokerStars Poker","full_name":"[Vertical].[PokerStars Poker]","calculated":true,"drillable":true},{"depth":0,"name":"PokerStars Casino","full_name":"[Vertical].[PokerStars Casino]","calculated":true,"drillable":true},{"depth":0,"name":"PokerStars Sports","full_name":"[Vertical].[PokerStars Sports]","calculated":true,"drillable":true},{"depth":0,"name":"Infra \u0026 Platforms","full_name":"[Vertical].[Infra \u0026 Platforms]","calculated":true,"drillable":true,"dimension":"Vertical"},{"depth":0,"name":"PokerStars PAM","full_name":"[Vertical].[PokerStars PAM]","calculated":true,"drillable":true,"dimension":"Vertical"}],"bookmarked_members":[],"current_page_members":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]"]},{"name":"Maintenance","selected_set":["[Maintenance].[Unplanned Downtime]"],"members":[{"depth":0,"name":"Unplanned Downtime","full_name":"[Maintenance].[Unplanned Downtime]","calculated":true,"drillable":true,"dimension":"Maintenance"}],"bookmarked_members":[],"current_page_members":["[Maintenance].[Unplanned Downtime]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":[]}
  } ],
  "calculated_members": [{"dimension":"Time","name":"Current month","format_string":"","formula":"Aggregate({\n  [Time].[Month].CurrentDateMember\n})"},{"name":"Unplanned Downtime","dimension":"Maintenance","formula":"Aggregate(\n  Filter(\n    [Maintenance].Members,\n    [Maintenance].CurrentMember.Name MATCHES \"No|.none.\"\n  ))","format_string":""},{"name":"PokerStars Poker","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Poker]\n  })","format_string":""},{"name":"PokerStars Casino","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Casino]\n  })","format_string":""},{"name":"PokerStars PAM","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[PAM - Accounts],\n  [Vertical].[PAM - Accounts Security],\n  [Vertical].[PAM - OpTech],\n  [Vertical].[PAM - Payments],\n  [Vertical].[Regulatory Compliance]\n  })","format_string":""},{"name":"International","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[IOM]\n  })","format_string":""},{"name":"New Jersey","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USNJ]\n  })","format_string":""},{"name":"Pennsylvania","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USPA]\n  })","format_string":""},{"name":"Major Incidents (P1 \u0026 P2)","dimension":"Priority","formula":"Aggregate({\n  [Priority].[P1],\n  [Priority].[P2]\n  })","format_string":""},{"name":"Michigan","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USMI]\n  })","format_string":""},{"name":"PokerStars Marketing","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Marketing]\n  })","format_string":""},{"name":"PokerStars Sports","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Sports]\n  })","format_string":""},{"name":"Infra \u0026 Platforms","dimension":"Vertical","formula":"Aggregate({\n[Vertical].[Infra - Cloud],\n[Vertical].[Infra - DBA],\n[Vertical].[Infra - SRE]\n})","format_string":""},{"name":"Sub-Tasks","dimension":"Issue Type","formula":"[Issue Type].[Sub-task]","format_string":""},{"name":"Inc-Impact Downtime in Minutes","dimension":"Measures","formula":"iif(isempty(\nsum(\n  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n  [Measures].[Issues with Impact End Date]\u003e0),\nDateDiffMinutes([Issue].CurrentMember.Get(\"Impact Start Date\"),[Issue].CurrentMember.Get(\"Impact End Date\"))\n)),\n0,\nsum(\n  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n  [Measures].[Issues with Impact End Date]\u003e0),\nDateDiffMinutes([Issue].CurrentMember.Get(\"Impact Start Date\"),[Issue].CurrentMember.Get(\"Impact End Date\"))\n))","format_string":"DaysHoursMinutesFormatter"},{"name":"PokerStars StarsWeb","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[StarsWeb]\n  })","format_string":""},{"name":"Flutter Studios ","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Flutter Studios]\n  })","format_string":""}]
}

{
  "cube_name": "TSO Reports",
  "cube_reports": [ {
     "name": "Inc-Impacts Downtime Mins",
     "folder_name": "DW Test",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Inc-Impact Downtime in Minutes]"],"members":[]}]},"rows":{"dimensions":[{"name":"Vertical","selected_set":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]"],"members":[],"bookmarked_members":[]},{"name":"Host(s)","selected_set":["[Host(s)].[International]","[Host(s)].[New Jersey]","[Host(s)].[Pennsylvania]","[Host(s)].[Michigan]"],"members":[],"bookmarked_members":[]},{"name":"Priority","selected_set":["[Priority].[Major Incidents (P1 \u0026 P2)]"],"members":[{"depth":0,"name":"Major Incidents (P1 \u0026 P2)","full_name":"[Priority].[Major Incidents (P1 \u0026 P2)]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"removed":true}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Issue Type","selected_set":["[Issue Type].[Sub-Tasks]"],"members":[{"depth":0,"name":"Sub-Tasks","full_name":"[Issue Type].[Sub-Tasks]","calculated":true,"dimension":"Issue Type"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Sub-Tasks]"]},{"name":"Time","selected_set":["[Time].[Current month]"],"members":[{"depth":0,"name":"Current month","full_name":"[Time].[Current month]","annotations":{"group":"Default","predefined":"true"},"calculated":true,"drillable":true,"dimension":"Time"}],"bookmarked_members":[],"current_page_members":["[Time].[Current month]"]},{"name":"Vertical","duplicate":true,"selected_set":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]","[Vertical].[PokerStars Marketing]","[Vertical].[PokerStars StarsWeb]","[Vertical].[Flutter Studios ]"],"members":[{"depth":0,"name":"PokerStars Poker","full_name":"[Vertical].[PokerStars Poker]","calculated":true,"drillable":true},{"depth":0,"name":"PokerStars Casino","full_name":"[Vertical].[PokerStars Casino]","calculated":true,"drillable":true},{"depth":0,"name":"PokerStars Sports","full_name":"[Vertical].[PokerStars Sports]","calculated":true,"drillable":true},{"depth":0,"name":"Infra \u0026 Platforms","full_name":"[Vertical].[Infra \u0026 Platforms]","calculated":true,"drillable":true,"dimension":"Vertical"},{"depth":0,"name":"PokerStars PAM","full_name":"[Vertical].[PokerStars PAM]","calculated":true,"drillable":true,"dimension":"Vertical"}],"bookmarked_members":[],"current_page_members":["[Vertical].[PokerStars Poker]","[Vertical].[PokerStars Casino]","[Vertical].[PokerStars Sports]","[Vertical].[Infra \u0026 Platforms]","[Vertical].[PokerStars PAM]"]},{"name":"Maintenance","selected_set":["[Maintenance].[Unplanned Downtime]"],"members":[{"depth":0,"name":"Unplanned Downtime","full_name":"[Maintenance].[Unplanned Downtime]","calculated":true,"drillable":true,"dimension":"Maintenance"}],"bookmarked_members":[],"current_page_members":["[Maintenance].[Unplanned Downtime]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":[]}
  } ],
  "calculated_members": [{"dimension":"Time","name":"Current month","format_string":"","formula":"Aggregate({\n  [Time].[Month].CurrentDateMember\n})"},{"name":"Unplanned Downtime","dimension":"Maintenance","formula":"Aggregate(\n  Filter(\n    [Maintenance].Members,\n    [Maintenance].CurrentMember.Name MATCHES \"No|.none.\"\n  ))","format_string":""},{"name":"PokerStars Poker","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Poker]\n  })","format_string":""},{"name":"PokerStars Casino","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Casino]\n  })","format_string":""},{"name":"PokerStars PAM","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[PAM - Accounts],\n  [Vertical].[PAM - Accounts Security],\n  [Vertical].[PAM - OpTech],\n  [Vertical].[PAM - Payments],\n  [Vertical].[Regulatory Compliance]\n  })","format_string":""},{"name":"International","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[IOM]\n  })","format_string":""},{"name":"New Jersey","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USNJ]\n  })","format_string":""},{"name":"Pennsylvania","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USPA]\n  })","format_string":""},{"name":"Major Incidents (P1 \u0026 P2)","dimension":"Priority","formula":"Aggregate({\n  [Priority].[P1],\n  [Priority].[P2]\n  })","format_string":""},{"name":"Michigan","dimension":"Host(s)","formula":"Aggregate({\n  [Host(s)].[USMI]\n  })","format_string":""},{"name":"PokerStars Marketing","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Marketing]\n  })","format_string":""},{"name":"PokerStars Sports","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Sports]\n  })","format_string":""},{"name":"Infra \u0026 Platforms","dimension":"Vertical","formula":"Aggregate({\n[Vertical].[Infra - Cloud],\n[Vertical].[Infra - DBA],\n[Vertical].[Infra - SRE]\n})","format_string":""},{"name":"Sub-Tasks","dimension":"Issue Type","formula":"[Issue Type].[Sub-task]","format_string":""},{"name":"Inc-Impact Downtime in Minutes","dimension":"Measures","formula":"iif(isempty(\nsum(\n  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n  [Measures].[Issues with Impact End Date]\u003e0),\nDateDiffMinutes([Issue].CurrentMember.Get(\"Impact Start Date\"),[Issue].CurrentMember.Get(\"Impact End Date\"))\n)),\n0,\nsum(\n  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n  [Measures].[Issues with Impact End Date]\u003e0),\nDateDiffMinutes([Issue].CurrentMember.Get(\"Impact Start Date\"),[Issue].CurrentMember.Get(\"Impact End Date\"))\n))","format_string":"DaysHoursMinutesFormatter"},{"name":"PokerStars StarsWeb","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[StarsWeb]\n  })","format_string":""},{"name":"Flutter Studios ","dimension":"Vertical","formula":"Aggregate({\n  [Vertical].[Flutter Studios]\n  })","format_string":""}]
}

Thanks

David

6

Hi @dwightman,

The eazyBI child process still depends on the free memory available in the Server. If other services have consumed memory, the eazyBI child process might not have the maximum memory available to it and encounter the out-of-memory error sooner. I recommend sharing the eazyBI log files to our support email support@eazybi.com or contact form - eazyBI.

For the report “Inc-Impacts Downtime Mins”, I recommend reducing the number of dimensions in the report rows, if possible. Try optimizing the calculated measure “Inc-Impact Downtime in Minutes”. I recommend using the formula below instead:

CASE WHEN [Measures].[Issues with Impact End Date] > 0
THEN
  Sum(
    Filter(
      Descendants([Issue].CurrentMember,[Issue].[Issue]),
      DateInPeriod(
        [Issue].CurrentMember.Get("Impact End Date"),
        [Time].CurrentHierarchyMember
      )
    ),
    CASE WHEN [Measures].[Issues with Impact End Date]>0
    THEN
      DateDiffMinutes(
        [Issue].CurrentMember.Get("Impact Start Date"),
        [Issue].CurrentMember.Get("Impact End Date")
      )
    END
  )
ELSE
  0
END

It is more efficient than the original because it iterates through issues once and has an issue property as the first condition in the Filter() function.

Best,