I have a cognos report where in I am getting count distinct of a certain column and taking that data in a crosstab which is driven by a date prompt. I can see data for most of the dates but in some cases it does not show any data which should not be the case as the view tabular data of that particular query shows results.
1 Answers
The tabular result is a flat list whereas the Crosstab will create a 3 dimensional cube in the background. When you run the tabular result you will see a message stating that what you see may not be what you get, given the summarization is disabled as well for the test.
For the missing crosstab cells, if could be that the particular intersection between the rows and columns does not actually have any data.
Related