COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: Eugene on 26 Nov 2020 02:54:18 PM

Title: Crosstab cannot display all the values
Post by: Eugene on 26 Nov 2020 02:54:18 PM
Deal all,


I have a data module which contains 5 data sets. From these 5 tables I create a Union Table.
Then  I use this data module as a source for a Dashboard. I go to dashboard and create a crosstab from the union table.
But when I am using a data item at the crosstab, I cannot see all the values of this data item.
Also I go and create a list at the dashboard and use the same data item and all the values appears.   

Do you know why this is happening ?

Thanks in advance.
Title: Re: Crosstab cannot display all the values
Post by: so10070 on 03 Jan 2021 04:53:53 AM
I have the same problem with datasets, not with the uploaden Excels (= a former form of my dashboard it worked well).  And not all sets geven this problem. Even don't know why?
Title: Re: Crosstab cannot display all the values
Post by: so10070 on 04 Jan 2021 06:29:33 AM
I have found the solution for this problem on my dashboard.  I set the value on the numeric field (characteristic "summarize") to "sum" and my values appaers.