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 with out changes in DMR hierarchy level(after the migration from CQM to DQM)
------------------------------
Srikanth Balabathula
------------------------------
#CognosAnalyticswithWatson