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

resolved - One List Report, Column from 2 Fact tables

Started by cogtrack, 05 Jul 2016 08:53:03 AM

Previous topic - Next topic

cogtrack

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