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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Show all rows

Started by mbrassfi, 07 Apr 2010 12:28:50 AM

Previous topic - Next topic

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..