If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

drill through from DMR report to Relational report

Started by tamirv, 27 Mar 2013 03:50:12 AM

Previous topic - Next topic

tamirv

hi,
i need to do a drill through from DMR to Relational report using Dynamical Drill through and parameters.
the problem is that the source report (DMR) is sending the MUN and not the value itself. for example when i filtering order method fax istead of sending the value - fax, the report send the mun (Sales].[Order method].[Order method].[Order method type]->[Order method].[601])
how can i send the value from the source report (DMR) to the target report (relational)?

thanks,
Tamir

cognostechie

There are options to pass the value as Member Caption which you can select when you create the drill thru.

tamirv

i have already try it. but still the use value in the target is the MUN :-(

cognostechie

I just did it. It works fine. I didn't even have to choose anything from 'Property to Pass' option. Just left it as default and it works fine.

How do you know it is passing the MUN?

tamirv

in the target report i display the parameter : ParamValue('Par_Order_method')
and i am getting : [Sales].[Order method].[Order method].[Order method type]->[Order method].[601]

MFGF

Very strange. I get the same results as cognostechie. What version of Cognos 10 are you using?

Regards,

MF.
Meep!

tamirv

i cuild the reports again and now it is working great.
thank you!
i have another question :
i build a drill through and i named it "drill from dmr to rel"
in the source report i do right click and the i choose go to.
in the next step i want that the name of the drills will apear upon the "related links".
how can i do that?
for now i click on the "related link", then a new window is up with the list of the drills i built.
i hope i was clear at my question.

tamir