Report Portal

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: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Message: * HTML is ON * Forum Code is OFF Smilies [quote][i]Originally posted by m.andrysz[/i] [br]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? <img src="https://i.postimg.cc/GmhhbPvv/Screenshot-2024-06-26-104414.png"> Regards, [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.