If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos 11 List report doesnt work when I have summary rows in the list

Started by zgeorge, 12 Mar 2019 12:01:47 PM

Previous topic - Next topic

zgeorge

Hello Cognos Masters!

I have a simple list report with Business Unit, Product Type, YTD Sales and a column that is finding the topCount([Marketing Name], 1 , [YTD Sales]). I've attached an image of my list report to help visualize the report.

My customer wants to see the YTD sales for Product Type and next to it, wants to see the Top selling [Marketing Name] that falls under the product type. In our case, a product type can have multiple marketing names but a marketing name can only have one product type.

What I've finding is that when I run the report WITHOUT any summary rows in the list, the report works perfectly as expected. When I add a summary by Product Type, the report gives me the following error:

XQE-GEN-0005 Found an internal error:
java.lang.NullPointerException



Any help on this would be greatly appreciated.

Francis aka khayman

does adding summary achieves what your customer wants? or you are just curious why there is an error when you add summary to your list?

Kiran P

Hi,

Make sure any null/empty values for your measures are converted to 0.  In my case, I use coalesce(<data item>,0) which solves the null pointer exception.

Kiran