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.
Quote from: Cognos8 on 04 Feb 2015 08:23:25 AM
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.
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
Quote from: Cognos8 on 04 Feb 2015 11:57:28 PM
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.
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.
Quote from: Cognos8 on 05 Feb 2015 08:08:25 AM
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.