Show all rows

[mbrassfi]

Hi, this is probably an insanely easy question, but one that I just do not know the answer to.

I would like to show all rows regardless if there is current data for a piece of data. The rows are account number and I would like to show all 6 of them, with the year to date numbers being in the information area. Below is what I would like to show.  right now it just does not show the rows that are null.

thanks!

        YTD
5655     50
5667    100
5669   
5700    80
5780
5789

[blom0344]

Not insanely easy, but if you are familiar with the underlying model then probably solveable. In your case fact and dimension are probably inner joined, causing dimensional values that have no related fact to disappear from the resultset. Changing the cardinality is a possibility, but then all reports will be affected. An alternative is to

(1) build 2 queries and apply the join within report Studio with the proper cardinality.
(2) build a union where the second set fetches ALL dimensional values with a fake fact (zero)

The second approach will yield:

5655     50
5667    100
5669    0
5700    80
5780    0
5789    0

but you easily changes the zeroes to any other formatted value

[mbrassfi]

So the only solve is through cardinality, correct? There is no button or change of parameter that will change this?

[blom0344]

Solution (1) allows you to enforce a different cardinality, cause you define your own joins between queries.
Solution (2) circumvents the existing cardinality by means of a union

Cognos adheres to the definition of cardinalty from the model, so AFAIK there is no button to change this..