COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lecarlos on 14 Aug 2011 04:05:42 PM

Title: drill through DMR report to relational report
Post by: lecarlos on 14 Aug 2011 04:05:42 PM
Hi Cognos Gurus,

Cognos environment: 10.1 Report studio, Framework manager (DMR) and Relational model. Backend is DB2.

I have created a report in report studio using DMR model which has 4 columns. We can drill down to the lowest level. Ex: A, B, C, D, etc

Also I have created a detail report using relational model.

The question now we need to drill through DMR report to detail report from each level.

For ex:  Report has level A, B, C, D
So if I am in Level A then if I want to see the detail we should be able to drill through to see the detail. Similar way we should be able to do it from each level.

Is it possible to do from DMR each level to detail report (relational model)?

Thanks in advance.