ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

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

Check here to include your profile signature.
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