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.7k11119) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.