We have created a report in report  using DMR model which has 3 levels in my dimension . We can drill down to the lowest level. Ex: States>counties>zip code  
Also I have created a detail report using relational model. 

We  need to drill through DMR report lowest level (zip code) only  to detail report . 
Please let us know solution  to do from DMR lowest level to detail report (relational model) ?

 

Env : Cognos R13 , Framework manager (DMR) and Relational model. Back end is DB2.

Appreciated your response  

Thanks

------------------------------
Chandra Medarametla
------------------------------

#CognosAnalyticswithWatson

Hello Chandra,
To be able to drill-through only on the zip code level, you will need to create a data item that will calculate at which level you are in the hierarchy. The calculation would look something like: ordinal (level(currentMember([Sales (analysis)].[Products].[Products]))) and add it to the properties of the Crosstab rows. Next, you would unlock the report and drag in the States dimension again in the the Crosstab Rows, so there would be 2 state dimensions side by side (not nested) and setup the drill-through on only one of the Text items (In your case, one of the States dimensions). Then you can conditionally render one of the state dimensions based on where you are in the hierarchy. 

I've attached my sample source and target report specs for you to review.

------------------------------
DENNY NAREZNY
------------------------------

@DENNY NAREZNY​ - Thank you.

------------------------------
Chandra Medarametla
------------------------------

Original Message:
Sent: 03-28-2019 05:12 PM
From: DENNY NAREZNY
Subject: DMR report to Relational report Drill Through

Hello Chandra,
To be able to drill-through only on the zip code level, you will need to create a data item that will calculate at which level you are in the hierarchy. The calculation would look something like: ordinal (level(currentMember([Sales (analysis)].[Products].[Products]))) and add it to the properties of the Crosstab rows. Next, you would unlock the report and drag in the States dimension again in the the Crosstab Rows, so there would be 2 state dimensions side by side (not nested) and setup the drill-through on only one of the Text items (In your case, one of the States dimensions). Then you can conditionally render one of the state dimensions based on where you are in the hierarchy. 

I've attached my sample source and target report specs for you to review.

------------------------------
DENNY NAREZNY
------------------------------