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 Shaff Raphael selected this answer as the correct answer
|