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

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Issue with Bottom Count on OLAP reports
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  


81 Posts

Posted - 08/01/2019 :  09:12:25  Show Profile  Reply with Quote

I just noticed that when using the Bottom Count function on OLAP reports, the function "NonEmptyCrossJoin" will be used even if it is unticked from the report options. This does not happen with Top Count, where the MDX is correct. For instance, when using Top Count, this kind of MDX is generated:

TopCount(DISTINCT({AddCalculatedMembers({[Customer].[Customer Group].[Customer Group].AllMembers})}),5,([Invoice Date].[Invoice Year].&[2019], [Measures].[Std Marg var to Previous Year - Mnth]))

With Bottom Count, on the same report (where "NonEmptyCrossJoin" is unticked on the options), we are getting:

BottomCount(NonEmptyCrossjoin(DISTINCT({AddCalculatedMembers({[Customer].[Customer Group].[Customer Group].AllMembers})})),5,([Invoice Date].[Invoice Year].&[2019], [Measures].[Std Marg var to Previous Year - Mnth])))

This issue is urgent enough for us; could you please check it and send us an hotfix if hopefully it can be fixed easily? Thanks.

François Dranguet
Information Manager
Scott Bader Group


1609 Posts

Posted - 08/01/2019 :  20:41:08  Show Profile  Reply with Quote
This is a feature, not a bug. The idea is to show bottom-n members that have data. For example, you have sales for first 6 months out of 12. Without NonEmptyCrossjoin you will see last two months without sales data. This is not an issue for top-n.

From Main.js, Line 408
function NonEmptyCrossjoin2(sDim){
if (sTopOnlyFormula.substr(0,6)=="Bottom"){
return "NonEmptyCrossjoin(" + sDim + ")";
return sDim;

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000