Cognos report studio DQM

[Niranjan_9]

Hi ,
We have recently migrated one report from CQE to DQM. at the same time the database is changed from Greenplum to Impala.
I see that in DQM the report level joins are not working as expected.
I also noticed that the generated sql in the earlier report returns a whole select statement, but in DQM the generated sql shows individual selects for each table and that's the reason we are getting errors, it always refers to the first table in the error.
I am exploring the options of Rollup processing and processing in report studio.
I am also giving a thought about the governor settings in FM for DQM.
Anyone faced this kind of issue and any workaround is highly appreciated.
Thanks very much.
Niranjan