Join between two report packages

[nimda]

Hello

I have been asked to make report showing Server name, Processor count, RAM Size, Hard drive size(s) and backup data size.
Server details and backup details are from different report packages and are in 3 different tables; server info, storage and backup.

What I have done so far is two queries; one for server details and one for storage.
Server detail query gets name, processor count, ram size. Storage query gets total size for all hard drive for that server.
Then these queries are joined. Output is like this:

|SERVER01|1|2048|500 - Server01 with 1 cpu, 2048ram and 500gb hdd
|SERVER02|4|8192|2500 ...

This is working so far. Adding backup data seems problematic. I created this query using another report package and then copied the generated SQL. It gets the data correctly.

|SERVER01-BACKUPPOOL|4000
|SERVER02-BACKUPPOOL|12000

Because our backup system doesn't understand server name, but only backup pool names I generate this in server detail query. BackupPoolName = [Server_Name] +'-BACKUPPOOL'
Then I try to make join using server details and backup queries. ServerDetails.BackupPoolName is set as master of Backup.BackupPoolName. When I make list out of this joined query I get only right or left side of the join. Closest to working output is:


|SERVER1|1|2048  |500  |
|SERVER2|4 |8129 |2500|
|              |   |         |        |500
|              |   |         |        |2500

I have tried changing cardinality and other parameters of the join.  I'm still really new to Cognos and I'm not really sure if this is even possible so all help is appreciated!

[Lynn]

Try changing the aggregation method for each of your items in the joined query to maximum.