DMR- Drill thru at detail level

[Cognos8]

I have DMR report for which drill through option has to be enabled at detail level. when user navigate to the detail ( final) level right click and choose "Go To-> Related Links" it launches list of reports . Instead i need to launch the specific report.

I tried both options

1) In launch > Drill thru option
2) In report studio > drill thru definition > run the report using dynamic filter reporting

It passes only Hierarchy not passing the selected member value. So launches the target report , not for selected values.

[MFGF]

I have DMR report for which drill through option has to be enabled at detail level. when user navigate to the detail ( final) level right click and choose "Go To-> Related Links" it launches list of reports . Instead i need to launch the specific report.

I tried both options

1) In launch > Drill thru option
2) In report studio > drill thru definition > run the report using dynamic filter reporting

It passes only Hierarchy not passing the selected member value. So launches the target report , not for selected values.

Does this post help?

http://www.cognoise.com/community/index.php/topic,19458.msg57881.html#msg57881

MF.

[Cognos8]

Hi,

I tried the steps which you have given, but it did not work for me. So copied your xml and faced the same behaviour. i am missing something , your solution should work for my issue.  I dragged the current level in cross tab and it seems the values are not changing. it remains 1 for all evel. i think if it changes to 1 -- 2 -- 3 by clicking each level then it should work. not sure which one i am missing. Attached the screenshot

[MFGF]

Hi,

I tried the steps which you have given, but it did not work for me. So copied your xml and faced the same behaviour. i am missing something , your solution should work for my issue.  I dragged the current level in cross tab and it seems the values are not changing. it remains 1 for all evel. i think if it changes to 1 -- 2 -- 3 by clicking each level then it should work. not sure which one i am missing. Attached the screenshot

Hi,

Just to clarify, the solution I posted here expects you to left-click on the links (to drill down then to drill through from the lowest level), not right-click and use "Go to". Is that what you're doing?

MF.

[Cognos8]

Hi,

I found solution but by just violating one best practice which will not be accepted. Attached the report xml.

I followed almost similar like yours .. with few changes to achieve drill thru by clicking measure at detail level ..

1. currlevel  is -- > roleValue('_levelNumber',[Sales].[Products].[Products])
2. Used string variable  and define as  --[Query1].[Currlevel] ... since it sting i did not mentioned like  -[Query1].[Currlevel] = 3 which you defined.
3. By doing this i can drill thru at lowest level, but it pops up target report prompt. To avoid this i just copied the cross tab and paste it in source report itself. Then i choose box type = none for first cross tab. This works as expected.

Please provide your comments to avoid duplcaiting the cross tab.

[MFGF]

Hi,

I found solution but by just violating one best practice which will not be accepted. Attached the report xml.

I followed almost similar like yours .. with few changes to achieve drill thru by clicking measure at detail level ..

1. currlevel  is -- > roleValue('_levelNumber',[Sales].[Products].[Products])
2. Used string variable  and define as  --[Query1].[Currlevel] ... since it sting i did not mentioned like  -[Query1].[Currlevel] = 3 which you defined.
3. By doing this i can drill thru at lowest level, but it pops up target report prompt. To avoid this i just copied the cross tab and paste it in source report itself. Then i choose box type = none for first cross tab. This works as expected.

Please provide your comments to avoid duplcaiting the cross tab.

Hi,

I'm looking at your source report and I don't see a conditional block inside the row heading of either crosstab? There's no reason you should need a hidden crosstab if you follow the steps I posted.

MF.