Wrong Results in Impromptu 7

[dideb]

Hi all,
the following situation happens with me with different RDBMS:
i have 3 tables A, B and C
table A connected to table B by 4 PKs c1, c2, c3 & c4
table A connected to table C by the same PKs c1, c2, c3 & c4
the 2 joins are outer joins from table A

if i create a report with tables A & B or tables A & C: the results are OK

but if i create a report including columns from the three tables, results from tables B & C are duplicated like this:
Table B.c1 Table C.c1
1 1
2 1
1 2
2 2


So, where is the problem
Thanks in advance

 

[griffindm]

Diaa,

Can you show the missing column values from Table A in the results? I would help analysis.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[dideb]

Hi Dave,
thanks for your help, as usual.
10 minutes ago, the solution came to me by using a sub_report for table C.
This is because there is no relation between the entities of tables B & C, so they duplicate each other (or otherwise, create a kind of a cross product of rows from B & C that are related to A)

I didn't know the sub-report feature when i had the problem yesterday

I hope this helps others somehow new to Impromptu

 

[griffindm]

Diaa,

Glad to hear that it worked out for you. Yes, when you do a single report with a parent table, you can have only one other table that shares a many-to-1 relationship with that parent or else you get incorrect results due to duplication.

Sub-reports and drill-thru reports are power additions to the Impromptu report author's arsenal.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com