ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Slow reports, no nonemptycrossjoin for expanded lv

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
m.andrysz Posted - 06/26/2024 : 03:17:12
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,
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 06/26/2024 : 17:55:34
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)

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page