COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Niranjan81 on 06 Oct 2016 01:30:43 PM

Title: CQM To DQM , report level joins break
Post by: Niranjan81 on 06 Oct 2016 01:30:43 PM
Hi ,

We recently migrated few reports from CQM to DQM, and we are having issues with reports using report level joins.
when tried to troubleshoot using the native sql, the query that uses report level joins shows two individual select statements and the join I define , does not show up.
All my joins are correct and I tried all the filter types associated with the join operator. (10.2.2).

Any help is highly appreciated.

NC
Title: Re: CQM To DQM , report level joins break
Post by: cognostechie on 06 Oct 2016 02:15:52 PM
This is expected. Some reports will have to be re-written when they use a DQM package.