How to pass parameter from dmr prompt to relational report

[inu]

Hi Team,

I am developing a dashboard in portal page, in each cognos viewer different reports are there.
One of them is having prompts only holding dmr quries. which is communicating with other cognos viewer having dmr reports.
Now one more report is there using relational model in different cognos viewer,

Issue is, can we convert month or quarter key or year key of dmr into m.key/q.key/y.key of relational reports.


please suggest.


Regards,
Inam

[BigChris]

You might try experimenting with Captions...

[Ravisha]

Try using the dmr function 'roleValue' and extract the 'bussinessKey' of the level in the time dimension. Then, pass this newly created data item into the relational report. I've did it in the past and worked very well.

Cheers !