It's all about the answers!

Ask a question

How to combine data correctly from separate data source in Insight?


Shaff Raphael (5937) | asked Aug 06 '14, 11:32 p.m.
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


permanent link
Francesco Chiossi (5.7k1719) | answered Aug 07 '14, 4:11 a.m.
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
Shaff Raphael selected this answer as the correct answer

Your answer


Register or to post your answer.