I have one concern as part of migration from CQM to DQM at framework manager in DMR
current scenario is that, we have three individual tables at database , so we have applied joined between three tables and took only required column into a query subject. this query subject is running fine .
now with the same query subject we have created DMR, this DMR is working fine in CQM query mode.
When we migrate the same above package from CQM to DQM .
The same DMR is not working. we got one solution is that if we apply member caption & member key for every table columns the hierarchy level is getting change(what we have existing).
If we apply this change in hierarchy level , it will effect all the existing reports.
Please share if any other solution without changes in DMR hierarchy level (after the migration from CQM to DQM).
------------------------------
Srikanth Balabathula
------------------------------
#CognosAnalyticswithWatson