ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Slow reports, no nonemptycrossjoin for expanded lv
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

m.andrysz

United Kingdom
6 Posts

Posted - 06/26/2024 :  03:17:12  Show Profile  Reply with Quote
Hi,

We are experiencing some issues with the OLAP reports with two attributes: one is fully expanded, and the second is only on a certain level (Please see the screenshot). It looks like the MDX building engine does not apply nonemptycrossjoin to the second level of hierarchy and does only the asterics intersection.

When trying to replicate an issue in your test environment, we can see that the engine builds similar MDX code but can't observe the same detriment in the report generation.

When we applied nonemptycrossjoin manually to the highlighted similar section on our side, the same report performed much faster.

Is this a bug, and should the MDX builder use nonemptycrossjoin for that section, or is something else wrong on our side?



Regards,

Edited by - m.andrysz on 06/26/2024 03:58:16

admin

1637 Posts

Posted - 06/26/2024 :  17:55:34  Show Profile  Reply with Quote
Please try this fix:

1. Download and unzip: http://reportportal.us/upload73/upload/rp_208_olap_main_NonEmptyCrossjoin.zip
2. Backup old file and copy unzipped file to "C:\inetpub\wwwroot\ReportPortal\olap\script\main.js"
3. Clear browser cache (Admin > Settings > Version)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page