CQM To DQM , report level joins break

[Niranjan81]

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

[cognostechie]

This is expected. Some reports will have to be re-written when they use a DQM package.