How to combine data correctly from separate data source in Insight?
I'm facing problem in generating my report in Report Studio when I drag data from different data source in Insight. To create my report I took some of data in Reporting Data Model and some from Operational Data Store. Eventually the result of the report were mixed up. I did the filtering things but it still cannot synchronize between data from that different data source. How to fix this?
Accepted answer
Hello Shaff,
if you build reports using 2 unrelated sets of data, they should have at least one identifier in common.
You can use that identifier in a join to correctly match the data.
See the following link on how to create a join:
Create a Join Relationship
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.1.doc/t_cr_rptstd_wrkdat_create_join_relationship_rel.html%23cr_rptstd_wrkdat_create_join_relationship_rel?lang=en
Best Regards,
Francesco Chiossi
if you build reports using 2 unrelated sets of data, they should have at least one identifier in common.
You can use that identifier in a join to correctly match the data.
See the following link on how to create a join:
Create a Join Relationship
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.1.doc/t_cr_rptstd_wrkdat_create_join_relationship_rel.html%23cr_rptstd_wrkdat_create_join_relationship_rel?lang=en
Best Regards,
Francesco Chiossi