COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: cogtrack on 05 Jul 2016 08:53:03 AM

Title: resolved - One List Report, Column from 2 Fact tables
Post by: cogtrack on 05 Jul 2016 08:53:03 AM
In database, have
Table Date     
2016-07-01   

Table B:
Date                         Export
2016-07-01                US
2016-07-01                Mexico

Table C:
Date                         Manufacture         
2016-07-01                GM

Need Create a Package for Ad-Hoc report(Business user)
Export and Manufacture have no business relationship,
there is one user want to create a report display like this

Date                         Export          Manufacture           
2016-07-01                US                     GM   
2016-07-01                Mexico            (leave empty here)

how to leave Manufacture column empty for 2nd row? Thanks a lot for you help.
what I get now is
Date                         Export          Manufacture           
2016-07-01                US                     GM   
2016-07-01                Mexico               GM