Urgent help needed

[lauriesamh]

Hi,I'm a very new Cognos user and working in Report studio and need a report done today.

I have created two queries (A & B)to pull data for current month and prior month (based on a parameter for Location & Date). Each query (A & B) groups data by Location & division and does counts, ratios of counts and percentage calculations. Each query runs correctly.

I'm trying to link the two queries (query C) in order to do comparisons of the current & prior month and when I do this the data for each month is incorrect.

In creating query (C) I added a join - linking the location & division with 1:1 cardinality as there will always be the same locations & divisions for each query.

Any help is appreciated.

Any ideas why the data when I pull into Query C is totally wrong?

 

[blom0344]

Depends on how you join the queries. The 1:1 cardinality itself is useless (= has no influence) if data is aggregated to location and division and you then join over location alone. You need to join over ALL non aggregated fields to enforce the 1:1 cardinality..

Ties Blom

 

[lauriesamh]

thanks that helped!